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.