V$RMAN_BACKUP_SUBJOB_DETAILS

V$RMAN_BACKUP_SUBJOB_DETAILS merges similar operations within an RMAN session into a single row. For example, if there are four BACKUP DATAFILE commands, three RECOVERY COPY OF DATAFILE commands, and one BACKUP RECOVERY AREA command, this view will contain three rows - one each for BACKUP, ROLLFORWARD, and COPY_DISK_TO_TAPE operation.

Column	Datatype	Description
SESSION_KEY	NUMBER	Session identifier
SESSION_RECID	NUMBER	Together with SESSION_KEY and SESSION_STAMP, used to uniquely identify job output from V$RMAN_OUTPUT
SESSION_STAMP	NUMBER	Together with SESSION_KEY and SESSION_RECID, used to uniquely identify job output from V$RMAN_OUTPUT
OPERATION	VARCHAR2(33)	Can be BACKUP, ROLLFORWARD, VALIDATE, or COPY_DISK_TO_TAPE. A row for each suboperation type for the session will be in the output view.
COMMAND_ID	VARCHAR2(33)	Either a user-specified SET COMMAND ID or a unique command ID generated by RMAN
START_TIME	DATE	Start time of the first BACKUP command in the job
END_TIME	DATE	End time of the last BACKUP command in the job
INPUT_BYTES	NUMBER	Sum of all input file sizes backed up by this job
OUTPUT_BYTES	NUMBER	Output size of all pieces generated by this job
STATUS_WEIGHT	NUMBER	Used internally by Enterprise Manager
OBJECT_TYPE_WEIGHT	NUMBER	Used internally by Enterprise Manager
OPTIMIZED_WEIGHT	NUMBER	Used internally by Enterprise Manager
OUTPUT_DEVICE_TYPE	VARCHAR2(17)	Can be DISK, SBT, or *. An * indicates more than one device (in most cases, it will be DISK or SBT).
AUTOBACKUP_DONE	VARCHAR2(3)	YES or NO, depending upon whether or not a control file autobackup was done as part of this job
STATUS	VARCHAR2(23)	One of the following values: · RUNNING WITH WARNINGS · RUNNING WITH ERRORS · COMPLETED · COMPLETED WITH WARNINGS · COMPLETED WITH ERRORS · FAILED
INPUT_TYPE	VARCHAR2(13)	Contains one of the following values. If the user command does not satisfy one of them, then preference is given in order, from top to bottom of the list. · DB FULL · RECVR AREA · DB INCR · DATAFILE FULL · DATAFILE INCR · ARCHIVELOG · CONTROLFILE · SPFILE
OPTIMIZED	VARCHAR2(3)	YES or NO, depending on whether optimization was applied. Applicable to backup jobs only.
AUTOBACKUP_COUNT	NUMBER	Number of autobackups performed by this job
COMPRESSION_RATIO	NUMBER	Compression ratio
INPUT_BYTES_DISPLAY	VARCHAR2(4000)	Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
OUTPUT_BYTES_DISPLAY	VARCHAR2(4000)	Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.

Note:

1.

select session_key, operation, status, compression_ratio, input_bytes_display, output_bytes_display

from V$RMAN_BACKUP_SUBJOB_DETAILS;

SESSION_KEY	OPERATION	STATUS	COMPRESSION_RATIO	INPUT_BYTES_DISPLAY	OUTPUT_BYTES_DISPLAY
18205	BACKUP	COMPLETED	3.41799049598936	1.17T	350.35G
17946	BACKUP	COMPLETED	3.46084052187209	1023.16G	295.64G
18317	BACKUP	COMPLETED	3.55417940479047	1.30T	373.20G
18060	BACKUP	FAILED	3.20107064644334	115.62G	36.12G
18351	BACKUP	COMPLETED	3.5238063780519	958.81G	272.10G
17981	BACKUP	COMPLETED	3.46973467834098	1.08T	319.63G
18054	BACKUP	FAILED	1	0.00K	0.00K
18376	BACKUP	COMPLETED	3.51405127279056	819.52G	233.21G
18095	BACKUP	COMPLETED	3.4687228625705	1.02T	301.19G
17521	BACKUP	COMPLETED	3.48035890958661	1.03T	303.29G

Oracle data dictionary views

Oracle dynamic performance views