compute sum of bytes on pool : v_sgastat « System Tables Views « Oracle PL / SQL






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

1.Query v$sgastat