System I/O as top events from ASH report
I have executed a performance test for our
application. After experiencing errors on our application's log, I ran
ASH report and ADDM at the time errors were encountered and noticed System I/O
related events as the top background events:
excerpt:
Top User Events:
Top Background Events:
I am thinking of moving the online redo log files to another disk as tuning remedy to "log file parallel write" events. Currently the data and redo log files are located on the same disk.
excerpt:
Top User Events:
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 51.59 | 2.23 |
| log file sync | Commit | 32.45 | 1.40 |
Top Background Events:
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| log file parallel write | System I/O | 12.62 | 0.54 |
| db file parallel write | System I/O | 1.46 | 0.06 |
I am thinking of moving the online redo log files to another disk as tuning remedy to "log file parallel write" events. Currently the data and redo log files are located on the same disk.
0