本文主要是介绍ALTER SESSION SET EVENTS 'immediate trace name controlf level 3';,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
有些同学不知道如何查看自己的trace的相关信息,下面是我的做的相关实验的一部分!环境是win的,unix上的同样只是路径不同罢了!路径在:E:\oracle\product\10.2.0\admin\orcl\udump
内容如下:
Dump file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3996.trc
Fri Nov 11 10:17:11 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 2
CPU : 4 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:815M/1982M, Ph+PgF:2460M/3875M, VA:1328M/2047M
Instance name: orcl
Redo thread mounted by this instance: 0 <none>
Oracle process number: 15
Windows thread id: 3996, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:() 2011-11-11 10:17:11.945
*** SESSION ID:(159.1) 2011-11-11 10:17:11.945
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 450 blocks
*** 2011-11-11 10:21:43.998
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 23203 (50% x 46407)
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1183313 logseq 7 block 1692
*** 2011-11-11 10:21:44.667
Media Recovery add redo thread 1
*** 2011-11-11 10:22:07.125
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 4096Kb in 23.85s => 0.17 Mb/sec
Total physical reads: 4096Kb
Longest record: 3Kb, moves: 0/147 (0%)
Change moves: 66/311 (21%), moved: 0Mb
Longest LWN: 7Kb, moves: 0/52 (0%), moved: 0Mb
Last redo scn: 0x0000.001211d3 (1184211)
----------------------------------------------
*** 2011-11-11 10:22:08.556
Media Recovery drop redo thread 1
*** 2011-11-11 10:31:12.475
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 23203 (50% x 46407)
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1184209 logseq 7 block 1813
*** 2011-11-11 10:31:13.633
Media Recovery add redo thread 1
*** 2011-11-11 10:31:25.425
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_11_11\O1_MF_1_7_7CS166DZ_.ARC
*** 2011-11-11 10:31:27.489
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_11_11\O1_MF_1_8_7CS168QY_.ARC
*** 2011-11-11 10:31:28.052
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_11_11\O1_MF_1_9_%U_.ARC
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 16922Kb in 14.63s => 1.13 Mb/sec
Total physical reads: 16922Kb
Longest record: 9Kb, moves: 0/12658 (0%)
Change moves: 10658/19028 (56%), moved: 14Mb
Longest LWN: 1028Kb, moves: 4/59 (6%), moved: 4Mb
Last redo scn: 0x0000.0012144a (1184842)
----------------------------------------------
*** 2011-11-11 10:31:28.474
Media Recovery drop redo thread 1
*** 2011-11-11 10:35:14.449
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 23203 (50% x 46407)
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1184857 logseq 9 block 2
*** 2011-11-11 10:35:15.090
Media Recovery add redo thread 1
*** 2011-11-11 10:35:22.930
Media Recovery drop redo thread 1
*** 2011-11-11 10:35:52.864
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 23203 (50% x 46407)
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1184857 logseq 9 block 2
*** 2011-11-11 10:35:53.411
Media Recovery add redo thread 1
*** 2011-11-11 10:36:28.102
Media Recovery Log /
*** 2011-11-11 10:36:29.495
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_11_11\O1_MF_1_9_%U_.ARC
*** 2011-11-11 10:36:29.636
Media Recovery drop redo thread 1
*** 2011-11-11 10:37:05.735
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 23203 (50% x 46407)
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1184857 logseq 9 block 2
*** 2011-11-11 10:37:06.314
Media Recovery add redo thread 1
*** 2011-11-11 10:37:16.719
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
*** 2011-11-11 10:37:16.923
Media Recovery drop redo thread 1
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 23203 (50% x 46407)
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1184857 logseq 9 block 2
*** 2011-11-11 10:37:22.524
Media Recovery add redo thread 1
*** 2011-11-11 10:37:27.266
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
*** 2011-11-11 10:37:27.422
Media Recovery drop redo thread 1
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 23203 (50% x 46407)
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 1184857 logseq 9 block 2
*** 2011-11-11 10:37:34.823
Media Recovery add redo thread 1
*** 2011-11-11 10:37:38.892
Media Recovery Log E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 5Kb in 4.59s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/7 (0%)
Change moves: 5/24 (20%), moved: 0Mb
Longest LWN: 1Kb, moves: 0/5 (0%), moved: 0Mb
Last redo scn: 0x0000.00121465 (1184869)
----------------------------------------------
*** 2011-11-11 10:37:39.533
Media Recovery drop redo thread 1
File 1 (stop scn 1184870) completed recovery at checkpoint scn 1184870
File 2 (stop scn 1184870) completed recovery at checkpoint scn 1184870
File 3 (stop scn 1184870) completed recovery at checkpoint scn 1184870
File 4 (stop scn 1184870) completed recovery at checkpoint scn 1184870
File 5 (stop scn 1184870) completed recovery at checkpoint scn 1184870
File 6 (stop scn 1184870) completed recovery at checkpoint scn 1184870
*** 2011-11-11 10:37:55.228
Prior to RESETLOGS processing...
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE start
*** 2011-11-11 10:37:55.275 3833 kcrr.c
Archiving online redo logfile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
******************************************************
WARNING: Archival will be performed using 2 passes.
The first pass will attempt to determine the end-of-file
of the online redo logfile. The end-of-file is determined
by identifying what is described as a "corrupt" block
header. This will be reported as an ORA-00354 error.
However, this is not really a corrupt block - it is the
end of the redo data.
The second pass will then archive the online redo logfile
using the identified end-of-file information.
******************************************************
Identified logfile 1 as thread 1 sequence 7
Logfile 1 is not current
... NOSWITCH ARCH archival in progress
NOSWITCH archival processing for any existing Async LNS processes
*** 2011-11-11 10:37:56.965 3833 kcrr.c
Archiving online redo logfile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
******************************************************
WARNING: Archival will be performed using 2 passes.
The first pass will attempt to determine the end-of-file
of the online redo logfile. The end-of-file is determined
by identifying what is described as a "corrupt" block
header. This will be reported as an ORA-00354 error.
However, this is not really a corrupt block - it is the
end of the redo data.
The second pass will then archive the online redo logfile
using the identified end-of-file information.
******************************************************
Identified logfile 2 as thread 1 sequence 8
Logfile 2 is not current
... NOSWITCH ARCH archival in progress
NOSWITCH archival processing for any existing Async LNS processes
*** 2011-11-11 10:37:57.919 3833 kcrr.c
Archiving online redo logfile E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
******************************************************
WARNING: Archival will be performed using 2 passes.
The first pass will attempt to determine the end-of-file
of the online redo logfile. The end-of-file is determined
by identifying what is described as a "corrupt" block
header. This will be reported as an ORA-00354 error.
However, this is not really a corrupt block - it is the
end of the redo data.
The second pass will then archive the online redo logfile
using the identified end-of-file information.
******************************************************
Identified logfile 3 as thread 1 sequence 9
Logfile 3 is current
... NOSWITCH ARCH archival in progress
... FINAL ARCH archival in progress
NOSWITCH archival processing for any existing Async LNS processes
Identified logical end-of-file at block# 11 SCN 1184869
*** 2011-11-11 10:37:58.310 9156 kcrr.c
*** 2011-11-11 10:37:58.310 9178 kcrr.c
Changing kcrfhnab from 102401 to 12
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete
*** 2011-11-11 10:37:58.670
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
*** 2011-11-11 10:38:14.287
krvscm(+): Validating controlfile with logical metadata
krvscm(+): Initial controlfile state
krvscm(+): kccdiflg [400001] kccdifl2 [1000]
krvscm(+): kccdi2ldscn [0x0000.00000000]
krvscm(+): kccdi2lrscn [0x0000.00000000]
krvscm(+): Inspecting logical metadata
krvscm(+): Metadata state
krvscm(+): hasPrepSwitchSta [0]
krvscm(+): hasPrepSwitchPri [0]
krvscm(+): hasReceivedDict [0]
krvscm(+): hasDumpedDict [0]
krvscm(+): hasCommittedBor [0]
krvscm(+): hasSwitchedFromPri [0]
krvscm(+): hasStartedTa [0]
krvscm(+): hasValidSess [0]
krvscm(+): hasTxnConsistency [0]
krvscm(+): hasCleanlyShutdown [0]
krvscm(+): Generating new controlfile state from metadata
krvscm(+): Updating controlfile with new state
krvscm(+): New controlfile state
krvscm(+): kccdiflg [400001] kccdifl2 [1000]
krvscm(+): kccdi2ldscn [0x0000.00000000]
krvscm(+): kccdi2lrscn [0x0000.00000000]
krvscm(+): Updating SGA associated with controlfile state
krvscm(+): Validation complete
ktsmgtur(): TUR was not tuned for 1271 secs
ktsmg_advance_slot(): MMNL advances slot after 1271 seconds
*** 2011-11-11 10:43:09.977
DUMP OF CONTROL FILES, Seq # 1239 = 0x4d7
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=1289023629=0x4cd4f08d, Db Name='ORCL'
Activation ID=0=0x0
Control Seq=1239=0x4d7, File size=450=0x1c2
File Number=0, Blksiz=16384, File Type=1 CONTROL
***************************************************************************
DATABASE ENTRY
***************************************************************************
(size = 316, compat size = 316, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 1, numrecs = 1)
11/11/2011 10:17:11
DB Name "ORCL"
Database flags = 0x00400001 0x00001000
Controlfile Creation Timestamp 11/11/2011 10:17:11
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00121467 Resetlogs Timestamp 11/11/2011 10:37:55
Prior resetlogs scn: 0x0000.001075d6 Prior resetlogs Timestamp 11/08/2011 17:07:22
Redo Version: compatible=0xa200100
#Data files = 6, #Online files = 6
Database checkpoint: Thread=1 scn: 0x0000.00121468
Threads: #Enabled=1, #Open=1, Head=1, Tail=1
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000
Max log members = 3, Max data members = 1
Arch list: Head=3, Tail=3, Force scn: 0x0000.00000000scn: 0x0000.00121467
Activation ID: 1294743335
Controlfile Checkpointed at scn: 0x0000.001218e5 11/11/2011 10:43:08
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000
*************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
(size = 276, compat size = 276, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 147, numrecs = 1)
Control AutoBackup date(dd/mm/yyyy)=11/11/2011
Next AutoBackup sequence= 0
Database recovery target inc#:5, Last open inc#:5
flg:0x0, flag:0x0
Change tracking state=0, file index=0, checkpoint count=0
Flashback log count=0, block count=0
Oldest guarantee restore point=0
***************************************************************************
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 = 167, numrecs = 8)
MTTR record for thread 1
MTTR statistics status: 1
Init time: Avg: 12920000 us, Times measured: 1
File open time: Avg: 70000 us, Times measured: 7
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: 0
# of data blocks measured: 0
# of change vectors measured: 0
***************************************************************************
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 = 170, 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 = 171, numrecs = 2048)
***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 3,
last-recid= 3, old-recno = 1, last-recno = 3)
(extent = 1, blkno = 94, numrecs = 292)
Earliest record:
RECID #1 Recno 1 Record timestamp 11/11/11 10:22:07 Thread=1 Seq#=7 Link-Recid=0 kccic-Recid=1
Low scn: 0x0000.00120813 11/11/11 09:59:47 Next scn: 0x0000.00121457
Latest record:
RECID #3 Recno 3 Record timestamp 11/11/11 10:37:58 Thread=1 Seq#=9 Link-Recid=2 kccic-Recid=1
Low scn: 0x0000.00121459 11/11/11 10:13:28 Next scn: 0x0000.00121467
***************************************************************************
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 = 308, section in-use = 37,
last-recid= 37, old-recno = 1, last-recno = 37)
(extent = 1, blkno = 97, numrecs = 308)
Earliest record:
RECID #1 Recno 1 Record timestamp 11/11/11 10:31:17 Thread=1 Seq#=13
Flags: <produced by archive operation> <created by the RMAN process>
Resetlogs scn and time scn: 0x0000.0008297b 09/07/11 16:21:36
filename E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_10_21\O1_MF_1_13_7B2JMGXM_.ARC
Low scn: 0x0000.000d99e8 10/18/11 10:37:49 Next scn: 0x0000.000e3150 10/21/11 17:59:06
Block count=49883 Blocksize=512
Latest record:
RECID #37 Recno 37 Record timestamp 11/11/11 10:37:58 Thread=1 Seq#=9
Flags: <produced by archive operation> <created by the foreground process>
Resetlogs scn and time scn: 0x0000.001075d6 11/08/11 17:07:22
filename E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_11_11\O1_MF_1_9_7CS2N688_.ARC
Low scn: 0x0000.00121459 11/11/11 10:13:28 Next scn: 0x0000.00121467 11/11/11 10:37:58
Block count=11 Blocksize=512
***************************************************************************
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 = 108, 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 = 109, 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 = 118, 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 = 120, 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 = 121, 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 = 130, 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 = 131, 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 = 132, 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 = 133, numrecs = 249)
***************************************************************************
INCARNATION RECORDS
***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 5,
last-recid= 5, old-recno = 1, last-recno = 5)
(extent = 1, blkno = 148, numrecs = 292)
Earliest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.001075d6 11/08/11 17:07:22
Previous Resetlogs scn and time scn: 0x0000.000f15e5 11/07/11 16:09:44
Incarnation (parent inc#, flag)=(4, 0)
Latest record:
RECID #5 Recno 5 Record timestamp
Resetlogs scn and time scn: 0x0000.00121467 11/11/11 10:37:55
Previous Resetlogs scn and time scn: 0x0000.001075d6 11/08/11 17:07:22
Incarnation (parent inc#, flag)=(1, 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 = 165, 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 = 168, 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 = 198, numrecs = 2083)
*** END OF DUMP ***
*** 2011-11-11 10:53:31.958
*** 2011-11-11 10:53:31.958 60680 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2011-11-11 10:53:33.104 60680 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
这篇关于ALTER SESSION SET EVENTS 'immediate trace name controlf level 3';的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!