DBA Data[Home] [Help]

VIEW: SYS.GV_$SCHEDULER_RUNNING_JOBS

Source

View Text - Preformatted

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

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