In 10g one can find the jobs that are currently running by querying the following view
SELECT job_name, session_id, running_instance, elapsed_time, cpu_used FROM dba_scheduler_running_jobs;
Also one can use the following view to find the history details of job that has run.
SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details;
To find the jobs that haven’t succeeded
SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details where status ‘SUCCEEDED’;
An Oracle Spin by Alex Lima 
what is the functionality of sql loader ? how it internally works
Reblogged this on jmarquez1974 and commented:
How to find jobs currently running or history about the jobs?
Alex Lima / November 26, 2008
In 10g one can find the jobs that are currently running by querying the following view
SELECT job_name, session_id, running_instance, elapsed_time, cpu_used FROM dba_scheduler_running_jobs;
Also one can use the following view to find the history details of job that has run.
SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details;
To find the jobs that haven’t succeeded
SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details where status ‘SUCCEEDED’;
if you don’t have dba permision ? dba_scheduler_running_jobs