STATSPACK SQL report for Old Hash Value: 528477046  Module: SQL*Plus

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ----------------
O102EE1       2384218455 o102ee1             1 10.2.0.3.0  NO  hpap0601

 Start Id     Start Time         End Id      End Time       Duration(mins)
--------- ------------------- --------- ------------------- --------------
     1109 02-Apr-07 20:01:08       1110 02-Apr-07 20:09:21            8.22

SQL Statistics
~~~~~~~~~~~~~~
-> CPU and Elapsed Time are in seconds (s) for Statement Total and in
   milliseconds (ms) for Per Execute
                                                       % Snap
                     Statement Total      Per Execute   Total
                     ---------------  ---------------  ------
        Buffer Gets:       1,557,001          1,557.0    2.90
         Disk Reads:              17              0.0     .00
     Rows processed:           1,000              1.0
     CPU Time(s/ms):              57             56.7
 Elapsed Time(s/ms):              78             78.0
              Sorts:               0               .0
        Parse Calls:           1,000              1.0
      Invalidations:               0
      Version count:               1
    Sharable Mem(K):               8
         Executions:           1,000

SQL Text
~~~~~~~~
SELECT COUNT(ename) FROM emp3 WHERE emp3no = 1

Known Optimizer Plan(s) for this Old Hash Value
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Shows all known Optimizer Plans for this database instance, and the Snap Id's
they were first found in the shared pool.  A Plan Hash Value will appear
multiple times if the cost has changed
-> ordered by Snap Id

  First        First           Last           Plan
 Snap Id     Snap Time      Active Time    Hash Value        Cost
--------- --------------- --------------- ------------ ----------
      806 27-Dec-06 16:55 27-Dec-06 16:56   1396384608       661
      838 22-Mar-07 13:44 02-Apr-07 20:30   1396384608       441
      918 22-Mar-07 19:41 02-Apr-07 17:15   1396384608         0

Plans in shared pool between Begin and End Snap Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Shows the Execution Plans found in the shared pool between the begin and end
snapshots specified.  The values for Rows, Bytes and Cost shown below are those
which existed at the time the first-ever snapshot captured this plan - these
values often change over time, and so may not be indicative of current values
-> Rows indicates Cardinality, PHV is Plan Hash Value
-> ordered by Plan Hash Value

--------------------------------------------------------------------------------
| Operation                      | PHV/Object Name     |  Rows | Bytes|   Cost |
--------------------------------------------------------------------------------
|SELECT STATEMENT                |----- 1396384608 ----|       |      |    869 |
|SORT AGGREGATE                  |                     |     1 |    9 |        |
| TABLE ACCESS FULL              |EMP3                 |   521K|    1M|    869 |
--------------------------------------------------------------------------------

End of Report