Sample Output:col STATUS format a9
col hrs format 999.99
SELECT SESSION_KEY,
INPUT_TYPE,
STATUS,
TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,
TO_CHAR(END_TIME,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs
FROM V$RMAN_BACKUP_JOB_DETAILS
ORDER BY session_key;
Code: Select all
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ------------- --------- -------------- -------------- -------
35095 ARCHIVELOG COMPLETED 01/21/13 03:46 01/21/13 04:21 .58
35113 ARCHIVELOG COMPLETED 01/21/13 06:43 01/21/13 07:23 .68
35116 ARCHIVELOG COMPLETED 01/21/13 07:45 01/21/13 08:15 .49
35119 ARCHIVELOG COMPLETED 01/21/13 08:45 01/21/13 09:04 .31
35122 ARCHIVELOG COMPLETED 01/21/13 09:47 01/21/13 10:40 .89
35126 ARCHIVELOG COMPLETED 01/21/13 12:20 01/21/13 13:21 1.02
35129 ARCHIVELOG COMPLETED 01/21/13 16:59 01/21/13 17:00 .01
35131 ARCHIVELOG COMPLETED 01/21/13 17:59 01/21/13 18:40 .67
35134 ARCHIVELOG COMPLETED 01/21/13 19:00 01/21/13 19:10 .17
35137 ARCHIVELOG COMPLETED 01/21/13 20:00 01/21/13 21:00 1.01
35140 ARCHIVELOG COMPLETED 01/21/13 22:36 01/21/13 23:41 1.09
35143 ARCHIVELOG FAILED 01/22/13 03:47 01/22/13 05:43 1.93
35145 ARCHIVELOG COMPLETED 01/22/13 06:22 01/22/13 06:41 .31
35148 ARCHIVELOG COMPLETED 01/22/13 07:23 01/22/13 07:24 .01
35150 ARCHIVELOG COMPLETED 01/22/13 08:23 01/22/13 08:35 .20
35153 ARCHIVELOG COMPLETED 01/22/13 09:23 01/22/13 09:30 .12
35156 ARCHIVELOG COMPLETED 01/22/13 10:23 01/22/13 10:30 .12
35159 ARCHIVELOG COMPLETED 01/22/13 11:23 01/22/13 11:29 .11
35162 ARCHIVELOG COMPLETED 01/22/13 12:23 01/22/13 12:33 .16
35165 ARCHIVELOG COMPLETED 01/22/13 13:24 01/22/13 13:25 .01
35167 ARCHIVELOG COMPLETED 01/22/13 14:24 01/22/13 14:37 .21
35170 ARCHIVELOG COMPLETED 01/22/13 15:24 01/22/13 15:25 .01
35172 ARCHIVELOG COMPLETED 01/22/13 16:24 01/22/13 16:25 .01
35174 ARCHIVELOG COMPLETED 01/22/13 17:24 01/22/13 17:25 .01
35176 ARCHIVELOG COMPLETED 01/22/13 18:25 01/22/13 18:26 .01
35178 ARCHIVELOG COMPLETED 01/22/13 19:25 01/22/13 19:43 .30
35181 ARCHIVELOG COMPLETED 01/22/13 20:29 01/22/13 20:32 .05
35183 ARCHIVELOG COMPLETED 01/22/13 21:30 01/22/13 21:47 .28
35186 ARCHIVELOG COMPLETED 01/22/13 22:31 01/22/13 22:41 .17
35189 ARCHIVELOG COMPLETED 01/22/13 23:32 01/22/13 23:33 .01
35191 ARCHIVELOG COMPLETED 01/23/13 00:32 01/23/13 00:33 .01
35193 ARCHIVELOG COMPLETED 01/23/13 01:33 01/23/13 01:43 .17
35196 ARCHIVELOG COMPLETED 01/23/13 02:34 01/23/13 02:34 .01
35198 ARCHIVELOG COMPLETED 01/23/13 03:39 01/23/13 03:57 .30
35201 ARCHIVELOG COMPLETED 01/23/13 04:40 01/23/13 05:01 .35
35204 ARCHIVELOG COMPLETED 01/23/13 07:14 01/23/13 07:27 .22
35207 ARCHIVELOG COMPLETED 01/23/13 08:14 01/23/13 08:15 .01
35209 ARCHIVELOG COMPLETED 01/23/13 09:14 01/23/13 09:28 .22
35212 ARCHIVELOG COMPLETED 01/23/13 10:14 01/23/13 10:15 .01
35214 ARCHIVELOG COMPLETED 01/23/13 11:14 01/23/13 11:15 .01
35216 ARCHIVELOG COMPLETED 01/23/13 12:14 01/23/13 12:31 .28
35219 ARCHIVELOG COMPLETED 01/23/13 13:15 01/23/13 13:29 .25
35222 ARCHIVELOG COMPLETED 01/23/13 14:15 01/23/13 14:22 .13
35225 ARCHIVELOG COMPLETED 01/23/13 15:15 01/23/13 15:22 .12
35228 ARCHIVELOG COMPLETED 01/23/13 16:15 01/23/13 16:26 .20
35231 ARCHIVELOG COMPLETED 01/23/13 17:15 01/23/13 17:24 .15
35234 ARCHIVELOG COMPLETED 01/23/13 18:16 01/23/13 18:17 .01
35236 ARCHIVELOG COMPLETED 01/23/13 19:19 01/23/13 19:39 .33
35239 ARCHIVELOG COMPLETED 01/23/13 20:24 01/23/13 20:25 .01
35241 ARCHIVELOG COMPLETED 01/23/13 21:29 01/23/13 21:55 .42
35244 DB INCR FAILED 01/23/13 22:03 01/24/13 20:43 22.67
35246 ARCHIVELOG COMPLETED 01/23/13 22:32 01/23/13 22:33 .01
35248 ARCHIVELOG COMPLETED 01/23/13 23:38 01/24/13 00:01 .39
35251 DB INCR FAILED 01/24/13 00:38 01/25/13 10:02 33.40
35253 ARCHIVELOG COMPLETED 01/24/13 00:39 01/24/13 00:59 .33
35256 ARCHIVELOG COMPLETED 01/24/13 01:40 01/24/13 02:00 .33
35259 ARCHIVELOG COMPLETED 01/24/13 04:17 01/24/13 05:31 1.23
35262 ARCHIVELOG COMPLETED 01/24/13 09:27 01/24/13 10:02 .59
35266 ARCHIVELOG COMPLETED 01/24/13 13:02 01/24/13 13:21 .32
35270 ARCHIVELOG COMPLETED 01/24/13 14:01 01/24/13 14:22 .34
35273 ARCHIVELOG COMPLETED 01/24/13 15:02 01/24/13 15:18 .28
35276 ARCHIVELOG COMPLETED 01/24/13 16:03 01/24/13 16:04 .02
35278 ARCHIVELOG COMPLETED 01/24/13 17:02 01/24/13 17:22 .33
35281 ARCHIVELOG COMPLETED 01/24/13 18:08 01/24/13 18:37 .49
35284 ARCHIVELOG COMPLETED 01/24/13 19:09 01/24/13 19:28 .32
35287 ARCHIVELOG COMPLETED 01/24/13 20:13 01/24/13 20:50 .63
35290 ARCHIVELOG COMPLETED 01/24/13 21:15 01/24/13 21:57 .70
35293 DB INCR FAILED 01/24/13 22:05 01/25/13 15:06 17.02
35295 ARCHIVELOG COMPLETED 01/24/13 22:17 01/24/13 23:04 .79
35298 DB INCR FAILED 01/25/13 00:39 01/25/13 15:06 14.45