If you know the session you are looking for (say using a query like the previous post), then with the SID, use the below to get all of the info about it’s progress.
select sofar, time_remaining/60 as time_rem_mins from v$session_longops where sid = 1630
Awesome!
No comments:
Post a Comment