Oracle show running job

SELECT * FROM USER_SCHEDULER_RUNNING_JOBS;		-- connected scheme
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;		-- granted to connected scheme
SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS;		-- all jobs (DBA)

-- More details (DBA)
SELECT DISTINCT r.OWNER, r.JOB_NAME, r.JOB_SUBNAME, r.ELAPSED_TIME, r.CPU_USED,
                d.ACTUAL_START_DATE
FROM DBA_SCHEDULER_RUNNING_JOBS r
         LEFT JOIN DBA_SCHEDULER_JOB_RUN_DETAILS d
                   ON d.SLAVE_PID = r.SLAVE_PROCESS_ID
ORDER BY r.OWNER, r.JOB_NAME, r.JOB_SUBNAME;

Similar codes

22 votes185 views3 answers
How to join three tables in sql using joins
SQL
1 vote256 views1 answer
Connect to mysql database ubuntu
SQL
9 votes214 views1 answer
Identity insert on sql server
SQL
0 vote179 views1 answer
Add alternate add column sql
SQL
0 vote242 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote200 views1 answer
Replace sqlalchemy
SQL
1 vote191 views1 answer
How to truncate a table in databse
SQL
0 vote189 views1 answer
Sql python hwo to pass a list in paramerter
SQL
1 vote194 views1 answer
How to see all table partition in oracle
SQL
11 votes184 views6 answers
Distinct sql
SQL