statspack wait events

[ajju]

i Guy,
My database is 10g and and my database is running in auto tuneing,i.e I kept in sga_target,
and my application is hanging ,can any body help me in finding why cpu is high and
what is parse cpu to parsed in statspack.

STATSPACK report for

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ----------------
q         xxxxxx q               1 10.1.0.4.0  NO  q

              Snap Id     Snap Time      Sessions Curs/Sess Comment
            --------- ------------------ -------- --------- -------------------
Begin Snap:      1580 20-Jun-06 17:42:03      109     384.0
  End Snap:      1582 20-Jun-06 18:02:05       97     436.7
   Elapsed:               20.03 (mins)

Cache Sizes (end)
~~~~~~~~~~~~~~~~~
               Buffer Cache:     1,472M      Std Block Size:         8K
           Shared Pool Size:       416M          Log Buffer:       256K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:              4,074.00             15,160.82
              Logical reads:                 74.22                276.19
              Block changes:                 13.37                 49.74
             Physical reads:                  0.68                  2.53
            Physical writes:                  0.97                  3.61
                 User calls:                 39.07                145.41
                     Parses:                  9.41                 35.01
                Hard parses:                  0.04                  0.17
                      Sorts:                  1.81                  6.73
                     Logons:                  0.12                  0.43
                   Executes:                 14.69                 54.67
               Transactions:                  0.27

  % Blocks changed per Read:   18.01    Recursive Call %:    31.96
 Rollback per transaction %:   36.53       Rows per Sort:    62.95

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   99.08    In-memory Sort %:  100.00
            Library Hit   %:   99.68        Soft Parse %:   99.52
         Execute to Parse %:   35.96         Latch Hit %:  100.00
Parse CPU to Parse Elapsd %:   86.49     % Non-Parse CPU:   97.00

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   93.61   93.66
    % SQL with executions>1:   35.62   35.76
  % Memory for SQL w/exec>1:   61.91   61.94

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                      % Total
Event                                               Waits    Time (s) Call Time
-------------------------------------------- ------------ ----------- ---------
CPU time                                                           21     83.14
db file sequential read                               724           2      9.42
process startup                                        12           1      1.95
log file parallel write                               336           0      1.82
control file parallel write                           400           0      1.32
          -------------------------------------------------------------
Wait Events  DB/Inst: q/q  Snaps: 1580-1582
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file sequential read               724          0          2      3      2.2
process startup                        12          0          1     42      0.0
log file parallel write               336          0          0      1      1.0
control file parallel write           400          0          0      1      1.2
SQL*Net more data to client         1,635          0          0      0      5.1
log buffer space                        2          0          0     62      0.0
log file sync                         115          0          0      1      0.4
db file parallel read                  11          0          0      8      0.0
change tracking file synchro           19          0          0      1      0.1
control file sequential read        2,020          0          0      0      6.3
latch: library cache                   68          0          0      0      0.2
SQL*Net break/reset to clien            6          0          0      0      0.0
rdbms ipc reply                         4          0          0      1      0.0
db file parallel write                712          0          0      0      2.2
change tracking file synchro           19          0          0      0      0.1
buffer busy waits                       1          0          0      0      0.0
db file scattered read                  1          0          0      0      0.0
latch: shared pool                      2          0          0      0      0.0
latch: redo allocation                  1          0          0      0      0.0
virtual circuit status             47,614         37      2,292     48    147.4
SQL*Net message from client        49,039          0      1,584     32    151.8
Queue Monitor Wait                     40         40      1,149  28726      0.1
jobq slave wait                       375        368      1,087   2898      1.2
wakeup time manager                     4          0        915 ######      0.0
SQL*Net message to client          49,039          0          0      0    151.8
SQL*Net more data from clien           22          0          0      0      0.1
          -------------------------------------------------------------
Background Wait Events  DB/Inst: q/q  Snaps: 1580-1582