Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>