Backup Sync IO (PD_PDBS)
- Organization of this page
Function
The Backup Sync IO (PD_PDBS) record stores performance data indicating the status, at a specific point in time, of a file that was backed up or restored with synchronous I/O operations and that is now being or has been executed by the Oracle recovery manager (RMAN). PFM - Agent for Oracle creates one record for each file that is backed up or restored with synchronous I/O operations by the Oracle recovery manager (RMAN). This is a multi-instance record.
Default and changeable values
Item |
Default Value |
Changeable |
---|---|---|
Collection Interval |
600 |
Y |
Collection Offset |
40 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC Key Fields
-
PD_PDBS_FILE_NAME
-
PD_PDBS_TYPE
-
PD_PDBS_USE_COUNT
Lifetime
From the start to the end of RMAN
Record Size
-
Fixed part: 678 bytes
-
Variable part: 718 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported Version |
Data Source |
---|---|---|---|---|---|---|
Serial (SERIAL) |
Number of session IDs being used for backup or restore processing |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.SERIAL |
Avg Transfer Rate (DISCRETE_KBYTES_PER_SEC) |
Average file transfer rate in kilobytes |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND / 1024 |
Buffer Count (BUFFER_COUNT) |
Number of buffers used for file read or write operations |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.BUFFER_COUNT |
Buffer Size (BUFFER_SIZE) |
Size of buffer (in kilobytes) used for file read or write operations |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.BUFFER_SIZE / 1024 |
Close Time (CLOSE_TIME) |
Time the file was closed (if the value of the Type field is AGGREGATE, the time the first file was closed) |
-- |
string(20) |
No |
All |
V$BACKUP_SYNC_IO.CLOSE_TIME |
Device Type (DEVICE_TYPE) |
Type of device where the file is located |
-- |
string(17) |
No |
All |
V$BACKUP_SYNC_IO.DEVICE_TYPE |
Effective Rate (EFFECTIVE_KBYTES_PER_SEC) |
I/O rate of the device under backup processing in kilobytes |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.EFFECTIVE_BYTES_PER_SECOND / 1024 |
Elapsed Time (ELAPSED_TIME) |
Length of time the file was open in seconds |
-- |
double |
Yes |
All |
V$BACKUP_SYNC_IO.ELAPSED_TIME / 100 |
FileName (FILE_NAME) |
Name of backup file |
-- |
string(513) |
No |
All |
V$BACKUP_SYNC_IO.FILENAME |
IO Count (IO_COUNT) |
Number of file I/O operations |
-- |
double |
Yes |
All |
V$BACKUP_SYNC_IO.IO_COUNT |
Max IO Time (IO_TIME_MAX) |
Maximum time required for a single I/O request in seconds |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.IO_TIME_MAX / 100 |
Max Open Files (MAX_OPEN_FILES) |
If the value of the Type field is AGGREGATE, the number of disk files that are open at one time. If the value of the Type field is INPUT or OUTPUT, this field is empty. |
-- |
long |
No |
All |
V$BACKUP_SYNC_IO.MAXOPENFILES |
Mbytes (MBYTES) |
Number of megabytes read or written during the interval |
-- |
double |
Yes |
All |
V$BACKUP_SYNC_IO.BYTES / (1024 * 1024) |
Open Time (OPEN_TIME) |
Time the file was opened (if the value of the Type field is AGGREGATE, the time the first file was opened) |
-- |
string(20) |
No |
All |
V$BACKUP_SYNC_IO.OPEN_TIME |
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PDBS) |
-- |
string(4) |
No |
All |
Agent Collector |
SID (SID) |
Oracle session ID of the session that is executing backup or restore processing |
-- |
ulong |
No |
All |
V$BACKUP_SYNC_IO.SID |
Set Count (SET_COUNT) |
Number of backup sets under read or write operation |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.SET_COUNT |
Set Stamp (SET_STAMP) |
Set stamp of the backup set under read or write operation |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.SET_STAMP |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Status (STATUS) |
Backup or restoration status. Valid values are FINISHED, IN PROGRESS, and NOT STARTED. |
-- |
string(12) |
No |
All |
V$BACKUP_SYNC_IO.STATUS |
Total IO Time (IO_TIME_TOTAL) |
Total I/O time on files in seconds. |
-- |
double |
Yes |
All |
V$BACKUP_SYNC_IO.IO_TIME_TOTAL / 100 |
Total Mbytes (TOTAL_MBYTES) |
Total number of megabytes read or written (if this information is unknown, this field is empty) |
-- |
double |
Yes |
All |
V$BACKUP_SYNC_IO.TOTAL_BYTES / (1024 * 1024) |
Type (TYPE) |
Type of backup or restore processing. Valid values are AGGREGATE, INPUT, and OUTPUT. |
-- |
string(10) |
No |
All |
V$BACKUP_SYNC_IO.TYPE |
Use Count (USE_COUNT) |
Counter used to identify a row from a different backup set |
-- |
double |
No |
All |
V$BACKUP_SYNC_IO.USE_COUNT |