Question on AWR reports.
Hi,
WE have a 2 node RAC installation for EBS R12.1.3 running on 11.2.0.1 (ASM) . Over the last few days , we have seen a performance degradation in the instance. Initial analysis shows the following
WE have a 2 node RAC installation for EBS R12.1.3 running on 11.2.0.1 (ASM) . Over the last few days , we have seen a performance degradation in the instance. Initial analysis shows the following
Top 5 Timed Foreground Events
Event Waits Time(s) Avg wait (ms) % DB time Wait Class db file sequential read 4,010,385 21,403 5 53.32 User I/O direct path read 386,148 6,965 18 17.35 User I/O db file scattered read 256,726 5,102 20 12.71 User I/O DB CPU 3,350 8.35 direct path read temp 67,438 1,186 18 2.95 User I/O
Top 5 Timed Foreground Events
Event Waits Time(s) Avg wait (ms) % DB time Wait Class db file scattered read 192,274 2,200 11 23.53 User I/O DB CPU 1,967 21.03 db file sequential read 200,308 1,147 6 12.26 User I/O direct path read 6,690 124 19 1.33 User I/O log file sync 11,394 93 8 0.99 Commit
2