Announcement

Collapse

http://progeeking.com

See more
See less

ttitle center 'LIBRARY CACHE STATS' skip 2

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ttitle center 'LIBRARY CACHE STATS' skip 2

    Code:
    ttitle center 'LIBRARY CACHE STATS' skip 2
    column namespace format a8 heading 'Library'
    column gets format 9,999,990 heading 'GETS'
    column gethits format 9,999,990 heading 'GETHITS'
    column gethitratio format 99.90 heading 'GET|HIT|RATIO'
    column pins format 999,999,990 heading 'PINS'
    column pinhits format 999,999,990 heading 'PINHITS'
    column pinhitratio format 99.90 heading 'PIN|HIT|RATIO'
    column reloads format 999,990 heading 'RELOADS' 
    compute sum of gets on report
    compute sum of gethits on report
    compute sum of pins on report
    compute sum of pinhits on report 
    compute sum of reloads on report
    break on report
    select
    namespace,gets,gethits,gethitratio,pins,pinhits,
    pinhitratio, reloads
    from v$librarycache
    where gets+gethits+pins+pinhits>0
    ;
    
    Code:
     
    LIBRARY CACHE STATS
                                      GET                              PIN
                                      HIT                              HIT
    Library        GETS    GETHITS  RATIO         PINS      PINHITS  RATIO  RELOADS
    -------- ---------- ---------- ------ ------------ ------------ ------ --------
    SQL AREA    457,985    436,938    .95    4,159,118    4,126,949    .99    1,777
    TABLE/PR  2,844,128  2,837,312   1.00    3,544,306    3,526,951   1.00    4,511
    OCEDURE
    BODY        110,562    109,640    .99      739,087      738,129   1.00       15
    TRIGGER     200,148    200,022   1.00      212,797      212,576   1.00        0
    INDEX         8,959      8,628    .96        7,779        6,036    .78      631
    CLUSTER       4,992      4,983   1.00        2,032        2,019    .99        4
    JAVA DAT        414        411    .99        1,487        1,481   1.00        0
    A
             ---------- ----------        ------------ ------------        --------
    sum       3,627,188  3,597,934           8,666,606    8,614,141           6,938
    7 rows selected.
Working...
X