与job有关的几个视图:
- dba_jobs
- all_jobs
- user_jobs
- dba_jobs_running
查看job相关信息sql:
SELECT JOB, NEXT_DATE, NEXT_SEC, FAILURES, BROKEN
FROM DBA_JOBS;
查看正在运行的job相关信息sql:
SELECT SID, r.JOB, LOG_USER, r.THIS_DATE, r.THIS_SEC
FROM DBA_JOBS_RUNNING r, DBA_JOBS j
WHERE r.JOB = j.JOB;
查看JOB QUEUE LOCK相关信息sql:
SELECT SID, TYPE, ID1, ID2 FROM V$LOCK WHERE TYPE = ’JQ’;