Determine pool sizes


SQL> select pool, sum(bytes)/1024/1024 Mbytes from v$sgastat group by pool;

POOL MBYTES
------------ ----------
java pool 4
large pool 4
shared pool 148