OraFAQ Forum: Server Administration » how much time taken by the job to execute

Home » RDBMS Server » Server Administration » how much time taken by the job to execute (Oracle 10.1.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how much time taken by the job to execute [message #349940]

Tue, 23 September 2008 09:40

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

Report message to a moderator

Re: how much time taken by the job to execute [message #349947 is a reply to message #349940]

Tue, 23 September 2008 10:14

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check TOTAL_TIME in DBA_JOBS.

Report message to a moderator

Re: how much time taken by the job to execute [message #349955 is a reply to message #349940]

Tue, 23 September 2008 10:31

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: how much time taken by the job to execute [message #349960 is a reply to message #349955]

Tue, 23 September 2008 10:42

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.

Report message to a moderator

Previous Topic:	Does my online redo switch occurs frequently?
Next Topic:	ORA-27300: OS system dependent operation:spawning execution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 18:00:45 CST 2024