STATSPACK SQL report for Old Hash Value: 3122753897 Module: sqldeveloper.exe 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) --------- ------------------- --------- ------------------- -------------- 814 16-Jan-07 19:38:28 816 16-Jan-07 19:44:34 6.10 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: 126,570 12,657.0 80.92 Disk Reads: 126,447 12,644.7 99.94 Rows processed: 10 1.0 CPU Time(s/ms): 5 522.4 Elapsed Time(s/ms): 5 533.9 Sorts: 0 .0 Parse Calls: 10 1.0 Invalidations: 0 Version count: 1 Sharable Mem(K): 8 Executions: 10 SQL Text ~~~~~~~~ select ename from emp where empno = 100 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 --------- --------------- --------------- ------------ ---------- 812 16-Jan-07 19:36 16-Jan-07 19:38 3956160932 3443 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 |----- 3956160932 ----| | | 3443 | |TABLE ACCESS FULL |EMP | 1 | 12 | 3443 | -------------------------------------------------------------------------------- End of Report