V$RECOVERY_WORKER

V$RECOVERY_WORKER is used to track database media recovery processes to monitor their performance statistics and analyze a media recovery session.

Column	Datatype	Description
`START_TIME`	`DATE`	Start time of the recovery process
`TYPE`	`VARCHAR2(64)`	Type of recovery process being performed: `Media` `Recovery` `Applier` `#` (where `#` represents the worker ID number) `Media` `Recovery` `Log` `Merger` `Serial` `Media` `Recovery`
`ITEM`	`VARCHAR2(32)`	Item being measured. When `TYPE` is `Media` `Recovery` `Applier` `#`, 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` `Log` `Merger`, the possible values are: `Recovery ID` `Process ID` `Number of Redo Cache Full` `Number of Redo Cache Copy` `Number of CV Cached` `Total Redo Read Bytes` `Total CV Parsed` When `TYPE` is `Serial` `Media` `Recovery`, the possible values include values from the other two `TYPE`s.
`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

Note: This view is available starting with Oracle AI Database 26ai.