DBA Data[Home] [Help]

VIEW: SYS.V_$SCHEDULER_RUNNING_JOBS

Source

View Text - Preformatted

select "SESSION_ID","SESSION_SERIAL_NUM","JOB_ID","PADDR","OS_PROCESS_ID","SESSION_STAT_CPU","CON_ID" from v$scheduler_running_jobs
View Text - HTML Formatted

SELECT "SESSION_ID"
, "SESSION_SERIAL_NUM"
, "JOB_ID"
, "PADDR"
, "OS_PROCESS_ID"
, "SESSION_STAT_CPU"
, "CON_ID"
FROM V$SCHEDULER_RUNNING_JOBS