Home » RDBMS Server » Server Administration » how much time taken by the job to execute (Oracle 10.1.0.2)
how much time taken by the job to execute [message #349940] Tue, 23 September 2008 09:40 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
kindly let me know how we can find how much time was taken by a job to executed .
in the dba_jobs table we can only find it was last executed .
but how much time it has taken to execute is not mentioned

kindly help
Re: how much time taken by the job to execute [message #349947 is a reply to message #349940] Tue, 23 September 2008 10:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check TOTAL_TIME in DBA_JOBS.
Re: how much time taken by the job to execute [message #349955 is a reply to message #349940] Tue, 23 September 2008 10:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have only the total time for all executions and the number of executions but not the time for the last execution.
If you want this you have to do it yourself in your job.

Regards
Michel
Re: how much time taken by the job to execute [message #349960 is a reply to message #349955] Tue, 23 September 2008 10:42 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Right, but if the OP knows the last value and the present value, then they can calculate the time.

OP would be better off use the scheduler and using LAST_RUN_DURATION in DBA_SCHEDULER_JOBS.
Previous Topic: Does my online redo switch occurs frequently?
Next Topic: ORA-27300: OS system dependent operation:spawning execution
Goto Forum:
  


Current Time: Fri Dec 02 12:46:21 CST 2016

Total time taken to generate the page: 0.17690 seconds