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