7.107 V$BACKUP_SYNC_IO
V$BACKUP_SYNC_IO displays performance information about ongoing and recently completed RMAN backups and restores.
For each backup, it contains one row for each input data file, one row for the aggregate total performance of all data files, and one row for the output backup piece. This data is not stored persistently, and is not preserved when the instance is re-started.
| Column | Datatype | Description |
|---|---|---|
|
|
|
The Oracle SID of the session doing the backup or restore |
|
|
|
The use count for the SID doing the backup or restore |
|
|
|
A counter that can be used to identify rows from different backup sets |
|
|
|
Owning |
|
|
|
Owning |
|
|
|
The device type where the file is located |
|
|
|
|
|
|
|
|
|
|
|
The name of the backup file being read or written |
|
|
|
The set count of the backup set being read or written |
|
|
|
The set stamp of the backup set being read or written |
|
|
|
The size of the buffers being used to read/write this file, in bytes |
|
|
|
The number of buffers being used to read/write this file |
|
|
|
The total number of bytes that will be read or written for this file, if known. If not known, this column will be null. |
|
|
|
The time this file was opened. If |
|
|
|
The time this file was closed. If |
|
|
|
The time, in hundredths of a second, that the file was open |
|
|
|
The number of concurrently open DISK files. This value is only present in rows where |
|
|
|
The number of bytes read or written so far |
|
|
|
The I/O rate that was achieved with this device during this backup |
|
|
|
The number of I/Os that were performed to this file |
|
|
|
The total time, in hundredths of a second, taken to do I/O for this file |
|
|
|
The maximum time taken for a single I/O request |
|
|
|
The average transfer rate for this file |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|