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 |
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 |
OPTIMIZED_WEIGHT |
NUMBER |
Used internally by Enterprise Manager |
OBJECT_TYPE_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_COUNT |
NUMBER |
Number of autobackups performed by this job |
AUTOBACKUP_DONE |
VARCHAR2(3) |
YES or NO, depending upon whether or not a control file autobackup was done as part of this backup 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. |
ELAPSED_SECONDS |
NUMBER |
Number of elapsed seconds |
COMPRESSION_RATIO |
NUMBER |
Compression ratio |
INPUT_BYTES_PER_SEC |
NUMBER |
Input read-rate-per-second |
OUTPUT_BYTES_PER_SEC |
NUMBER |
Output write-rate-per-second |
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 |
INPUT_BYTES_PER_SEC_DISPLAY |
VARCHAR2(4000) |
Input read-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on. |
OUTPUT_BYTES_PER_SEC_DISPLAY |
VARCHAR2(4000) |
Output write-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on. |
TIME_TAKEN_DISPLAY |
VARCHAR2(4000) |
Time taken, shown in user-displayable format <nn>h:<nn>m:<nn>s |
