DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
********      4225517201 *********           1 10.2.0.4.0  YES ********

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:      6485 21-Jul-09 01:00:05        88       1.9
  End Snap:      6665 28-Jul-09 13:00:35        75       2.3
   Elapsed:           10,800.51 (mins)
   DB Time:              328.39 (mins)

Cache Sizes
~~~~~~~~~~~                       Begin        End
                             ---------- ----------
               Buffer Cache:     1,008M     1,008M  Std Block Size:         8K
           Shared Pool Size:       352M       352M      Log Buffer:    14,384K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:              1,046.44              1,003.84
              Logical reads:                250.65                240.44
              Block changes:                  5.49                  5.27
             Physical reads:                 11.59                 11.12
            Physical writes:                  0.24                  0.23
                 User calls:                 22.36                 21.45
                     Parses:                 13.31                 12.77
                Hard parses:                  0.02                  0.02
                      Sorts:                  2.07                  1.98
                     Logons:                  0.25                  0.24
                   Executes:                 14.45                 13.86
               Transactions:                  1.04

  % Blocks changed per Read:    2.19    Recursive Call %:    88.46
 Rollback per transaction %:   97.74       Rows per Sort:    41.39

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   95.38    In-memory Sort %:  100.00
            Library Hit   %:   99.58        Soft Parse %:   99.81
         Execute to Parse %:    7.89         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:  101.45     % Non-Parse CPU:   92.00

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   94.42   93.67
    % SQL with executions>1:   89.39   74.65
  % Memory for SQL w/exec>1:   88.25   62.61

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time                                         18,386          93.3
control file parallel write         218,583       1,967      9   10.0 System I/O
db file sequential read           7,511,780       1,162      0    5.9   User I/O
control file sequential read      2,225,252       1,002      0    5.1 System I/O
CGS wait for IPC msg              5,861,347         332      0    1.7      Other
          -------------------------------------------------------------