6.372 DBA_SCHEDULER_IN_MEMORY_TRACE

DBA_SCHEDULER_IN_MEMORY_TRACE displays scheduler in-memory trace information generated by all user processes in the database.

Column Datatype NULL Description

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

SPID

VARCHAR2(24)

Operating system identifier of the process generating scheduler trace

PADDR

RAW(8)

Address of the process state object generating scheduler trace

TRACE_ST

CLOB

Scheduler trace generated by the process

Note:

This view is available starting with Oracle Database 23ai.