ALTER SESSION SET EVENTS 'immediate trace name controlf level 3';

2024-01-22 04:32

本文主要是介绍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';的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/631846

相关文章

poj 3050 dfs + set的妙用

题意: 给一个5x5的矩阵,求由多少个由连续6个元素组成的不一样的字符的个数。 解析: dfs + set去重搞定。 代码: #include <iostream>#include <cstdio>#include <set>#include <cstdlib>#include <algorithm>#include <cstring>#include <cm

Collection List Set Map的区别和联系

Collection List Set Map的区别和联系 这些都代表了Java中的集合,这里主要从其元素是否有序,是否可重复来进行区别记忆,以便恰当地使用,当然还存在同步方面的差异,见上一篇相关文章。 有序否 允许元素重复否 Collection 否 是 List 是 是 Set AbstractSet 否

论文翻译:ICLR-2024 PROVING TEST SET CONTAMINATION IN BLACK BOX LANGUAGE MODELS

PROVING TEST SET CONTAMINATION IN BLACK BOX LANGUAGE MODELS https://openreview.net/forum?id=KS8mIvetg2 验证测试集污染在黑盒语言模型中 文章目录 验证测试集污染在黑盒语言模型中摘要1 引言 摘要 大型语言模型是在大量互联网数据上训练的,这引发了人们的担忧和猜测,即它们可能已

多路转接之select(fd_set介绍,参数详细介绍),实现非阻塞式网络通信

目录 多路转接之select 引入 介绍 fd_set 函数原型 nfds readfds / writefds / exceptfds readfds  总结  fd_set操作接口  timeout timevalue 结构体 传入值 返回值 代码 注意点 -- 调用函数 select的参数填充  获取新连接 注意点 -- 通信时的调用函数 添加新fd到

Android set Tag, findViewWithTag使用

设置了tag为“principal”的view ImageView principal = (ImageView) findViewById(R.id.imagen_home_0);principal.setTag("principal"); 在其它地方获取,获取已经设置了tag为“principal”的view LayoutInflater inflater = LayoutInflate

C++ STL关联容器Set与集合论入门

1. 简介 Set(集合)属于关联式容器,也是STL中最实用的容器,关联式容器依据特定的排序准则,自动为其元素排序。Set集合的底层使用一颗红黑树,其属于一种非线性的数据结构,每一次插入数据都会自动进行排序,注意,不是需要排序时再排序,而是每一次插入数据的时候其都会自动进行排序。因此,Set中的元素总是顺序的。 Set的性质有:数据自动进行排序且数据唯一,是一种集合元素,允许进行数学上的集合相

SIGMOD-24概览Part7: Industry Session (Graph Data Management)

👇BG3: A Cost Effective and I/O Efficient Graph Database in ByteDance 🏛机构:字节 ➡️领域: Information systems → Data management systemsStorage management 📚摘要:介绍了字节新提出的ByteGraph 3.0(BG3)模型,用来处理大规模图结构数据 背景

Eclipse或MyEclipse中Java Working Set管理项目

随着学习JAVA的时间的越来越久,项目也越来越多,Eclipse或MyEclipse界面中显示一堆! 每次工作使用到的项目肯定不会太多...... 每次从这么大数量的工程当中找到自己要使用的, 必须大规模的滚动滚动条...... 图片一   Project Explorer中:    图片二:Package Explorer中: 这样就好找很多了,分类放!

MiniCPM-V: A GPT-4V Level MLLM on Your Phone

MiniCPM-V: A GPT-4V Level MLLM on Your Phone 研究背景和动机 现有的MLLM通常需要大量的参数和计算资源,限制了其在实际应用中的范围。大部分MLLM需要部署在高性能云服务器上,这种高成本和高能耗的特点,阻碍了其在移动设备、离线和隐私保护场景中的应用。 文章主要贡献: 提出了MiniCPM-V系列模型,能在移动端设备上部署的MLLM。 性能优越:

flask-login 生成 cookie,session

flask-login 生成 cookie,session Flask-Login login_user() 显示来自 Set-Cookie 标头的加密 cookie # 模拟一个用户类class User(UserMixin):def __init__(self, id):self.id = id@app.route('/login')def login():# 模拟用户登录过程user