V$SCHEDULER_RUNNING_JOBS displays information about running Scheduler jobs.
| Column | Datatype | Description |
|---|---|---|
SESSION_ID |
NUMBER |
Identifier of the session running the Scheduler job |
SESSION_SERIAL_NUM |
NUMBER |
Session serial number |
JOB_ID |
NUMBER |
ID of the running Scheduler job |
PADDR |
RAW(4 | 8) |
Process address |
OS_PROCESS_ID |
VARCHAR2(12) |
Operating system process ID |
SESSION_STAT_CPU |
INTERVAL DAY(2) TO SECOND(3) |
CPU statistics for the session |