compute sum of bytes on pool
SQL> break on pool skip 1
SQL> select pool, name, bytes
2 from v$sgastat
3 where rownum < 20
4 order by pool, name;
POOL NAME BYTES
------------ -------------------------- ----------
shared pool AW SGA 24
KGX 107568
branch 14880
call 22048
dummy 3276
kcrrny 25320
kfasga 1048
kfdsga 44
kffsga 48
kfmsg 3088
kksss 3840
POOL NAME BYTES
------------ -------------------------- ----------
shared pool knlsg 80
kohsg 4
kzull 80
kzulu 64
list 3584
************ ----------
sum 184996
buffer_cache 171966464
fixed_sga 1287016
log_buffer 2904064
POOL NAME BYTES
------------ -------------------------- ----------
************ ----------
sum 176157544
19 rows selected.
SQL>
SQL>
SQL>
Related examples in the same category