Oracle10g Events CONTROLF的改变

(size = 400, compat size = 400, section max = 10, section in-use = 10, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 160, numrecs = 10) *************************************************************************** RESTORE POINT RECORDS ***************************************************************************
(size = 212, compat size = 212, section max = 2048, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 161, numrecs = 2048) ***************************************************************************
LOG FILE HISTORY RECORDS ***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 22, last-recid= 22, old-recno = 1, last-recno = 22) (extent = 1, blkno = 94, numrecs = 292) Earliest record: RECID #1 Recno 1 Record timestamp 08/17/06 19:45:30 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=1 Low scn: 0x0000.00000001 08/17/06 19:41:33 Next scn: 0x0000.0000850a Latest record: RECID #22 Recno 22 Record timestamp 02/02/07 10:44:31 Thread=1 Seq#=22 Link-Recid=21 kccic-Recid=1 Low scn: 0x0000.00063e6d 01/25/07 17:15:06 Next scn: 0x0000.0006b865 RECID #21 Recno 21 Record timestamp 01/25/07 17:15:06 Thread=1 Seq#=21 Link-Recid=20 kccic-Recid=1 Low scn: 0x0000.0005a8eb 01/25/07 11:22:46 Next scn: 0x0000.00063e6d RECID #20 Recno 20 Record timestamp 01/25/07 11:22:47 Thread=1 Seq#=20 Link-Recid=19 kccic-Recid=1 Low scn: 0x0000.000591bc 01/25/07 11:21:16 Next scn: 0x0000.0005a8eb RECID #19 Recno 19 Record timestamp 01/25/07 11:21:17 Thread=1 Seq#=19 Link-Recid=18 kccic-Recid=1 Low scn: 0x0000.00055826 01/25/07 11:20:02 Next scn: 0x0000.000591bc RECID #18 Recno 18 Record timestamp 01/25/07 11:20:02 Thread=1 Seq#=18 Link-Recid=17 kccic-Recid=1 Low scn: 0x0000.00052492 01/25/07 11:16:18 Next scn: 0x0000.00055826 RECID #17 Recno 17 Record timestamp 01/25/07 11:16:18 Thread=1 Seq#=17 Link-Recid=16 kccic-Recid=1 Low scn: 0x0000.0004fb00 01/25/07 11:03:35 Next scn: 0x0000.00052492 RECID #16 Recno 16 Record timestamp 01/25/07 11:03:36 Thread=1 Seq#=16 Link-Recid=15 kccic-Recid=1 Low scn: 0x0000.0004b072 01/13/07 15:53:08 Next scn: 0x0000.0004fb00 RECID #15 Recno 15 Record timestamp 01/13/07 15:53:08 Thread=1 Seq#=15 Link-Recid=14 kccic-Recid=1 Low scn: 0x0000.00045da5 01/13/07 15:30:39 Next scn: 0x0000.0004b072 RECID #14 Recno 14 Record timestamp 01/13/07 15:30:40 Thread=1 Seq#=14 Link-Recid=13 kccic-Recid=1 Low scn: 0x0000.0003eaff 01/12/07 15:27:28 Next scn: 0x0000.00045da5 RECID #13 Recno 13 Record timestamp 01/12/07 15:27:28 Thread=1 Seq#=13 Link-Recid=12 kccic-Recid=1 Low scn: 0x0000.00039857 01/09/07 15:09:27 Next scn: 0x0000.0003eaff RECID #12 Recno 12 Record timestamp 01/09/07 15:09:27 Thread=1 Seq#=12 Link-Recid=11 kccic-Recid=1 Low scn: 0x0000.0003100e 09/25/06 10:19:55 Next scn: 0x0000.00039857 RECID #11 Recno 11 Record timestamp 09/25/06 10:19:55 Thread=1 Seq#=11 Link-Recid=10 kccic-Recid=1 Low scn: 0x0000.0002c06a 08/22/06 10:46:44 Next scn: 0x0000.0003100e RECID #10 Recno 10 Record timestamp 08/22/06 10:46:44 Thread=1 Seq#=10 Link-Recid=9 kccic-Recid=1 Low scn: 0x0000.00026213 08/17/06 20:13:42 Next scn: 0x0000.0002c06a RECID #9 Recno 9 Record timestamp 08/17/06 20:13:42 Thread=1 Seq#=9 Link-Recid=8 kccic-Recid=1 Low scn: 0x0000.00022efa 08/17/06 20:11:46 Next scn: 0x0000.00026213 RECID #8 Recno 8 Record timestamp 08/17/06 20:11:47 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=1 Low scn: 0x0000.0001f3d5 08/17/06 19:57:06 Next scn: 0x0000.00022efa RECID #7 Recno 7 Record timestamp 08/17/06 19:57:06 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=1 Low scn: 0x0000.0001b362 08/17/06 19:53:44 Next scn: 0x0000.0001f3d5 RECID #6 Recno 6 Record timestamp 08/17/06 19:53:44 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=1 Low scn: 0x0000.00017065 08/17/06 19:52:02 Next scn: 0x0000.0001b362 RECID #5 Recno 5 Record timestamp 08/17/06 19:52:02 Thread=1 Seq#=5 Link-Recid=4 kccic-Recid=1 Low scn: 0x0000.000150ed 08/17/06 19:49:57 Next scn: 0x0000.00017065 RECID #4 Recno 4 Record timestamp 08/17/06 19:49:58 Thread=1 Seq#=4 Link-Recid=3 kccic-Recid=1 Low scn: 0x0000.00012232 08/17/06 19:48:01 Next scn: 0x0000.000150ed RECID #3 Recno 3 Record timestamp 08/17/06 19:48:01 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=1 Low scn: 0x0000.0000e17f 08/17/06 19:46:46 Next scn: 0x0000.00012232 RECID #2 Recno 2 Record timestamp 08/17/06 19:46:47 Thread=1 Seq#=2 Link-Recid=1 kccic-Recid=1 Low scn: 0x0000.0000850a 08/17/06 19:45:30 Next scn: 0x0000.0000e17f RECID #1 Recno 1 Record timestamp 08/17/06 19:45:30 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=1 Low scn: 0x0000.00000001 08/17/06 19:41:33 Next scn: 0x0000.0000850a *************************************************************************** OFFLINE RANGE RECORDS ***************************************************************************
(size = 200, compat size = 200, section max = 163, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 95, numrecs = 163) *************************************************************************** ARCHIVED LOG RECORDS ***************************************************************************
(size = 584, compat size = 584, section max = 28, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 97, numrecs = 28) *************************************************************************** BACKUP SET RECORDS ***************************************************************************
(size = 40, compat size = 40, section max = 409, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 98, numrecs = 409) *************************************************************************** BACKUP PIECE RECORDS ***************************************************************************
(size = 736, compat size = 736, section max = 200, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 99, numrecs = 200) *************************************************************************** BACKUP DATAFILE RECORDS ***************************************************************************
(size = 116, compat size = 116, section max = 282, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 108, numrecs = 282) *************************************************************************** BACKUP LOG RECORDS ***************************************************************************
(size = 76, compat size = 76, section max = 215, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 110, numrecs = 215) *************************************************************************** DATAFILE COPY RECORDS ***************************************************************************
(size = 660, compat size = 660, section max = 223, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 111, numrecs = 223) *************************************************************************** BACKUP DATAFILE CORRUPTION RECORDS ***************************************************************************
(size = 44, compat size = 44, section max = 371, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 120, numrecs = 371) *************************************************************************** DATAFILE COPY CORRUPTION RECORDS ***************************************************************************
(size = 40, compat size = 40, section max = 409, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 121, numrecs = 409) *************************************************************************** DELETION RECORDS ***************************************************************************
(size = 20, compat size = 20, section max = 818, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 122, numrecs = 818) ***************************************************************************
PROXY COPY RECORDS ***************************************************************************
(size = 852, compat size = 852, section max = 249, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 123, numrecs = 249) *************************************************************************** INCARNATION RECORDS ***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 1, last-recid= 1, old-recno = 1, last-recno = 1) (extent = 1, blkno = 138, numrecs = 292) Earliest record: RECID #1 Recno 1 Record timestamp Resetlogs scn and time scn: 0x0000.00000001 08/17/06 19:41:08 Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00 Incarnation (parent inc#, flag)=(0, 2) Latest record: RECID #1 Recno 1 Record timestamp Resetlogs scn and time scn: 0x0000.00000001 08/17/06 19:41:08 Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00 Incarnation (parent inc#, flag)=(0, 2) ***************************************************************************
RMAN STATUS RECORDS ***************************************************************************
(size = 116, compat size = 116, section max = 141, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 155, numrecs = 141) *************************************************************************** DATAFILE HISTORY RECORDS ***************************************************************************
(size = 568, compat size = 568, section max = 57, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 158, numrecs = 57) *************************************************************************** NORMAL RESTORE POINT RECORDS ***************************************************************************
(size = 212, compat size = 212, section max = 2083, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 188, numrecs = 2083) *** END OF DUMP ***
-The End-

http://www.eygle.com/archives/2007/02/10g_controlf_events_changed.html

上一篇：Oracle数据库中物化视图的原理剖析

下一篇：Oracle 数据库优化的R方法(Method R)

昵称 (必填)

验证码 (必填)