10.1 V$SCHEDULER_IN_MEMORY_TRACE

V$SCHEDULER_IN_MEMORY_TRACE displays in-memory trace and other information about all processes executing scheduler-related actions.

Column	Datatype	Description
SID	NUMBER	ID of the session generating scheduler trace
SERIAL#	NUMBER	Serial number of the session generating scheduler trace
USER#	NUMBER	Oracle identifier of the user generating scheduler trace
USERNAME	VARCHAR2(128)	Name of the user generating scheduler trace
PROCESSNAME	VARCHAR2(5)	Name of the process generating scheduler trace
PADDR	RAW(8)	Address of the process state object generating scheduler trace
SPID	VARCHAR2(24)	Operating system identifier of the process generating scheduler trace
PID	NUMBER	Oracle identifier of the process generating scheduler trace
TRACE_ST	CLOB	Scheduler trace generated by the process
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 Database 23ai.