Need show same SQL information from hash value statspack
HI all, From the Some Tips for Tuning Waits on 'Db File Sequential Read' [ID 875472.1] , in the Symptoms, how I can show information look like:
Elapsed times include waiting on following events:Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 14363 0.00 0.02
db file sequential read 461688 1.15 2254.55 <<<<<
SQL*Net message from client 14363 0.01 9.77
SQL*Net break/reset to client 1 0.00 0.00
I used statspack in 9.2.0.4 and with level 6, I can generate report with execution plan of SQL from hash value. And with this hash value from statspack report, I can view SQL information look above ? Or any methods ?
0