Check running time of insert into Oracle Table

Is there a way to see how long an insert that is running is going to take to finish.  I kicked off an insert two hours ago.  It's there any way to see how long it will take before it finishes.

Oracle DB
Coco BeansDesignerAsked:
Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
v$session_longops has a time_remaining column that tends to be really accurate.

You need to track down the sid and serial# of the insert's session and join it with v$session_longops.

There are a few other columns there that might interest you like elapsed_seconds, start_time and several more.  The documentation has descriptions of all the columns.
Coco BeansDesignerAuthor Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.