Oracle Database Administration 2022 Certified Professional — Question 32

You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?

Answer options

• A. V$SESSION
• B. V$SESSTAT
• C. V$RMAN_BACKUP_JOB_DETAILS
• D. V$SESSION_LONGOPS

Correct answer: D

Explanation

The correct answer is D, V$SESSION_LONGOPS, as it provides information about long-running operations, including their estimated completion time. The other options, while useful for monitoring sessions and statistics, do not specifically provide details about the progress of long-running operations like RMAN tasks.