Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Anyway I can identify the time it took a job to run?

CharlovJul 29 2011 — edited Jul 29 2011

Hey,

I am using Oracle RDBMS 10GR2 RAC on Linux and I need to know how much time each scheduled job is taking to run.

select total_time, what from dba_jobs;

However, total_time shows very high values; some basic research showed that it's the TOTAL time of all the runs of the job. Any way to find out what was the run time of the last job?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2011

Added on Jul 29 2011

#general-database-discussions

6 comments

2,256 views