Two Processes r running....Pls go through this

[keerti_rose]

Hi..,

We have two Processes..Out of one is running and the other is in Queue.But the second one has to know how much time first one is going to take for execution."Here these People are using DBMS_Alert"...Can any one help me inthis..How to find the time of the first process execution...It would be very helpful to me..thank you.

[amirtai]

Hi there

There are many tables available to know job status. You could either check ALL_JOBS or DBA_JOBS and TOTAL_TIME column will tell you how much time processing time was allocated to a particular job.

Thanks
Amir