Skip to Content
0
Former Member
Feb 09, 2011 at 10:28 PM

Parameter value of shared_pool_size:

1672 Views

Hi i need to check the parameters value from twho shared_pool parameters

Check the value of parameter shared_pool_size:

select NAME, VALUE from v$parameter where name='shared_pool_size';

select NAME, VALUE from v$parameter where name='shared_pool_reserved_size';

If the value is lower than 150 MB, increase it to at least 150 MB (400 MB is better), and restart the database. For more information, see SAP Note 556764.

My results of that queries are:

shared_pool_size

419430400

shared_pool_reserved_size

20971520

Then my question is, in what unit are this values, What value I have set to filled the requirement of 400MB in both parameters

Thanks a lot