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!

sql_id of statements that cause I/O wait

marchello-OCSep 20 2013 — edited Sep 23 2013

Hi all,

how do I know sql_id of statements that cause I/O wait?

As far as I can understand, this I/O wait is one of reasons why the system is slow.

Please correct me if my try to catch the truth is rather insane.

Thanks ahead.

Upd: our oracle version -

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2013

Added on Sep 20 2013

#general-database-discussions

11 comments

1,803 views