List operations remaining time > 10 minutes :
SQL>select username,sid, opname, target, sofar, totalwork, units, to_char(start_time,'YYYYMMDD-HH24:MI:SS') StartTime, time_remaining, message from V$SESSION_LONGOPS where time_remaining>600; USERNAME SID OPNAME TARGET SOFAR TOTALWORK UNITS STARTTIME TIME_REMAINING MESSAGE ------------ ------ ---------- ---------- ------- ---------- ------- ----------------- -------------- --------------------------------------------------------- TETSUSER 5704 Table Scan TETSUSER.TEST 22414 39677 Blocks 20180920-10:55:49 3676 Table Scan: JAMES.TEST: 22414 out of 39677 Blocks done