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 AI Database 26ai.