|
FLASHBACK LOGFILE RECORDS
***************************************************************************
(size = 84, compat size = 84, section max = 2048, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 139, numrecs = 2048)
***************************************************************************
THREAD INSTANCE MAPPING RECORDS
***************************************************************************
(size = 80, compat size = 80, section max = 8, section in-use = 8,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 156, numrecs = 8)
orcl recno=1
UNNAMED_INSTANCE_2 recno=2
UNNAMED_INSTANCE_3 recno=3
UNNAMED_INSTANCE_4 recno=4
UNNAMED_INSTANCE_5 recno=5
UNNAMED_INSTANCE_6 recno=6
UNNAMED_INSTANCE_7 recno=7
UNNAMED_INSTANCE_8 recno=8
***************************************************************************
MTTR RECORDS
***************************************************************************
(size = 100, compat size = 100, section max = 8, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 157, numrecs = 8)
MTTR record for thread 1
MTTR statistics status: 1
Init time: Avg: 18105555 us, Times measured: 3
File open time: Avg: 24040 us, Times measured: 10
Log block read time: Avg: 20 us, Times measured: 65536
Data block read/claim time: Avg: 170 us, Times measured: 1000
Data block write time: Avg: 390 us
1000 change vector apply time: Avg: 0 us, Times measured: 1
Ratio Information:
# of log blocks measured: 562716
# of data blocks measured: 10888
# of change vectors measured: 467327
***************************************************************************
STANDBY DATABASE MAP RECORDS
***************************************************************************
(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 = 8,
last-recid= 8, old-recno = 1, last-recno = 8)
(extent = 1, blkno = 94, numrecs = 292)
Earliest record:
RECID #1 Recno 1 Record timestamp 05/13/15 08:14:44 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
Low scn: 0x0000.0005eca9 05/13/15 08:13:06 Next scn: 0x0000.00060604
Latest record:
RECID #8 Recno 8 Record timestamp 05/14/15 05:39:06 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=2
Low scn: 0x0000.000664e0 05/13/15 11:58:30 Next scn: 0x0000.0006b6fd
RECID #7 Recno 7 Record timestamp 05/13/15 11:58:35 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=2
Low scn: 0x0000.00063520 05/13/15 10:55:05 Next scn: 0x0000.000664e0
RECID #6 Recno 6 Record timestamp 05/13/15 10:55:05 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=2
Low scn: 0 |