STATSPACK SQL report for Old Hash Value: 4111966515  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:         140,000             14.0     .26
         Disk Reads:               0              0.0     .00
     Rows processed:          10,000              1.0
     CPU Time(s/ms):               4               .4
 Elapsed Time(s/ms):               4               .4
              Sorts:               0               .0
        Parse Calls:          10,000              1.0
      Invalidations:               0
      Version count:               1
    Sharable Mem(K):              12
         Executions:          10,000

SQL Text
~~~~~~~~
select distinct emp1.deptno from emp1, dept where emp1.deptno =
dept.deptno and dept.deptno = 10

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
--------- --------------- --------------- ------------ ----------
      497 26-Jul-06 15:05 26-Jul-06 15:00   2294000873        14
      508 27-Jul-06 14:32 02-Apr-07 20:29   2294000873         3
      918 22-Mar-07 19:41 02-Apr-07 17:14   2294000873         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                |----- 2294000873 ----|       |      |     14 |
|SORT UNIQUE NOSORT              |                     |     1 |    6 |     14 |
| NESTED LOOPS                   |                     |     5K|   30K|     12 |
|  INDEX UNIQUE SCAN             |PK_DEPT              |     1 |    3 |      0 |
|  INDEX RANGE SCAN              |IND_EMP1_DEPTNO      |     5K|   15K|     12 |
--------------------------------------------------------------------------------

End of Report