gistfile1.txt

SQL> r
  1* select inst_id, start_time,case when time_remaining > 0 then last_update_time+1/24/60/60*time_remaining else last_update_time end last_update_time,elapsed_seconds elaps,(sofar/totalwork)*100 "%",sql_id,qcsid, message from gv$session_longops where instr(message, 'RMAN') != 1 and last_update_time > trunc(sysdate)-3 and totalwork > 0 order by start_time, last_update_time

INST_ID START_TIME          LAST_UPDATE_TIME      ELAPS       % SQL_ID         QCSID MESSAGE
------- ------------------- ------------------- ------- ------- ------------- ------ ------------------------------------------------------------------------------------------------------------------------
      1 2015/06/08 10:57:53 2015/06/08 10:58:19      26  100.00 5r18zhaddnvbp      0 Flashback Database: Flashback Data Applied : 657 out of 657 Megabytes done
...
      1 2015/06/08 15:27:07 2015/06/08 16:00:11    1984  100.00 566xv98dg4pff      0 Table Scan:  SCOTT.TEST_TBL: 22082 out of 22082 Blocks done
      1 2015/06/08 16:15:54 2015/06/08 16:53:47    2273  100.00 bntbk405hrv5j      0 Table Scan:  SCOTT.TEST_TBL: 22082 out of 22082 Blocks done
      1 2015/06/08 17:00:17 2015/06/08 17:49:33    2956  100.00 cwmmfdyw0ju27      0 Table Scan:  SCOTT.TEST_TBL: 22082 out of 22082 Blocks done
      1 2015/06/08 17:52:11 2015/06/08 18:52:04    3593  100.00 5h383zvd00yjh      0 Table Scan:  SCOTT.TEST_TBL: 22082 out of 22082 Blocks done
      1 2015/06/09 01:02:23 2015/06/09 01:29:02    1599  100.00 5zruc4v6y32f9      0 Advisor:  : 57 out of 57 Sql Statements done

      1 2015/06/09 09:09:15 2015/06/09 13:39:03   14124   87.25 8mj3yvgqw7u6a      0 Table Scan:  SCOTT.TEST_TBL: 19266 out of 22082 Blocks done