SQL & PL/SQL

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!

How to know remaining execution time of a long running query?

Avinash TripathiMay 11 2007 — edited May 11 2007

Hi All,

I have a running query which is running from last 24 hrs and i dont know how much time it will take?

This is a very complex query it has a lot of joines and UNIONS etc.

I tried v$session_longops but the information in this view in continuously changing.

Current i am only concerned to know how much time it will take to finish?

Is there any way ?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2007

Added on May 11 2007

4 comments

875 views