Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query to get wait event (IO latency) for a sql_id

spur230Sep 21 2015 — edited Oct 1 2015

I am using Oracle 11.2.0.3. and have diagnostics pack license to access awr/ ash.

does anyone have sql to get something like 'Top 5 timed foreground wait event' for a SQL_ID? In particular I want to know what were the wait events, times waited and avg wait (ms) for a sql_id

Something like this for as particular sql_id:

Events

Waits

Total Wait Time (s)

Average wait (ms

db file sequential read

36,895

This post has been answered by Dom Brooks on Oct 1 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2015

Added on Sep 21 2015

#general-database-discussions

8 comments

5,076 views