OraFAQ Forum: Server Administration » Tracking DBMS JOB timing

Home » RDBMS Server » Server Administration » Tracking DBMS JOB timing (oracle 10.2.0.4)

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

Tracking DBMS JOB timing [message #466675]

Tue, 20 July 2010 09:10

sahadba
Messages: 59
Registered: September 2009
Location: Pune

Member

Hi,

I have a database job to ANALYZE TABLES,, it takes more than 40 hours.
I want to know exactly how much time does it take..

My job has started on 19th Jul at 02:32 hrs..
What is the way to know the exact time when the job ends...

Thank You

Report message to a moderator

Re: Tracking DBMS JOB timing [message #466678 is a reply to message #466675]

Tue, 20 July 2010 09:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have a database job to ANALYZE TABLES,, it takes more than 40 hours.
Why have job at all when default DB installation includes similar job already?

Report message to a moderator