Database Tuning (MOSC)

MOSC Banner

Need show same SQL information from hash value statspack

edited Apr 24, 2012 4:18AM in Database Tuning (MOSC) 4 commentsAnswered
 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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center