Backup Async IO (PD_PDBA)
- Organization of this page
Function
The Backup Async IO (PD_PDBA) record stores performance data indicating the status, at a specific point in time, of a file that was backed up or restored with asynchronous 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 asynchronous 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 |
35 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC Key Fields
-
PD_PDBA_FILE_NAME
-
PD_PDBA_TYPE
-
PD_PDBA_USE_COUNT
Lifetime
From the start to the end of RMAN
Record Size
-
Fixed part: 678 bytes
-
Variable part: 750 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_ASYNC_IO.SERIAL |
Buffer Count (BUFFER_COUNT) |
Number of buffers used for read or write operations |
-- |
double |
No |
All |
V$BACKUP_ASYNC_IO.BUFFER_COUNT |
Buffer Size (BUFFER_SIZE) |
Size of buffer (in kilobytes) used for file read or write operations |
-- |
double |
No |
All |
V$BACKUP_ASYNC_IO.BUFFER_SIZE / 1024 |
Close Time (CLOSE_TIME) |
Time file was closed (if the value of the Type field is AGGREGATE, this is the time all files were closed in batch mode) |
-- |
string(20) |
No |
All |
V$BACKUP_ASYNC_IO.CLOSE_TIME |
Device Type (DEVICE_TYPE) |
Type of device where the file is located |
-- |
string(17) |
No |
All |
V$BACKUP_ASYNC_IO.DEVICE_TYPE |
Effective Rate (EFFECTIVE_KBYTES_PER_SEC) |
Asynchronous I/O rate in kilobytes for the device under backup processing |
-- |
ulong |
No |
All |
V$BACKUP_ASYNC_IO.EFFECTIVE_BYTES_PER_SECOND / 1024 |
Elapsed Time (ELAPSED_TIME) |
Length of time the file was open in seconds |
-- |
double |
Yes |
All |
V$BACKUP_ASYNC_IO.ELAPSED_TIME / 100 |
FileName (FILE_NAME) |
Name of the backup file |
-- |
string(513) |
No |
All |
V$BACKUP_ASYNC_IO.FILENAME |
IO Count (IO_COUNT) |
Number of asynchronous file I/O operations |
-- |
double |
Yes |
All |
V$BACKUP_ASYNC_IO.IO_COUNT |
Long Waits (LONG_WAITS) |
Number of times the buffer became available after a block wait was issued |
-- |
double |
Yes |
All |
V$BACKUP_ASYNC_IO.LONG_WAITS |
Max Long Wait Time (LONG_WAIT_TIME_MAX) |
Maximum length of block wait time required for asynchronous I/O operations in seconds. However, the value indicated in this field is 1/100 of the actual value. |
-- |
long |
No |
All |
V$BACKUP_ASYNC_IO.LONG_WAIT_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 any one time. If the value of the Type field is INPUT or OUTPUT, this field is empty. |
-- |
ulong |
No |
All |
V$BACKUP_ASYNC_IO.MAXOPENFILES |
Max Short Wait Time (SHORT_WAIT_TIME_MAX) |
Maximum unblocked polling time in seconds until asynchronous I/O operations were completed |
-- |
double |
No |
All |
V$BACKUP_ASYNC_IO.SHORT_WAIT_TIME_MAX / 100 |
Mbytes (MBYTES) |
Number of megabytes read or written during the interval |
-- |
double |
Yes |
All |
V$BACKUP_ASYNC_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_ASYNC_IO.OPEN_TIME |
Ready (READY) |
Number of asynchronous requests for which buffer was made ready |
-- |
double |
No |
All |
V$BACKUP_ASYNC_IO.READY |
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 PDBA) |
-- |
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_ASYNC_IO.SID |
Set Count (SET_COUNT) |
Number of backup sets under read or write operation |
-- |
double |
No |
All |
V$BACKUP_ASYNC_IO.SET_COUNT |
Set Stamp (SET_STAMP) |
Set stamp of the backup set under read or write operation |
-- |
double |
No |
All |
V$BACKUP_ASYNC_IO.SET_STAMP |
Short Waits (SHORT_WAITS) |
Number of times buffer became available after an asynchronous I/O operation and unblocked polling |
-- |
double |
Yes |
All |
V$BACKUP_ASYNC_IO.SHORT_WAITS |
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_ASYNC_IO.STATUS |
Total Long Wait Time (LONG_WAIT_TIME_TOTAL) |
Total block wait time (in seconds) required to complete asynchronous I/O operations. |
-- |
long |
Yes |
All |
V$BACKUP_ASYNC_IO.LONG_WAIT_TIME_TOTAL / 100 |
Total Mbytes (TOTAL_MBYTES) |
Total number of bytes in megabytes read or written (if the value is unknown, this field is empty) |
-- |
double |
Yes |
All |
V$BACKUP_ASYNC_IO.TOTAL_BYTES / (1024 * 1024) |
Total Short Wait Time (SHORT_WAIT_TIME_TOTAL) |
Total unblocked polling time (in seconds) before asynchronous I/O operation was completed |
-- |
double |
Yes |
All |
V$BACKUP_ASYNC_IO.SHORT_WAIT_TIME_TOTAL / 100 |
Type (TYPE) |
Type of backup or restore processing. Valid values are AGGREGATE, INPUT, and OUTPUT. |
-- |
string(10) |
No |
All |
V$BACKUP_ASYNC_IO.TYPE |
Use Count (USE_COUNT) |
Counter used to identify a row from a different backup set |
-- |
double |
No |
All |
V$BACKUP_ASYNC_IO.USE_COUNT |