The Current Usage of the SGA
SQL>
SQL>
SQL> select * from v$sgastat
2 where rownum < 50;
POOL NAME BYTES
------------ -------------------- ----------
fixed_sga 1287016
buffer_cache 184549376
log_buffer 2904064
shared pool dpslut_kfdsg 256
shared pool hot latch diagnostic 80
s
shared pool ENQUEUE STATS 8360
shared pool transaction 90576
shared pool KCB buffer wait stat 3352
istic
shared pool invalid low rba queu 320
e
shared pool KQF optimizer stats 2396
table
shared pool CCursor 3910332
shared pool ksunfy: system-globa 3000
l sta
shared pool DISPATCHERS INFO 2504
shared pool plwpil:wa 4252
shared pool kzekm heap descripto 164
r
shared pool kelt translation tab 300
le
shared pool kglsim recovery area 1980
shared pool procs_kfgbsg 440
POOL NAME BYTES
------------ -------------------- ----------
shared pool service names array 20
shared pool qtree_kwqbspse 28
shared pool SHARED SERVERS INFO 2824
shared pool ASH buffers 2097152
shared pool sga listelement 1024
shared pool object queue hash ta 3136
ble d
shared pool PX subheap desc 140
shared pool PX msg pool struct 728
shared pool Managed Standby Proc 28672
Arra
shared pool KQR M SO 147976
shared pool KSIR SGA 96
shared pool BRANCH TABLE SEGMENT 45864
ED AR
shared pool KGKP sga 20
shared pool SGA Obsolete Param S 16
ource
shared pool osp pool handles 4
shared pool SGA - SWRF Time Mode 64
l Bas
shared pool KSK SGA 64860
shared pool sys event stats for 195776
Other
shared pool spfile callback tabl 224
e: ks
shared pool kcrrny 25320
shared pool Service-level trace 268
setti
shared pool LRMPD SGA Table 77392
shared pool namhsh_kfgsg 144
shared pool msg Q child latches 144
shared pool plwda:PLW_STR_NEW_LE 4
N_VEC
shared pool Prefetch history buf 284
fer a
shared pool Prefetch client coun 32
t per
shared pool ptr to sessions unde 4
r idl
shared pool returns from metrics 759808
req
shared pool xslongops 4040
shared pool qm_init_uga_helper: 16
qmkm
49 rows selected.
SQL>
SQL> --
Related examples in the same category