Need Statspack help

From: PaulW <paul_widner_at_hotmail.com>
Date: 19 Oct 2004 14:59:17 -0700
Message-ID: <3fdda837.0410191359.515564bb@posting.google.com>

We have collected the following stats pack report, could someone give me some feedback on it? Any help would be great! Thanks, Paul

Note this is only the beginning of the report

STATSPACK report for

DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- -------

---

WORKFLOW 368469151 workflow 1 9.2.0.1.0 NO miami

            Snap Id     Snap Time      Sessions Curs/Sess Comment
            ------- ------------------ -------- ---------


-------------------

Begin Snap:      12 18-Oct-04 18:04:47       63      12.8
  End Snap:      13 18-Oct-04 18:29:36       61      13.3
   Elapsed:               24.82 (mins)

Cache Sizes (end)

---

               Buffer Cache: 1,008M Std Block Size: 8K

           Shared Pool Size: 128M Log Buffer: 2,930K

Load Profile

~~~~~~~~~~~~                            Per Second       Per
Transaction
                                   ---------------      


---------------

                  Redo size:             11,351.53            
11,275.81
              Logical reads:              1,098.99             
1,091.66
              Block changes:                 59.32                
58.92
             Physical reads:                348.86               
346.54
            Physical writes:                  2.76                 
2.74
                 User calls:                 45.47                
45.17
                     Parses:                 23.04                
22.89
                Hard parses:                  0.07                 
0.07
                      Sorts:                  2.36                 
2.34
                     Logons:                  0.00                 
0.00
                   Executes:                 41.67                
41.39
               Transactions:                  1.01

  % Blocks changed per Read:    5.40    Recursive Call %:    43.36
 Rollback per transaction %:    0.00       Rows per Sort:    22.77

Instance Efficiency Percentages (Target 100%)

---

            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   68.26    In-memory Sort %:   99.97
            Library Hit   %:   99.84        Soft Parse %:   99.69
         Execute to Parse %:   44.71         Latch Hit %:   99.98
Parse CPU to Parse Elapsd %:   78.52     % Non-Parse CPU:   97.17

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   93.86   93.82

    % SQL with executions>1: 36.34 36.28   % Memory for SQL w/exec>1: 40.34 40.04

Top 5 Timed Events

---

% Total

Event                                               Waits    Time (s)

Ela Time
-------------------------------------------- ------------ -----------

---

db file scattered read                             76,596         763 
  83.81
CPU time                                                           79 
   8.67
db file sequential read                            10,528          44 
   4.80
db file parallel write                                452           6 
    .63
log file sequential read                              103           6 
    .61
          -------------------------------------------------------------

Received on Tue Oct 19 2004 - 16:59:17 CDT