Hi,
Can somebody confirm the forumla for sizing SHARED_POOL_SIZE?
select sum(sharable_mem) from v$db_object_cache;
select sum(sharable_mem) from v$sqlarea;
select sum(250 * users_opening) from v$sqlarea;
Sum of all above sums...
In my database, sum comes to 525 MB. We are running Oracle Financials apps. I have pinned all packages. Still, I wonder if it can be so big.
I do not know if there is such formula for DB_BLOCK_BUFFERS too.
Does any body know?
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart