Skip to content

Instantly share code, notes, and snippets.

@yoshikaw
Created June 9, 2015 04:06
Show Gist options
  • Save yoshikaw/3a8004140818800e01f4 to your computer and use it in GitHub Desktop.
Save yoshikaw/3a8004140818800e01f4 to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment