select MESSAGE,START_TIME,LAST_UPDATE_TIME, SOFAR,TOTALWORK,TIME_REMAINING,ELAPSED_SECONDS from V$SESSION_LONGOPS where SID=88 Index Fast Full Scan: SUPERMAG.SMDOCUMENTS: 2014 out of 2014 Blocks done 20.04.2018 4:25:16 20.04.2018 4:37:24 2014 2014 0 728 Index Fast Full Scan: SUPERMAG.SMDOCUMENTS: 2014 out of 2014 Blocks done 20.04.2018 4:39:29 20.04.2018 4:48:11 2014 2014 0 522 Index Fast Full Scan: SUPERMAG.SMDOCUMENTS: 561 out of 2014 Blocks done 20.04.2018 7:00:54 20.04.2018 15:07:17 561 2014 75584 29183