V$DEAD_CLEANUP

7.174 V$DEAD_CLEANUP

V$DEAD_CLEANUP shows the dead processes and killed sessions present in the instance and their cleanup status.

Column	Datatype	Description
`TYPE`	`VARCHAR2(64)`	Indicates whether a row contains a `DEAD PROCESS` or `KILLED SESSION`
`PADDR`	`RAW(8)`	Process pointer. Can be joined with `V$PROCESS`. For a killed session, this is the owner of the session, which can be NULL.
`SADDR`	`RAW(8)`	Session pointer. Can be joined with `V$SESSION`. For a dead process, this is the user session.
`ROOT_ADDR`	`RAW(8)`	Pointer to the root of the tree
`CLEANUP_OWNER`	`VARCHAR2(64)`	Indicates which process is responsible for cleanup of this tree: `CLEANUP PROCESS` - a cleanup process is responsible `OWNER PROCESS` - the root owner is responsible
`STATE`	`VARCHAR2(64)`	Cleanup state: `CLEANUP PENDING` - Occurs for a dead process / killed session that can be cleaned up, but PMON has not yet made an attempt `IN PROGRESS` - A cleanup attempt is currently in progress `RESOURCES FREED` - Occurs for a dead process / killed session where all children have been freed, but the process / killed session itself is not yet freed `PARTIAL CLEANUP` - Occurs if some of the children have been cleaned up
`DEAD_TIME`	`NUMBER`	Time since the process was marked dead or the session was marked killed (in seconds)
`CLEANUP_ATTEMPTS`	`NUMBER`	Number of times PMON has attempted cleanup
`LAST_ATTEMPT`	`NUMBER`	How long ago the last cleanup attempt occurred (in seconds)
`CLEANUP_PROCESS`	`RAW(8)`	Process pointer for the cleanup process currently cleaning up this tree (can join with `V$CLEANUP_PROCESS`). It will be NULL if cleanup is not currently in progress or if the owner is responsible for cleanup.
`CLEANUP_TIME`	`NUMBER`	Total amount of time PMON has spent on cleanup of the process/session (in seconds)
`NUM_BLOCKED`	`NUMBER`	Number of sessions blocked on cleanup of this 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