How to check SAP Oracle Shared Pool Size - SQL Query

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


Note: If the value is lower than 150 MB, increase it to at least 150 MB (400 MB is better), and restart the database.
Share this article :

Post a Comment

 
Copyright © 2011. SAP BASIS ANSWERS | SAP BASIS ADMIN BLOG - All Rights Reserved
T C P M
Proudly powered by Blogger