Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> statspack Data

statspack Data

From: <reachrud_at_gmail.com>
Date: 20 Jan 2006 01:05:45 -0800
Message-ID: <1137747945.208203.166490@f14g2000cwb.googlegroups.com>

STATSPACK report for
 clsDB Name DB Id Instance Inst Num Release OPS Host ------------ ----------- ------------ -------- ----------- ---



HDFCDB 1839116686 hdfcdb 1 8.1.7.0.0 NO WONDERSDBSWT
                                                               EST
 cls                Snap Id     Snap Time      Sessions
                ------- ------------------ --------
 Begin Snap:         12 19-Jan-06 01:04:24       56
   End Snap:         21 19-Jan-06 02:26:05       56
    Elapsed:                  81.68 (mins)
 clsCache Sizes
           db_block_buffers:       2188          log_buffer:      32768
              db_block_size:       8192    shared_pool_size:   31457280
 clsLoad Profile
~~~~~~~~~~~~                            Per Second       Per
Transaction
                                   ---------------
---------------
                  Redo size:              2,348.32
8,370.26
              Logical reads:            513,596.81
1,830,645.79
              Block changes:                 16.85
60.07
             Physical reads:                 85.77
305.70
            Physical writes:                  0.60
2.15
                 User calls:                796.10
2,837.58
                     Parses:                325.30
1,159.48
                Hard parses:                  2.71
9.64
                      Sorts:                  6.62
23.58
                     Logons:                  0.80
2.87
                   Executes:                 63.02
224.64
               Transactions:                  0.28


% Blocks changed per Read: 0.00 Recursive Call %: 16.61
Rollback per transaction %: 38.47 Rows per Sort: 23.81
 clsInstance Efficiency Percentages (Target 100%)
            Buffer Nowait %:  100.00       Redo NoWait %:   99.96
            Buffer  Hit   %:   99.98    In-memory Sort %:   99.98
            Library Hit   %:   99.50        Soft Parse %:   99.17
         Execute to Parse %: -416.16         Latch Hit %:   94.28
Parse CPU to Parse Elapsd %:             % Non-Parse CPU:
 cls Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   77.36   86.42
    % SQL with executions>1: 80.24 95.01
% Memory for SQL w/exec>1: 77.78 96.96
 clsTop 5 Wait Events
~~~~~~~~~~~~~~~~~                                             Wait
% Total
Event                                               Waits  Time (cs)
Wt Time
-------------------------------------------- ------------ ------------
-------
latch free                                      3,200,092            0
   .00
db file scattered read                             74,063            0
   .00
db file sequential read                            46,436            0
   .00
SQL*Net more data to client                        21,712            0
   .00
SQL*Net break/reset to client                      16,986            0

   .00 Received on Fri Jan 20 2006 - 03:05:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US