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 <n> 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_STAMP`, used to uniquely identify job output from `V$RMAN_OUTPUT`
`SESSION_STAMP`	`NUMBER`	Together with `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-diaplayable form. They will be converted to a format of nM, nG, nT, nP, and so on.