|
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
|
|
READY
|
NUMBER
|
The number of asynchronous requests for which a buffer was immediately ready for use
|
|
SHORT_WAITS
|
NUMBER
|
The number of times that a buffer was not immediately available, but a buffer became available after doing a non-blocking poll for I/O completion
|
|
SHORT_WAIT_TIME_TOTAL
|
NUMBER
|
The total time, in 100ths of seconds, taken by non-blocking polls for I/O completion
|
|
SHORT_WAIT_TIME_MAX
|
NUMBER
|
The maximum time taken for a non-blocking poll for I/O completion, in 100ths of seconds
|
|
LONG_WAITS
|
NUMBER
|
The number of times that a buffer was not immediately available, and only became available after a blocking wait was issued
|
|
LONG_WAIT_TIME_TOTAL
|
NUMBER
|
The total time, in 100ths of seconds, taken by blocking waits for I/O completion
|
|
LONG_WAIT_TIME_MAX
|
NUMBER
|
The maximum time taken for a blocking wait for I/O completion, in 100ths of seconds
|
