I/O contention on 10g database - windows server
Hello Everyone
I have an ongoing performance issue on a 10.2.0.5 database hosted on Windows 2008 server.
Physical memory utilisation on the db server is quite high at 90%.
I have attached the ADDM report as well. Messages in this related to hard parsing and invalid cursors could be due to flush shared_pool which I did.
Requesting help from Performance Tuning experts.
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
CPU time | 1,651 | 73.3 | |||
db file sequential read | 149,021 | 456 | 3 | 20.2 | User I/O |
direct path read | 51,278 | 48 | 1 | 2.1 | User I/O |
log file parallel write | 13,907 | 46 | 3 | 2.1 | System I/O |
log file sync | 8,345 | 45 | 5 | 2.0 | Commit |
Wait Class |
---|