What are RMAN AWR wait events in each of these Phases

From: kunwar singh <krishsingh.111_at_gmail.com>
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>    "

https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/tuning-rman-performance.html#GUID-55347A64-8DA3-415E-99C7-9F7FB30001A3

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-l
Received on Mon Mar 06 2023 - 20:53:24 CET

Original text of this message