|
START_TIME
|
DATE
|
Start time of the recovery process
|
|
TYPE
|
VARCHAR2(64)
|
Type of recovery process being performed:
|
|
ITEM
|
VARCHAR2(32)
|
Item being measured.
When TYPE is MEDIA RECOVERY Apply SLAVE, the possible values are:
-
Recovery ID
-
Process ID
-
Number of Redo Cache Full
-
Number of Redo Cache Copy
-
Number of CV Cached
-
CV Applied OK
-
CV Applied Stuck
-
CV Applied Repair
-
CV Applied Corrupt
-
CV Applied Ckpt
-
CV Applied Reapplied
-
Total CV Processed Size
-
Total CV Applied
-
Number of Buffer Cache Full
-
Number of Buffer Retries
-
Number of Max Reads Issued
-
Number of Unrcv Condition
-
Number of Influx Buffer Flushed
-
Number of Reap Request
-
Number of Reap Wait IO
-
Number of Reap No Buffer
-
Number of Wait All Read
-
Number of Buffer Pinged
-
Buffer Ping Time
-
Read Issue Time
-
Number of Read Request Issued
When TYPE is MEDIA RECOVERY Merge Slave, the possible values are:
When TYPE is SERIAL MEDIA RECOVERY, the possible values include values from the other two TYPEs.
|
|
UNITS
|
VARCHAR2(32)
|
The units of measurement for each item
|
|
SOFAR
|
NUMBER
|
Amount of work done so far
|
|
TOTAL
|
NUMBER
|
Total amount of work expected
|
|
COMMENTS
|
VARCHAR2(248)
|
Miscellaneous notes, which may display the recovery ID and process ID for current recovery session
|
|
CON_ID
|
NUMBER
|
The ID of the container to which the data pertains. Possible values include:
-
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
-
1: This value is used for rows containing data that pertain to only the root
-
n: Where n is the applicable container ID for the rows containing data
|