Oracle PL/SQL/System Tables Views/sgastat

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> --