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

1 vote406 views1 answer
Last 24 HOUR data in mysql
SQL
12 votes382 views4 answers
Psql command not found
SQL
3 votes366 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote352 views2 answers
Sql max count
SQL
0 vote361 views1 answer
Mysql persistence.xml
SQL
0 vote358 views1 answer
Create query in where clasue
SQL
0 vote362 views1 answer
How to use lower case in mysql
SQL
5 votes375 views1 answer
Mysql count newlines in field
SQL
0 vote373 views1 answer
Close sql query vb.net
SQL
4 votes405 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL