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

 


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
### 回答1: The command "alter session set events 'immediate trace name controlf level 1'" is an Oracle database command that generates a trace file for the current database session. The trace file contains detailed information about the database session and can be used for performance tuning and troubleshooting. Specifically, this command generates a trace file with the name "controlf" and sets the tracing level to 1. The tracing level determines the amount of detail that is included in the trace file. A level of 1 is the lowest level of detail and generates a trace file that includes basic information about the session, such as the SQL statements that are executed and the time it takes to execute them. It's important to note that this command should only be used by experienced database administrators who understand how to interpret the information in the trace file. Additionally, this command should only be used in a controlled testing environment, as it can have a significant impact on database performance. ### 回答2: "alter session set events 'immediate trace name controlf level 1';"是一个Oracle数据库的SQL语句。这个语句的作用是立即开启一个名为controlf的跟踪事件,并将其级别设置为1。 跟踪事件是用来跟踪和记录数据库操作的工具。当开启一个跟踪事件后,系统会记录下相应的跟踪数据,包括SQL语句、执行计划以及性能统计等。 在这个SQL语句中,"alter session set events"是用来改变当前会话的事件设置。'immediate trace name controlf level 1'是具体要设置的事件内容。 其中,'immediate'表示立即执行,'trace'表示要跟踪的事件类型为跟踪文件,'name controlf'表示具体要开启的跟踪事件名称为controlf,'level 1'表示要设置的跟踪事件级别为1,级别数字越高,跟踪信息越详细。 通过这个SQL语句,我们可以在Oracle数据库中开启一个controlf跟踪事件,并设定其级别为1。这将在数据库中生成一个跟踪文件,其中包含了与该事件相关的详细信息,用于分析和调优数据库的性能问题。 ### 回答3: `alter session set events 'immediate trace name controlf level 1';` 这是一个用于在Oracle数据库中启用跟踪的命令。 该命令包括以下几个关键部分: 1. `alter session`: 表示要对当前会话进行修改。 2. `set events`: 表示设置要执行的事件。 3. `'immediate trace name controlf level 1'`: 是具体要执行的事件命令,其中包括以下几个参数: - `immediate`: 表示事件应立即执行。 - `trace`: 表示要进行跟踪。 - `name controlf`: 表示要启用的跟踪名称为'controlf'。 - `level 1`: 表示跟踪的详细级别,此处设置为1级。 当执行这个命令时,Oracle数据库会立即启用名为'controlf'的跟踪,并将跟踪的详细级别设置为1级。跟踪信息会记录在跟踪文件中,其中包括了与数据库控制文件相关的操作和事件。 通过查看跟踪文件,可以获得有关控制文件的详细信息,例如控制文件的读取、写入和更改操作等。这对于诊断和解决与数据库控制文件相关的问题非常有用。 需要注意的是,启用跟踪可能会对数据库的性能产生一定影响,因此在使用之前应谨慎评估,并只在必要时启用跟踪。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值