Query JOB Running

Published by Patrizia Gardis on 6 March 20196 March 2019

In the article Query JOB Running, we provide a query that allows identifying the running JOBS of all users in the database.

The view that allows access to the information of the running JOBS is the table DBA_JOBS_RUNNING, from which it is possible to retrieve many useful information including the session’s SID number associated, the running JOB number, start time, last execution, next execution, the detail of the JOB plus the instance in which it is running if it is an RAC environment.

So, if we need to deepen the analysis, through the SID, we can retrieve useful information regarding the session generated thanks to the query in the article Query Oracle SID sessions.

Once we have retrieved the information about LOGON time, reference SCHEMA, etc., we have the possibility to verify which statement is running through SQL_ID, obtainable from the previous query through the statement in the article Query to extract statements from a subsequent SQL_ID EXPLAIN PLAIN of the statement.

So, if we want to deepen the analysis, we have the right queries to analyze the session.

Query to check the JOB Running: 

select /*+ rule */ * from dba_jobs_running;

To view my guides on CRS Command click here!
At this LINK, instead, you’ll find the SQL queries.

Stay updated on our activities by joining our community:
Facebook
Youtube
Linkedin

• dbms_ijob remove JOB Oracle
• DBMS_IJOB BROKEN FALSE
• DBMS_IJOB BROKEN
• Query JOB Running
• Query JOB Oracle status