Hi All,
RMAN is causing huge IO waits and CPU consumption on the server.
Top 10 Foreground Events by Total Wait Time
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
|---|
| DB CPU | | 2256.6 | | 38.9 | |
| direct path read | 313,468 | 848.4 | 3 | 14.6 | User I/O |
| db file sequential read | 988,373 | 819.2 | 1 | 14.1 | User I/O |
| PX qref latch | 3,742,846 | 90 | 0 | 1.5 | Other |
Please suggest to reduce the RMAN backup time and less consumption of CPU.