The Current Usage of the SGA : sgastat « System Tables Views « Oracle PL / SQL






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