7.121 V$CLEANUP_PROCESS

V$CLEANUP_PROCESS provides information on the PMON processes.

Column	Datatype	Description
NAME	VARCHAR2(5)	Name of the cleanup process (PMON, CLMN, CL**)
PADDR	RAW(8)	Process pointer for the cleanup process (can join with V$PROCESS)
SADDR	RAW(8)	Session pointer for the cleanup process (can join with V$SESSION)
STATE	VARCHAR2(4)	Cleanup process state: IDLE: Not currently performing cleanup BUSY: Currently performing cleanup
DEAD_IN_CLEANUP	RAW(8)	Pointer to the root of the tree in cleanup (can join with ROOT_ADDR in V$DEAD_CLEANUP)
CLEANUP_TIME	NUMBER	If STATE = BUSY, the time spent in the current cleanup attempt (in seconds). Otherwise, 0.
TIME_SINCE_LAST_CLEANUP	NUMBER	If STATE = IDLE, time since last needed to perform cleanup (in seconds). Otherwise, 0.
NUM_CLEANED	NUMBER	Number of trees cleaned up by the cleanup process. Increased by one every time a root tree is attempted.
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 multitenant container database (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 Database 12c Release 2 (12.2.0.1).

See Also:

"V$DEAD_CLEANUP"