User I/O wait
Hi Gurus,
I have a 11.2.0.3 RAC database on Linux RHEL5. Application team has executed a SQL query and it has taken some more time than what was expected. When I ran the AWR report later, I could see that the User I/O wait for this particular query was very high. How can I investigate more on this to find out what all events have contributed to this high User I/O ? what all reports/queries I can run to find out the details specifically for this SQL query? Please note that multiple different SQL queries were running parallel when the above query
I have a 11.2.0.3 RAC database on Linux RHEL5. Application team has executed a SQL query and it has taken some more time than what was expected. When I ran the AWR report later, I could see that the User I/O wait for this particular query was very high. How can I investigate more on this to find out what all events have contributed to this high User I/O ? what all reports/queries I can run to find out the details specifically for this SQL query? Please note that multiple different SQL queries were running parallel when the above query
0