Use this SQL to checkSQL> SELECT sid,totalwork,sofar FROM v$session_longops

WHERE sid=153;

Here give SID when back start it will show SID