–alter session set nls_date_format=’dd-mon-yy hh24:mi:ss’;
set sqlformat ansiconsole
select * from v$session_longops
where time_remaining > 0;
SID SERIAL# OPNAME SOFAR TOTALWORK UNITS START_TIME LAST_UPDATE_TIME TIME_REMAINING ELAPSED_SECONDS
654 48,837 Gather Database Statistics 1,855 3,286 Objects 23-sep-16 20:05:40 23-sep-16 20:47:05 1,917 2,485
SID SERIAL# OPNAME SOFAR TOTALWORK UNITS START_TIME LAST_UPDATE_TIME TIME_REMAINING ELAPSED_SECONDS
654 48,837 Gather Database Statistics 1,858 3,286 Objects 23-sep-16 20:05:40 23-sep-16 20:49:31 2,022 2,631
SID SERIAL# OPNAME SOFAR TOTALWORK UNITS START_TIME LAST_UPDATE_TIME TIME_REMAINING ELAPSED_SECONDS
654 48,837 Gather Database Statistics 1,911 3,286 Objects 23-sep-16 20:05:40 23-sep-16 20:58:05 2,263 3,145
SID SERIAL# OPNAME SOFAR TOTALWORK UNITS START_TIME LAST_UPDATE_TIME TIME_REMAINING ELAPSED_SECONDS
654 48,837 Gather Database Statistics 1,911 3,286 Objects 23-sep-16 20:05:40 23-sep-16 20:58:05 2,263 3,145