Oracle® Database Reference 11g Release 2 (11.2) Part Number E17110-08 |
|
|
PDF · Mobi · ePub |
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 |