Thursday, December 3, 2015

How to check when the query execution compltes

Query:
=====

set linesize 333
select SID, opname,START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,TIME_REMAINING/60,
sysdate + TIME_REMAINING/3600/24 end_at
from gv$session_longops

where totalwork > sofar;


No comments:

Post a Comment