What are RMAN AWR wait events in each of these Phases
Date: Mon, 6 Mar 2023 14:53:24 -0500
Message-ID: <CAJSrDUoFCVP8uduXyUVYD8BJ=Q7etgiBXXETfWnCELyWsLtsSw_at_mail.gmail.com>
Hi Listers,
I am seeing a RMAN performance issue RMAN backup & recovery I/O. Avg Wait of 50ms. DB version : 19.17
Question => Which phase , in the below table, does this wait relate to?
SequencePhaseDescriptionAdditional Information 1 Read phase
A channel reads blocks from disk into input I/O buffers.
"Read Phase
<https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/tuning-rman-performance.html#GUID-1016F1F4-21D0-47B8-871A-FB582838D8A7>
"
2 Copy phase
A channel copies blocks from input buffers to output buffers and performs additional processing on the blocks.
"Copy Phase
<https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/tuning-rman-performance.html#GUID-4061DDD7-DB0F-46E8-A6B2-C3D10E288846>
"
3 Write phase
A channel writes the blocks from output buffers to storage media. The write phase can take either of the following mutually exclusive forms, depending on the type of backup media: write phase for System Backup Tape (SBT) or write phase for disk.
-
"Write Phase for System Backup Tape (SBT)
<https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/tuning-rman-performance.html#GUID-BA0D4E35-7835-4F28-9504-C5EB32207206>
"
-
"Write Phase for Disk
<https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/tuning-rman-performance.html#GUID-56356B98-2E0F-4D03-9998-F1E8348D9F2B>
"
If we cannot tie each phase to specific wait events, how do you approach troubleshooting rman performance issues in general? This is the first time I am seeing this issue.
-- Cheers, Kunwar -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 06 2023 - 20:53:24 CET