Originally posted by Shestakov
SQL> select pool, sum(bytes) from V$SGASTAT group by pool;

POOL SUM(BYTES)
----------- ----------
java pool 24002560
large pool 2000000
shared pool 65806948
...
...

This is current size of pools.
Hi,

It seems I am not able to explain my question properly.

For an old running database, how to determine the size of SHARED_POOL_SIZE and DB_BLOCK_BUFFERS.

For SHARED_POOL_SIZE, I follow the formula, which I have posted here.

For DB_BLOCK_BUFFERS, I don't know.