|
SID |
NUMBER |
The Oracle SID of the session doing the backup or restore |
|
SERIAL |
NUMBER |
The use count for the SID doing the backup or restore |
|
USE_COUNT |
NUMBER |
A counter that can be used to identify rows from different backup sets |
|
DEVICE_TYPE |
VARCHAR2(17) |
The device type where the file is located |
|
TYPE |
VARCHAR2(9) |
INPUT, OUTPUT, or AGGREGATE |
|
STATUS |
VARCHAR2(11) |
NOT STARTED, IN PROGRESS, or FINISHED |
|
FILENAME |
VARCHAR2(513) |
The name of the backup file being read or written |
|
SET_COUNT |
NUMBER |
The set count of the backup set being read or written |
|
SET_STAMP |
NUMBER |
The set stamp of the backup set being read or written |
|
BUFFER_SIZE |
NUMBER |
The size of the buffers being used to read/write this file, in bytes |
|
BUFFER_COUNT |
NUMBER |
The number of buffers being used to read/write this file |
|
TOTAL_BYTES |
NUMBER |
The total number of bytes that will be read or written for this file, if known. If not known, this column will be null. |
|
OPEN_TIME |
DATE |
The time this file was opened. If TYPE='AGGREGATE', then this is the time that the first file in the aggregate was opened. |
|
CLOSE_TIME |
DATE |
The time this file was closed. If TYPE='AGGREGATE', then this is the time that the last file in the aggregate was closed. |
|
ELAPSED_TIME |
NUMBER |
The time, in 100ths of seconds, that the file was open |
|
MAXOPENFILES |
NUMBER |
The number of concurrently open DISK files. This value is only present in rows where TYPE='AGGREGATE'. |
|
BYTES |
NUMBER |
The number of bytes read or written so far |
|
EFFECTIVE_BYTES_PER_SECOND |
NUMBER |
The I/O rate that was achieved with this device during this backup |
|
IO_COUNT |
NUMBER |
The number of I/Os that were performed to this file |
|
IO_TIME_TOTAL |
NUMBER |
The total time, in 100ths of seconds, taken to do I/O for this file |
|
IO_TIME_MAX |
NUMBER |
The maximum time taken for a single I/O request |
|
DISCRETE_BYTES_PER_SECOND |
NUMBER |
The average transfer rate for this file |
