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
WHERE input_type='DB INCR'
ORDER BY session_key;
Code: Select all
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ------------- --------- -------------- -------------- -------
35244 DB INCR FAILED 01/23/13 22:03 01/24/13 20:43 22.67
35251 DB INCR FAILED 01/24/13 00:38 01/25/13 10:02 33.40
35293 DB INCR FAILED 01/24/13 22:05 01/25/13 15:06 17.02
35298 DB INCR FAILED 01/25/13 00:39 01/25/13 15:06 14.45
35354 DB INCR FAILED 01/25/13 22:02 01/27/13 06:56 32.89
35360 DB INCR FAILED 01/26/13 00:37 01/27/13 13:12 36.58
35407 DB INCR FAILED 01/26/13 22:02 01/27/13 20:42 22.66
35411 DB INCR FAILED 01/27/13 00:38 01/27/13 20:42 20.08
35457 DB INCR FAILED 01/27/13 22:01 01/29/13 07:57 33.93
35464 DB INCR FAILED 01/28/13 00:36 01/29/13 13:07 36.53
35503 DB INCR RUNNING 01/28/13 22:01
35507 DB INCR RUNNING 01/29/13 00:35
35544 DB INCR RUNNING 01/29/13 22:03
35549 DB INCR RUNNING 01/29/13 23:38
35551 DB INCR FAILED 01/29/13 23:45 01/29/13 23:52 .12
35554 DB INCR RUNNING 01/30/13 00:05
35556 DB INCR RUNNING 01/30/13 00:39
35558 DB INCR FAILED 01/30/13 01:41 01/30/13 10:02 8.36
35602 DB INCR RUNNING 01/30/13 22:04
35606 DB INCR RUNNING 01/30/13 23:22
35611 DB INCR RUNNING 01/31/13 00:40
35659 DB INCR FAILED 01/31/13 22:02 02/02/13 03:09 29.13
35667 DB INCR FAILED 02/01/13 00:36 02/02/13 23:42 47.09
35715 DB INCR FAILED 02/01/13 22:04 02/03/13 19:44 45.67
35724 DB INCR FAILED 02/02/13 00:38 02/03/13 02:32 25.89
35966 DB INCR FAILED 02/06/13 22:23 02/07/13 00:44 2.35
35970 DB INCR FAILED 02/07/13 00:40 02/07/13 18:41 18.02
36016 DB INCR FAILED 02/08/13 22:03 02/10/13 05:08 31.07
36020 DB INCR FAILED 02/09/13 00:38 02/10/13 06:52 30.24
36137 DB INCR RUNNING 02/11/13 16:31
36145 DB INCR RUNNING 02/11/13 19:06
36152 DB INCR RUNNING 02/11/13 23:12
36161 DB INCR RUNNING 02/12/13 01:47
36168 DB INCR FAILED 02/12/13 08:42 02/14/13 18:16 57.57
36172 DB INCR FAILED 02/12/13 08:44 02/14/13 18:18 57.56
36174 DB INCR RUNNING 02/12/13 08:46
36176 DB INCR RUNNING 02/12/13 08:52
36252 DB INCR RUNNING 02/13/13 22:04
36259 DB INCR FAILED 02/14/13 00:40 02/15/13 04:16 27.61
36300 DB INCR RUNNING 02/15/13 22:02
36306 DB INCR FAILED 02/16/13 00:36 02/16/13 06:56 6.34
36401 DB INCR FAILED 02/18/13 22:02 02/19/13 08:37 10.58
36405 DB INCR FAILED 02/19/13 00:37 02/19/13 00:37 .00