Help read my statspack report

From: <emdproduction_at_hotmail.com>
Date: 19 Jan 2007 11:25:11 -0800
Message-ID: <1169234711.420501.57260@11g2000cwr.googlegroups.com>

Group,

This is our statspack report. I do not see any wait event. Does it mean our system is perfect?

Thanks for your help.

Load Profile

~~~~~~~~~~~~                            Per Second       Per
Transaction
                                   ---------------
---------------
                  Redo size:             84,764.84
4,281.64
              Logical reads:             22,887.86
1,156.11
              Block changes:                636.38
32.14
             Physical reads:                705.60
35.64
            Physical writes:                 66.62
3.37
                 User calls:                402.28
20.32
                     Parses:                173.90
8.78
                Hard parses:                 45.45
2.30
                      Sorts:                 34.13
1.72
                     Logons:                  0.05
0.00
                   Executes:                203.45
10.28
               Transactions:                 19.80



  % Blocks changed per Read:    2.78    Recursive Call %:     33.99

 Rollback per transaction %:    1.38       Rows per Sort:   3228.99

Instance Efficiency Percentages (Target 100%)

---

            Buffer Nowait %:   99.99       Redo NoWait %:    100.00
            Buffer  Hit   %:   97.17    In-memory Sort %:    100.00
            Library Hit   %:   89.85        Soft Parse %:     73.86
         Execute to Parse %:   14.53         Latch Hit %:     99.89
Parse CPU to Parse Elapsd %:   97.49     % Non-Parse CPU:     74.03

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   87.96   90.23

    % SQL with executions>1: 37.75 35.64
% Memory for SQL w/exec>1: 32.14 26.10

Top 5 Timed Events

---

% Total

Event                                               Waits    Time (s)

Ela Time

-------------------------------------------- ------------ -----------
--------
SQL*Net message from client                       877,838     186,622
 79.30
rdbms ipc message                                  81,654      24,710
 10.50
CPU time                                                        3,845
  1.63
smon timer                                            446       3,773
  1.60
dispatcher timer                                       61       3,647
  1.55
          -------------------------------------------------------------
Event                               Waits   Timeouts   Time (s)   (ms)

   /txn

---------------------------- ------------ ---------- ---------- ------
--------
SQL*Net message from client       877,838          0    186,622    213
   12.3
virtual circuit status                120        120      3,587  29891
    0.0
wakeup time manager                   118        118      3,495  29615
    0.0
db file scattered read            471,208          0        832      2
    6.6
db file sequential read           471,089          0        696      1
    6.6
log file sync                      70,573          2        206      3
    1.0
jobq slave wait                        66         63        197   2983
    0.0
direct path read                   28,009          0         30      1
    0.4
buffer busy waits                   4,937          0         29      6
    0.1
direct path write                  28,072          0         23      1
    0.4
db file parallel write              1,157          0         19     17
    0.0
log file parallel write            73,967          0         10      0
    1.0
log file sequential read              309          0          9     30
    0.0
latch free                          4,317        948          6      1

    0.1 Received on Fri Jan 19 2007 - 13:25:11 CST