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