How to Check Running Jobs in Oracle Database? DBA scripts to check running jobs in oracle database?
Ezana Answered question 24/04/2023
The DBA scripts to query currently running Jobs in Oracle Database :
SELECT R.SID,U.USERNAME,J.JOB,R.THIS_DATE,J.WHAT FROM DBA_JOBS J, DBA_USERS U, DBA_JOBS_RUNNING R WHERE J.JOB=R.JOB AND J.LOG_USER=U.USERNAME;
Ezana Answered question 24/04/2023