print this page
Latest Post
Showing posts with label Basis Oracle FAQ. Show all posts
Showing posts with label Basis Oracle FAQ. Show all posts

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.
 
Copyright © 2011. SAP BASIS ANSWERS | SAP BASIS ADMIN BLOG - All Rights Reserved
T C P M
Proudly powered by Blogger