Example of Statspack SQL Report from Oracle 11.2.0.1 SE

STATSPACK SQL report for Old Hash Value: 3851979199  Module: dbrefresh@my_server-aps-1 (TNS V1-V3)

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ----------------
IGT           1066102538 igt                 1 11.2.0.4.0  NO  my_server-aps-1

 Start Id     Start Time         End Id      End Time       Duration(mins)
--------- ------------------- --------- ------------------- --------------
     6693 31-Jan-16 00:00:03       6723 01-Feb-16 00:00:02        1,439.98

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:         965,026            648.1    3.70
         Disk Reads:       1,011,306            679.2   66.75
     Rows processed:               0              0.0
     CPU Time(s/ms):               3              2.1
 Elapsed Time(s/ms):               4              2.5
              Sorts:           1,489              1.0
        Parse Calls:           1,489              1.0
      Invalidations:               0
      Version count:               3
    Sharable Mem(K):              78
         Executions:           1,489

SQL Text
~~~~~~~~
SELECT TABLE_ID, ISN, MAP_NAME FROM REFRESH_LOG  ORDER BY TABLE_
ID, MAP_NAME

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
--------- --------------- --------------- ------------ ----------
     6306 18-Jan-16 03:00 01-Feb-16 12:59    826343889       171
     6306 18-Jan-16 03:00 01-Feb-16 12:59    826343889       205
     6306 18-Jan-16 03:00 01-Feb-16 12:53    826343889         6
     6647 29-Jan-16 08:00 30-Jan-16 07:29    826343889

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                |----- 826343889 -----|       |      |    967 |
|SORT ORDER BY                   |                     |   172K|    1M|    967 |
| TABLE ACCESS FULL              |REFRESH_LOG          |   172K|    1M|    206 |
--------------------------------------------------------------------------------

End of Report