SQL Performance Diagnosis: High I/O Wait Time

Focus on the ‘User Io Wait Time’ column. This shows the total elapsed time in seconds from the wait event class ‘User I/O’.

If tuning server load is the goal, CPU is usually prioritized, but if you want to spot other bottlenecks like IO or network waits (e.g., ‘SQL*Net message from dblink’), you should sort the report by ‘elapsed time’ instead of CPU time.

Yes, tracking table modifications can be useful for performance context. You can use the DBA Table Modifications report to see the number of rows modified since the last analysis, provided table monitoring is active.