Oracle所有诊断事件列表events是怎样的
Oracle所有诊断事件列表events是怎样的，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。
通过如下的脚本可以获取所有的诊断事件列表：
在UNIX系统下message文件在底下目录$ORACLE_HOME/rdbms/mesg/oraus.msg
在NT系统下message文件在底下目录$ORACLE_HOME/rdbms/mesg/oraus.msg
oraus.msg文件属于文本文件，可以直接打开查看。
诊断事件可以像普通的ORA错误一样采用oerr命令来查询，如下所示：
event="10248 trace name context forever, level 10"
event="10249 trace name context forever, level 10"
另一种方法是在会话过程中使用alter session set events命令，只对当前会话有影响。设置格式如下：
alter session|system set events '[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : .......'
通过:符号，可以连续设置多个事件，也可以通过连续使用alter session set events 来设置多个事件。
SQL> show parameter event
------------------------------------ ----------- ------------------------------
SQL> alter system set event='10046 trace name context forever,level 12';
*
ORA-02095: specified initialization parameter cannot be modified
System altered.
Database closed.
ORACLE instance shut down.
ORA-32004: obsolete and/or deprecated parameter(s) specified
Total System Global Area 1157627904 bytes
Variable Size 402654536 bytes
Redo Buffers 31457280 bytes
Database opened.
NAME TYPE VALUE
event string 10046 trace name context forev
SQL>
System altered.
System altered.
SQL> ALTER system SET event='1461 trace name errorstack level 3';
*
ORA-02095: specified initialization parameter cannot be modified
SQL> ALTER system SET event='1461 trace name errorstack level 3' scope=spfile;
验证是否已成功更改：
File created.
[oracle@rac01 ~]$ grep event 1.ora
这种方法的话，需要重启DB。下面Rollback这个参数更改
System altered.
File created.
[oracle@rac01 ~]$ grep event 2.ora
2. alter system set events：此方法对memory生效，无法对spfile生效
SQL> !
[oracle@rac01 ~]$ tail -n1 /oracle/admin/strm1/bdump/alert_strm1.log
这个参数更改没有反应到spfile中
File created.
[oracle@rac01 ~]$ grep event 3.ora
其实这里的1461是个BUG 6085625，Metalink上可以参照NOTE: 461911.1<br font-size:13.3333px;white-space:normal;" />另外需要注意的是，RAC环境中用方法2动态设置event的话需要在所有instance设置。不过理解了上面的区别的话这个也就很容易明白了。
四. 示例
4.1查看当前trc 文件
select
u_dump.value || '/' ||
db_name.value || '_ora_' ||
v$process.spid ||
nvl2(v$process.traceid, '_' || v$process.traceid, null )
|| '.trc' "Trace File"
from
v$parameter u_dump
cross join v$parameter db_name
cross join v$process
join v$session
on v$process.addr = v$session.paddr
where
u_dump.name = 'user_dump_dest' and
db_name.name = 'db_name' and
v$session.audsid=sys_context('userenv','sessionid');
eg：
/oracle/product/10.2.0/admin/dw/udump\dw_ora_389530.trc
4.2执行event
alter session set events '10046 trace name context forever, level 1';
select count(1) from all_tables;
alter session set events '10046 trace name context off' ;
4.3 在查看dw_ora_389530.trc
$dw_ora_389530.trc
以下是所有的诊断事件列表：
level1：启用标准的sql_trace功能跟踪SQL语句，包括解析、执行、提取、提交和回滚等，等价于SQL_TRACE=TRUE
level4：Level1+包括变量(bindvalues)的详细信息
level8：Level1+包括等待事件
level12：包括绑定变量与等待事件，包含Level1+Level4+Level8
1 PrintSQLstatements,executionplansandexecutionstatistics
4 Aslevel1plusbindvariables
8 Aslevel1pluswaitstatistics
12 Aslevel1plusbindvariablesandwaitstatisticsALTERSESSIONSETEVENTS'10046tracenamecontext forever,level12';
ALTERSESSIONSETEVEVTS'10046tracenamecontextoff';10053CBOEnableoptimizertrace转储优化策略，DumpOptimizerDecisions---在分析SQL语句时,Dump出优化器所做的选择,级别level1最详细
Level Action
1 Printstatisticsandcomputations
2 PrintcomputationsonlyALTERSESSIONSETEVENTS'10053tracenamecontextforever,level1';10704PrintoutinformationaboutwhatenqueuesarebeingobtainedWhenenabled,printsoutargumentstocallstoksqcmiandksqlrlandthereturnvalues。跟踪enqueues，可以查看锁的信息。
Level:1-4:printoutbasicinfoforksqlrl,ksqcmi
5-9:alsoprintoutstuffincallbacks: ksqlac,ksqlop
10+:alsoprintouttimeforeachlineALTERSESSIONSETEVENTS'10704tracenamecontextforever,level10';10710Event10710-TraceBitmapIndexAccess跟踪位图索引的访问情况ALTERSESSIONSETEVENTS'10710tracenamecontextforever,level1';10711Event10711-TraceBitmapIndexMergeOperation跟踪位图索引合并操作ALTERSESSIONSETEVENTS'10711tracenamecontextforever,level1';10712Event10712-TraceBitmapIndexOROperation跟踪位图索引或操作情况ALTERSESSIONSETEVENTS'10712tracenamecontextforever,level1';10713Event10713-TraceBitmapIndexANDOperation跟踪位图索引与操作ALTERSESSIONSETEVENTS'10713tracenamecontextforever,level1';10714Event10714-TraceBitmapIndexMINUSOperation跟踪位图索引minus操作ALTERSESSIONSETEVENTS'10714tracenamecontextforever,level1';10715Event10715-TraceBitmapIndexConversiontoROWIDsOperation跟踪位图索引转换ROWID操作ALTERSESSIONSETEVENTS'10715tracenamecontextforever,level1';10716Event10716-TraceBitmapIndexCompress/Decompress跟踪位图索引压缩和解压缩情况ALTERSESSIONSETEVENTS'10716tracenamecontextforever,level1';10717Event10717-TraceBitmapIndexCompactionALTERSESSIONSETEVENTS'10717tracenamecontextforever,level1';10719Event10719-TraceBitmapIndexDML跟踪位图索引列的DML操作（引起位图索引改变的DML操作）ALTERSESSIONSETEVENTS'10719tracenamecontextforever,level1';10730Event10730-TraceFineGrainedAccessPredicates跟踪细粒度审计的断语ALTERSESSIONSETEVENTS'10730tracenamecontextforever,level1';10731Event10731-TraceCURSORStatements跟踪CURSOR的语句情况，跟踪游标声明ALTERSESSIONSETEVENTS'10731tracenamecontextforever,levellevel';
LEVEL定义
1 Printparentqueryandsubquery
2 Printsubqueryonly10928Event10928-TracePL/SQLExecution跟踪PL/SQL执行情况ALTERSESSIONSETEVENTS'10928tracenamecontextforever,level1';10938Event10938-DumpPL/SQLExecutionStatistics转储PL/SQL执行统计信息，跟踪PL/SQL执行状态。使用前需要执行rdbms/admin下的tracetab.sqlALTERSESSIONSETEVENTS'10938tracenamecontextforever,level1';MemoryDumpsflush_cache刷新BUFFERCACHEALTERSESSIONSETEVENTS'immediatetracenameflush_cache';DROP_SEGMENTS手工删除临时段。当这些临时段无法自动清除的时候可以手工清除altersessionsetevents'immediatetracenameDROP_SEGMENTSlevelts#+1';--ts#是指要删除临时段的表空间的ts#global_area1包含PGA
2包含SGA
4包含UGA
8包含indrectmemoryALTERSESSIONSETEVENTS'immediatetracenameglobal_arealeveln';LibraryCache1librarycache统计信息
2包含hashtablehistogram
3包含objecthandle
4包含object结构（Heap0）ALTERSESSIONSETEVENTS'immediatetracenamelibrary_cachelevel10';RowCachedump数据字典缓冲区中的信息：
1rowcache统计信息
2包含hashtablehistogram
8包含object结构ALTERSESSIONSETEVENTS'immediatetracenamerow_cacheleveln';buffers1bufferheader
2level1+blockheader
3level2+blockcontents
4level1+hashchain
5level2+hashchain
6level3+hashchain
8level4+users/waiters
9level5+users/waiters
10level6+users/waitersALTERSESSIONSETEVENTS'immediatetracenamebuffersleveln';Buffern为某个指定block的rdba，该命令可以转储某个block在buffer中的所有版本。ALTERSESSIONSETEVENTS'immediatetracenamebufferleveln';HeapdumpPGA、SGA、UGA中的信息：
1PGA摘要
2SGA摘要
4UGA摘要
8Currentcall(CGA)摘要
16Usercall(CGA)摘要
32Largecall(LGA)摘要
1025PGA内容
2050SGA内容
4100UGA内容
8200Currentcall内容
16400Usercall内容
32800Largecall内容ALTERSESSIONSETEVENTS'immediatetracenameheapdumplevellevel';SubHeapOracle9.0.1版本之前
ALTERSESSIONSETEVENTS'immediatetracenameheapdump_addrleveln';
若n为subheap的地址，转储的是subheap的摘要信息
若n为subheap的地址+1，转储的则是subheap的内容
Oracle9.2.0版本之后
ALTERSESSIONSETEVENTS'immediatetracenameheapdump_addrleveln,addrm';
其中m为subheap的地址，n为1转储subheap的摘要，n为2转储subheap的内容ProcessState分析进程状态ALTERSESSIONSETEVENTS'immediatetracenameprocessstatelevel10';systemstatedump所有系统状态和进程状态，分析系统状态，最好每10分钟一次，做三次对比
altersessionsetevents'immediatetracenameSYSTEMSTATElevel10';ALTERSESSIONSETEVENTS'immediatetracenamesystemstatelevel10';errorstackdump错误栈信息，通常Oracle发生错误时前台进程将得到一条错误信息，但某些情况下得不到错误信息，可以采用这种方式得到Oracle错误
0Errorstack
1level0+functioncallstack
2level1+processstate
3level2+contextareaALTERSESSIONSETEVENTS'immediatetracenameerrorstackleveln';
altersessionsetevents'604tracenameerrorstackforever';--表示当出现604错误时，dump错误栈和进程栈。
altersessionsetevents'942tracenameerrorstacklevel3';
altersystemsetevents='1438tracenameerrorstackforever,level3';
altersystemsetevents='1438tracenameerrorstackoff';hanganalyzeALTERSESSIONSETEVENTS'immediatetracenamehanganalyzeleveln';WorkArea1SGA信息
2WorkareaTable摘要信息
3WorkareaTable详细信息
ALTERSESSIONSETEVENTS'immediatetracenameworkareatab_dumpleveln';Latches1latch信息
2统计信息ALTERSESSIONSETEVENTS'immediatetracenamelatchesleveln';events1session
2process
3systemALTERSESSIONSETEVENTS'immediatetracenameeventsleveln';LocksALTERSESSIONSETEVENTS'immediatetracenamelocksleveln';SharedServerProcessn取值为1~14ALTERSESSIONSETEVENTS'immediatetracenameshared_server_stateleveln';BackgroundMessagesALTERSESSIONSETEVENTS'immediatetracenamebg_messageslevel(pid+1)';coalesec事件dump指定表空间中的自由区间levelnumber以十六进制表示时，两个高位字节表示自由区间数目，两个低位字节表示表空间号，如0x00050000表示dump系统表空间中的5个自由区间，转换成十进制就是327680，即：
altersessionsetevents'immediatetracenamecoaleseclevel327680';FileDumpsblockdump事件dump数据文件、索引文件、回滚段文件结构，在Oracle8以后该命令已改为：
altersystemdumpdatafile11block9;--表示dump数据文件号为11中的第9个数据块。altersessionsetevents'immediatetracenameblockdumplevel66666';--表示dump块地址为6666的数据块。
block分析数据文件块，转储数据文件n的块m:
altersystemdumpdatafilenblockm;ALTERSYSTEMDUMPDATAFILEfile#BLOCKblock#;
ALTERSYSTEMDUMPDATAFILEfile#BLOCKMINmin#BLOCKMAXmax#;TreeDumpALTERSESSIONSETEVENTS'immediatetracenametreedumplevelobject_id';UndoSegmentHeaderALTERSYSTEMDUMPUNDO_HEADER'segment_name';UndoforaTransactionALTERSYSTEMDUMPUNDOBLOCK'segment_name'XIDxidusnxidslotxidsqn;FileHeaderdump所有数据文件的头部信息：
1控制文件中的文件头信息
2level1+文件头信息
3level2+数据文件头信息
10level3altersessionsetevents'immediatetracenamefile_hdrslevel1';--表示dump所有数据文件头部的控制文件项。
altersessionsetevents'immediatetracenamefile_hdrslevel2';--表示dump所有数据文件的通用文件头。
altersessionsetevents'immediatetracenamefile_hdrslevel10';--表示dump所有数据文件的完整文件头。Controlfile转储控制文件:
1文件头信息
2level1+数据库信息+检查点信息
3level2+可重用节信息
10level3
12altersystemsetevents'immediatetracenamecontrolflevel12';RedologHeader分析日志文件头：
1控制文件中的redolog信息
2level1+文件头信息
3level2+日志文件头信息
10level3altersessionsetevents'immediatetracenameredohdrlevel1';--表示dumpredo日志头部的控制文件项。
altersessionsetevents'immediatetracenameredohdrlevel2';--表示dumpredo日志的通用文件头。
altersessionsetevents'immediatetracenameredohdrlevel10';--表示dumpredo日志的完整文件头。Redolog分析日志文件：
ALTERSYSTEMDUMPLOGFILE'FileName'
SCNMINMinSCNSCNMAXMaxSCNTIMEMINMinTimeTIMEMAXMaxTime
LAYERLayerOPCODEOpcode
DBAMINFile#.Block#DBAMAXFile#.Block#
RBAMINLogFileSequence#.Block#RBAMAXLogFileSequence#.Block#;
其中time=((((yyyy-1988)*12+mm-1)*31+dd-1)*24+hh)*60+mi)*60+ss;ALTERSYSTEMDUMPLOGFILE'FileName';Loghistdump控制文件中的日志历史项：
1dump控制文件中最早和最迟的日志历史项
>1dump2^n个日志历史项altersessionsetevents'immediatetracenameloghistlevel1';--表示只dump最早和最迟的日志历史项。
levelnumber大于等于2时，表示2的levelnumber次方个日志历史项。
altersessionsetevents'immediatetracenameloghistlevel4';--表示dump16个日志历史项。内部事件10000controlfiledebugevent,name'control_file'10001controlfilecrashevent110002controlfilecrashevent210003controlfilecrashevent310004blockrecoverytesting-internalerror10005tracelatchoperationsfordebugging10006blockrecoverytesting-externalerror10007logswitchdebugcrashafternewlogselect,thread10008logswitchdebugcrashafternewlogheaderwrite,thread10009logswitchdebugcrashafteroldlogheaderwrite,thread10010BeginTransaction10011End Transaction10012AbortTransaction10013InstanceRecovery用于监视事务恢复，在Startup时跟踪事务恢复ALTERSESSIONSETEVENTS'10013tracenamecontextforever,level1';10014RollBacktoSavePoint10015UndoSegmentRecovery转储UNDOSEGMENT头部，DumpUndoSegmentHeaders，在事务恢复后做Dump回退段头信息ALTERSESSIONSETEVENTS'10015tracenamecontextforever,level1';10016UndoSegmentextend10017UndoSegmentWrap10018DataSegmentCreate10019Turnoffdata/spacesearchcache10020partiallinkrestoredtolinkedlist(KSG)10021KSTeventtotracecontrolfileheaderwritesandreads10022tracektsgsp10023CreateSaveUndoSegment10024WritetoSaveUndo10025Simulateblockrecoveryerrors10026ApplySaveUndo10027SpecifyDeadlockTraceInformationtobeDumped10028Dumptraceinformationduringlock/resourcelatchcleanup10029sessionlogon(KSU)用于给出会话期间的登陆信息10030sessionlogoff(KSU)用于给出会话期间的注销信息10031sortdebugevent(S*)10032sortstatistics(SOR*)转储排序的统计信息，DumpSortStatistics----Dump排序的统计信息,level10是最详细的ALTERSESSIONSETEVENTS'10032tracenamecontextforever,level10';10033sortruninformation(SRD*/SRS*)转储排序增长的统计信息ALTERSESSIONSETEVENTS'10033tracenamecontextforever,level10';10034accesspathanalysis(APA*)10035Writeparsefailurestoalertlogfile解析失败写入告警日志altersystemsetevents'10035tracenamecontextforever,leve5';
altersystemsetevents'10035tracenamecontextoff';10036createremoterowsource(QKANET)10037allocateremoterowsource(QKARWS)10038dumprowsourcetree(QBADRV)10039typechecking(OPITCA)10040disableresult-cache10041dumpundorecordsskipped10042fileheaderreadsreturnyoungestmirror10043checkconsistencyofowner/waiter/converterlistsinKSQ10044freelistundooperations10045freelistupdateoperations-ktsrsp,ktsunl跟踪Freelist管理操作，TraceFreeListManagementOperations—跟踪FreelistALTERSESSIONSETEVENTS'10045tracenamecontextforever,level1';10047traceswitchingofsessions10048Undosegmentshrink10049protectlibrarycachememoryheaps10050snipertrace10051traceOPIcalls10052don'tcleanupobj$10054CBOEnableoptimizertraceforrecursivestatement(RPI)10055Rowsets:turnoffrowsetsforvariousoperations10056dumpanalyzestats(kdg)10057suppressfilenamesinerrormessages10058usetablescancostintab$.spare110059simulateerrorinlogfilecreate/clear模拟redo日志中的创建和清除错误10060CBOEnablepredicatedump10061disableSMONfromcleaningtempsegment阻止SMON进程在启动时清除临时段10062disableusageofOSRolesinosds10063disableusageofDBAandOPERprivilegesinosds10064threadenabledebugcrashlevel,thread10065limitlibrarycachedumpinformationforstateobjectdumpRestrictLibraryCacheDumpOutputforStateObjectDumps10066simulatefailuretoverifyfile10067forceredologchecksumerrors-blocknumber10068forceredologchecksumerrors-filenumber10069Flashbackimagesforofflinefile arelost10070forcedatafilechecksumerrors-blocknumber10071forcedatafilechecksumerrors-filenumber10072localtempspacetracing-recoverylayer10073latchcleanuptracing10074defaulttracefunctionmaskforkst10075CBODisableouter-jointoregularjoinconversion10076CBOEnablecartesianproductjoincosting10077CBODisableview-mergingoptimizationforouter-joins10078CBODisableconstantpredicateeliminationoptimization10079tracedatasent/receivedviaSQL*Net转储SQL*NET统计信息，DumpSQL*NetStatistics---DumpSQL*NeT的统计信息ALTERSESSIONSETEVENTS'10079tracenamecontextforever,level2';10080dumpablockonasegmentlistwhichcannotbeexchanged10081segmentHighWaterMarkhasbeenadvanced转储高水标记变化，TraceHighWaterMarkChanges—跟踪HWM的改变ALTERSESSIONSETEVENTS'10081tracenamecontextforever,level1';10082freelistheadblockisthesameasthelastblock10083TraceIMCDTinLIMITEDmode10084freelistbecomesempty10085freelistshavebeenmerged10086CBOEnableerrorifkkoandqkadisagreeonobysort10087disablerepairofmediacorruptdatablocks10088CBODisablenewNOTINoptimization10089CBODisableindexsorting10090invokeothereventsbeforecrashrecovery10091CBODisableconstantpredicatemerging10092CBODisablehashjoin10093CBOEnableforcehashjoins10094beforeresizingadatafile10095dumpdebuggercommandstotracefile10096afterthecrossinstancecallwhenresizingadatafile10097aftergeneratingredowhenresizingadatafile10098aftertheOShasincreasedthesizeofadatafile10099afterupdatingthefileheaderwiththenewfilesize10100aftertheOShasdecreasedthesizeofadatafile10101DBWRrefreshfailsoncrossinstanceresizecall10102switchoffanti-joins10103CBODisablehashjoinswapping10104dumphashjoinstatisticstotracefile转储Hash连接统计信息，DumpHashJoinStatistics—DumpHASHJOIN的统计信息,用level10ALTERSESSIONSETEVENTS'10104tracenamecontextforever,level10';10105CBOEnableconstantpredtransandMPswWHERE-clause10106CBODisableevaluatingcorrelationpredlastforNOTIN10107CBOAlwaysusebitmapindex10108CBODon'tusebitmapindex10109CBODisablemoveofnegatedpredicates10110CBOTryindexrowidrangescans10111Bitmapindexcreationswitch10112Bitmapindexcreationswitch10113Bitmapindexcreationswitch10114Bitmapindexcreationswitch10115CBOBitmapoptimizationusemaximalexpression10116CBOBitmapoptimizationswitch10117CBODisablenewparallelcostmodel10118CBOEnablehashjoincosting10119QKADisableGBYsortelimination10120generaterelativefile#differentfromabsolute10121CBODon'tsortbitmapchains10122Disabletransformationofcount(col)tocount(*)10124ForcecreationofsegmentedarraysbykscsAllocate10125Disableremotesortelimination10126Debugoraclejavaxa10127Disableremotequeryblockoperation10128DumpPartitionPruningInformation转储分区休整信息，DumpPartitionPruningInformation—Dump分区表信息，
Level Action
0x0001 Dumppruningdescriptorforeachpartitionedobject
0x0002 Dumppartitioniterators
0x0004 Dumpoptimizerdecisionsaboutpartition-wisejoins
0x0008 DumpROWIDrangescanpruninginformation
在9.0.1或者后面的版本,在level2后还需要建立如下的表:
CREATETABLEkkpap_pruning
(
partition_count NUMBER,
iterator VARCHAR2(32),
partition_level VARCHAR2(32));ALTERSESSIONSETEVENTS'10128tracenamecontextforever,levellevel';10129Alterhistogramlookupforremotequeries10130sortdisablereadaheads10131CONNECTBYdebugevent10132dumpplanaftercompilation10133testingforSQLMemoryManagement10134tracingforSQLMemoryManagementforsession10135CBOdonotcount0rowspartitions10136CBOturnofffixforbug108984810137CBOturnofffixforbug134411110138CBOturnofffixforbug157700310139CBOturnofffixforbug138611910140CBOturnofffixforbug133298010141CBOdisableadditionalkeysforinlistinbitmapoptimization10142CBOturnoffadvancedOR-expansionchecks10143CBOturnoffhints10144CBOturnoffcostbasedselectionofbjioverbsjsubquery10145testauditingnetworkerrors10146enableOracleTRACEcollection10147enablejoinpushthroughUNIONview10148Quarantinetraceevent10149allowthecreationofconstraintswithillegaldateconstants10150importexceptions10152CBOdon'tconsiderfunctioncostsinplans10153Switchtousepublicsynonymifprivateonedoesnottranslate10154SwitchtodisallowsynonymsinDDLstatements10155CBOdisablegenerationoftransitiveOR-chains10156CBOdisableindexfastfullscan10157CBOdisableindexaccesspathforin-list10158CBOpreservepredicateorderinpost-filters10159CBOdisableorder-bysortpushdownintodomainindexes10160CBOdisableuseofjoinindex10161CBOrecursivesemi-joinon/off-switch10162CBOjoin-backeliminationon/off-switch10163CBOjoin-backeliminationon/off-switch10164CBOdisablesubquery-adjustedcardinalityfix10165marksessionforspecialhandlingduringinstanceadministration10166tracelongoperationstatisticsupdates10167CBOuseoldindexMIN/MAXoptimization10168CBOdisablesingle-tablepredicatepredicategeneration10169CBOdisablehistogramsformultipartitions10170CBOuseoldbitmapcosting10171CBOdisabletransitivejoinpredicates10172CBOforcehashjoinback10173DynamicSamplingtime-outerror10174viewjoin-backeliminationswitch10175CBOstartransformationswitch10176CBOcolocatedjoinswitch10177CBOcolocatedjoinswitch10178CBOturnoffhashclusterfilteringthroughmemcmp10179CBOturnofftransitivepredicatereplacement10180temptabletransformationprinterrormessages10181CBOdisablemulti-columnin-listprocessing10182CBOdisablegenerationofimpliedpredicates10183CBOdisablecostrounding10184CBOdisableOR-expiflonginlistonbitmapcolumn10185CBOforceindexjoins10186CBOdisableindexjoin10187CBOadditionalindexjoinswitch10188CBOadditionalindexjoinswitch10189CBOturnoffFFSnullfix10190Analyzeuseoldfrequencyhistogramcollectionanddensity10191Avoidconversionofin-listsbacktoOR-expandedform10192nopushdownwhennumberofgroupsexceednumberofrows10193Forcerepeatablesamplingwithspecifiedseed10194CBOdisablenewLIKEselectivityheuristic10195CBOdon'tusecheckconstraintsfortransitivepredicates10196CBOdisableindexskipscan10197CBOforceindexskipscan10199setparameterinsession10200consistentreadbufferstatus转储一致性读信息10201consistentreadundoapplication转储一致性读中Undo应用10202consistentreadblockheader10203blockcleanout10204signalrecursiveextend10205rowcachedebugging10206transactiontableconsistentread10207consistentreadtransactions'statusreport10208consistentreadloopcheck10209enablesimulatederroroncontrolfile允许在控制文件中模拟错误10210checkdatablockintegrity触发数据块检查事件event="10210tracenamecontextforever,level10"10211触发索引检查事件，我并没有找到这个事件10212checkclusterintegrity10213crashaftercontrolfilewrite模拟在写控制文件后崩溃10214simulatewriteerrorsoncontrolfile模拟在控制文件中的写错误，levelnumber从1-9表示产生错误的块号，大于等于10则每个控制文件将出错10215simulatereaderrorsoncontrolfile模拟在控制文件中的读错误10216dumpcontrolfileheader10217debugsequencenumbers10218dumpubaofappliedundo10219monitormulti-passrowlocking10220showupdatestothetransactiontable转储Undo头部变化10221showchangesdonewithundo转储Undo变化10222rowcache10223transactionlayer-turnonverificationcodes10224indexblocksplit/deletetrace10224事件可以分析索引块分裂及删除altersessionsetevents'10224tracenamecontextforever,level10';
altersessionsetevents'10224tracenamecontextoff';10225free/usedextentrowcache转储基于字典管理的区间的变化10226traceCRapplicationsofundofordataoperations10227verify(multi-piece)rowstructure10228traceapplicationofredobykcocbk10229simulateI/Oerroragainstdatafiles模拟在数据文件上的I/O错误10230KSFDblockrepairtestevent10231skipcorruptedblockson_table_scans_设置在全表扫描时忽略损坏的数据块altersessionsetevents'10231tracenamecontextoff';--关闭会话期间的数据块检查
event="10231tracenamecontextforever,level10"--对任何进程读入SGA的数据块进行检查10232dumpcorruptedblockssymbolicallywhenkcbgotten将设置为软损坏（DBMS_REPAIR包设置或DB_BLOCK_CHECKING为TRUE时设置）的数据块dump到跟踪文件10233skipcorruptedblocksonindexoperations10234triggereventaftercallingkcrapctodoredoNtimes10235checkmemorymanagerinternalstructures用于内存堆检查altersessionsetevents'10235tracenamecontextforever,level1';10236dumpredoonobjectno.orblocktypemismatcherrors1410/810310237simulate^C(fortestingpurposes)10238instantiationmanager10239multi-instancelibrarycachemanager10240dumpdba'sofblocksthatwewaitfor10241remoteSQLexecutiontracing/validation转储远程SQL执行10242suppressOER2063(fortestingdistribw/odifferenterrorlog)10243simulatederrorfortest ofK2GTABlatchcleanup10244maketranidsinerrormsgsprintas0.0.0(fortesting)10245TestingeventusedbyserverI/Oksfd/ksfqmodule10246printtraceofPMONactionstotracefile跟踪PMON进程，将PMON的动作输出到trace文件中altersessionsetevents'10246tracenamecontextforever,level4';
altersessionsetevents'10246tracenamecontextoff';10247Turnonscgcmntracing.(VMSONLY)10248turnontracingfordispatchers跟踪dispatch进程10249turnontracingformulti-statedservers跟踪MTS进程10250TraceallallocateandfreecallstothetopmostSGAheap10251checkconsistencyoftransactiontableandundoblock10252sharedIOpoolerrorsimulation模拟写数据文件头部错误10253limitSQLtextreturnedfromX$KGLNA[1]模拟写redo日志文件错误10254tracecross-instancecalls10255pl/sqlparsechecking10256sharedserverdebugevent10257tracesharedserverloadbalancing10258forcesharedserverstobechosenround-robin10259geterrormessagetextfromremoteusingexplicitcall10260PGAlimit(MB)exceeded-processterminated10260,00000,"PGAlimit(%sMB)exceeded-processterminated"
//*Cause: TheResourceManagerSESSION_PGA_LIMITdirectivewasexceeded
// becausetheprocessusedtoomuchprogramglobalarea(PGA)
// memory.
//*Action: Reducethecomplexityoftheupdateorquery,orcontactyour
// databaseadministratorformoreinformation.10261LimitthesizeofthePGAheap10262Don'tcheckformemoryleaks允许连接时存在内存泄漏altersessionsetevents'10262tracenamecontextforever,level300';--允许存在300个字节的内存泄漏10263Don'tfreeemptyPGAheapextents10265Keeprandomsystemgeneratedoutputoutoferrormessages10266TraceOSDstackusage10267InhibitKSEDMPfortesting10268Don'tdoforwardcoalescewhendeletingextents10269Don'tdocoalescesoffreespaceinSMON10270Debugsharedcursors转储共享游标10271distributedtransactionafterCOLLECT10272distributedtransactionbeforePREPARE10273distributedtransactionafterPREPARE10274distributedtransactionbeforeCOMMIT10275distributedtransactionafterCOMMIT10276distributedtransactionbeforeFORGET10277Cursorsharing(ornot)relatedevent(usedfortesting)10278Internaltesting10279Simulateblockcorruptioninkdb4chk10280Internaltesting-segmentationfaultduringcrashrecovery10281maximumtimetowaitforprocesscreation10282Inhibitsignallingofotherbackgroundswhenonedies10284simulatezero/infiniteasynchI/Obuffering10285Simulatecontrolfileheadercorruption模拟控制文件头部损坏10286Simulatecontrolfileopenerror模拟控制文件打开错误10287Simulatearchivererror模拟归档出错10288Donotcheckblocktypeinktrget10289Doblockdumpstotracefileinhexratherthanfromatted10290Internalsequencetracingevent10291dieintbsdrvtotestcontrolfileundo10292hanganalysistraceevent10293tracelogswitchmediarecoverycheckpoints10294ksrpctracing10295dieafterfileheaderupdatedurningcfxact10296disable37910297sharedI/Opooltracing10298ksfdi/otracing10299TraceprefetchtrackingdecisionsmadebyCKPT10300Distributedtransactiontracing10301EnableLCKtimeouttableconsistencycheck10302tracecreateordropinternaltrigger10303traceloadingoflibrarycacheforinternaltriggers10304tracereplicationtrigger10305traceupdatablematerializedviewtrigger10306tracematerializedviewlogtrigger10307traceRepCatexecution10308replicationtestingevent10309TriggerDebugevent10310tracesynchronouschangetabletrigger10311DisableFlashbackTableTimestampchecking10312Allowdisabletologrowsintothemappingtable10314EnableextrastatsgatheringforCR10316Eventsforextensibletxnheader,nonzeroextheadersize10317Eventsforextensibletxnheader,zeroextheadersize10318Traceextensibletxnheadermovements10319TracePGAstatisticsmaintenance10320Enabledatalayer(kdtgrs)tracingofspacemanagementcalls10321Datafileheaderverificationdebugfailure.10322CBOdon'tsimplifyinlistpredicates10323beforecommittinganadddatafilecommand10324Enablebettercheckingofredologserrors10325Tracecontrolfilerecordsectionexpandandshrinkoperations10326clearlogfiledebugcrashat,log10327simulate00235errorfortesting10328disablefirst-to-mountsplit-brainerror,fortesting10329simulateout-of-memoryerrorduringfirstpassofrecovery10330clearMTTRstatisticsincheckpointprogressrecord10331simulateresilveringduringrecovery10332forceALTERSYSTEMQUIESCERESTRICTEDcommandtofail10333dumpMTTRstatisticseachtimeitisupdated10334forceFGtowaittobekilledduringMTTRadvisorysimulation10335tracedatabaseopenstatus10336DoremoteobjecttransferusingremoteSQL10337enablepaddingownernameinslavesql10338CBOdon'tuseinlistiteratorwithfunction-basedindexes10339CBOdisableDECODEsimplification10340Bufferqueuessanitycheckforcorruptedbuffers10341SimulateoutofPGAmemoryinDBWRduringobjectreuse10342RaiseunknownexceptioninACQ_ADDwhencheckpointing10343Raiseanoutofmemoryexception-OER4031inACQ_ADD10344reservedforsimulatingobjecthashreorganization10345validatequeuewhenlinkingorunlinkingabuffer10346checkthatallbuffersforcheckpointhavebeenwritten10347dumpactivecheckpointentriesandcheckpointbuffers10348testabnormalterminationofprocessinitiatingfilecheckpoint10349donotallowckpttocomplete10350Simulatemorethanoneobject&tsnidinobjectreuse10351sizeofslots10352reportdirectpathstatistics10353numberofslots10354turnondirectreadpathforparallelquery10355turnondirectreadpathforscans10356turnonhintusagefordirectread10357turnondebuginformationfordirectpath调试直接路径机制10358SimulateoutofPGAmemoryincacheadvisoryreset10359turnoffupdatestocontrolfilefordirectwrites10360enabledbwrconsistencychecking10361checkbufferchangevectorcountconsistency10362simulateawriteerrortotakeafileoffline10363Simulatemessagingerrorforfastobjectreuse/checkpoint10364DonotclearGIMH_STC_SHUT_BEGINstateduringshutdown10365turnondebuginformationforadaptivedirectreads10366kgnfstracing10367kgodmtracing10368maximumnumberofinternalerrorsaprocesswilltolerate10369testSQLmonitoringfeature10370parallelqueryserverkillevent10371disableTQhint10372parallelqueryserverkilleventproc10373parallelqueryserverkillevent10375turnonchecksforstatisticsrollups10376enablearchivecompressionloads10377forceslaveallocation10378forcehardprocess/rangeaffinity10380kxfplatchcleanuptestingevent10381kxfplatchcleanuptestingevent10382parallelqueryserverinterrupt(reset)10383autoparallelizationtestingevent10384paralleldataflowschedulertracing10385paralleltablescanrangesamplingmethod10386parallelSQLhashandrangestatistics10387parallelqueryserverinterrupt(normal)10388parallelqueryserverinterrupt(failure)10389parallelqueryserverinterrupt(cleanup)10390Traceparallelqueryslaveexecution10391tracePXgranuleallocation/assignment10392parallelquerydebuggingbits10393printparallelquerystatistics10394generateafakeloadtotestadaptiveandloadbalancing10395adjustsamplesizeforrangetablequeues10397suppressverboseparallelcoordinatorerrorreporting10398enabletimeoutsinparallelquerythreads10399tracebufferallocation10400turnonsystemstatedumpsforshutdowndebugging10401turnonIPC(ksxp)debugging10402turnonIPC(skgxp)debugging10403fakeCPUnumberfordefaultdegreeofparallelism10404crashdbwrafterwrite10405emulatebrokenmirrors10406enabledatetimeTIMESTAMP,INTERVALdatatypecreation10407enabledatetimeTIMEdatatypecreation10408disableOLAPbuiltinwindowfunctionusage10409enablegranulememsetandblockinvalidationatstartup10410triggersimulatedcommunicationserrorsinKSXP10412dumpthecallstackifanerrorissignaled10413forcesimulatederrorfortestingpurposes10414simulatederrorfromevent level10415paralleldegreespecifiedistoolarge,maxvalueallowed10416disablefixfor273673410417limit1filepersbtinfo2()validationcall10418disablere-creatingtempfile10419createtempfilewithoutcreate_scnandtime10420traceKSOOS-processoperations10421enabledumpfromksbwcoifthereisnoreply10422KSUdebugging10423dumpthecallstackifthespecifiederroriscleared10424KGEdebugging10425enableglobalenqueueoperationseventtrace10426enableges/gcsreconfigurationeventtrace10427enableglobalenqueueservicetrafficcontrollereventtrace10428enabletracingofglobalenqueueservicecachedresource10429enabletracingofglobalenqueueserviceIPCcalls10430enableges/gcsdynamicremasteringeventtrace10431enableverificationmessagesonpiconsistency10432enabletracingofglobalcacheservicefusioncalls10433globalenqueueservicetestingevent10434enabletracingofglobalenqueueservicemultipleLMS10435enabletracingofglobalenqueueservicedeadlockdetetction10436enableglobalcacheserviceduplicatepingchecking10437enabletraceofglobalenqueueserviceSoptimizedresources10438forcelowestnodetobemasterofallgcsresources10439enabletracingofglobalcacheservicefusioncalls-part210440enableglobalenqueueserviceinquireresourcemodestrace10441enablediagnosibilitydaemon(DIAG)trace10442enabletraceofkstfor01555diagnostics10443reservedfordatalayerdiagnosticsanddebugging10444enableDLMtimeouttesting10445enabletracingofLMSprioritymanagement10446reservedfordatalayerdiagnosticsanddebugging10447reservedfordatalayerdiagnosticsanddebugging10448DumptraceforOLTPpartialcompressionfeaturesdiagnostics10449enabletraceofkstforundomanageabilityfeaturesdiagnostics10450signalctrl-cinkdddca(dropcolumn)afternrows10451Forceheapsegmentcompressionbypassingcompatibilitychecks10452Cannotdoblockmediarecovery;mediarecoverysessionmaybeinprogress10453Dumpcompressionstatisticstotracefile10454Disablecolumnreorderingduringcompression10455DoCompressionBlockChecking10456cannotopenstandbydatabase;mediarecoverysessionmaybeinprogress10457cannotclosestandbydatabaseduetoactivemediarecovery10458standbydatabaserequiresrecovery10459cannotstartmediarecoveryonstandbydatabase;conflictingstatedetected10460Performbackwardtablescansforconsistentreadreduction10461Simulatecontrolfilecorruptionduringwriteoperation10462enablerecoverydebugmodule10463enablecontrolfiletest10464enableincrementalcheckpointdebugforsplitbraincheck10465forceslavedeathduringparallelcrashrecovery10466enableHARDcheckforblockwrite10467amplifycontrolfilerecordexpansionfortesting10468logwriterdebugmodule10469errorcreatingcontrolfilebackup,nocheckpoint10470disablecompatibilitycheckforlostwritedetection10470,00000,"disablecompatibilitycheckforlostwritedetection"
//*Document:NO
//*Cause:
//*Action:Setthiseventtorundatabasewithlostwritedetection
// enabledincompatibilitymodebelow11.0.
// Level1:equivalentof"typical"setting
// Level2:equivalentof"full"setting
// fortheparameterdb_lost_write_protect
在12c中，Lostwritedetectionrelatedevent
10470,00000,"Lostwritedetectionrelatedevent"
//*Document:NO
//*Cause:
//*Action:Setthiseventtoenablecertainlostwritedetectionrelated
// functionalities.10471PQslaveallocationtimeouttest10472dumpreadinglogbufferhitratiohistogramtolgwrtracefile10473enableBRRtracing10474controlfiletimetracing10475readablestandbydebugevent10476controlfilecorruptionrangetesting10477simulatedrollbackerror10478DBW0fileidentificationtraceevent10479disksectorsizetestevent10480Softassertsforfastdetectionofdatafilestorageproblems10481Backupdatablockfordatafilehasanunloggedchange10482Automaticblockrepaircannotrepairanofflineorread-onlydatafile10483Simulateoverlyadvancedincrementalcheckpoint10484Enabletestmoveoperation在12c中，Enabletracingforonlinedatafilemoveoperation10485Real-TimeQuerycannotbeenabledwhileapplyingmigrationredo.10486Verifydatafile-relatedSGAalignment10487Dumpredomemoryprotectioninformation.10488Dumpblockheadersreadformediarecovery.10489Generatefutureredofortesting10490TraceOSMmisc.events10491TraceOSMmessaging(KFN)events10492TraceOSMmetadataevents10493Returnemptydefinebufferson142210494TraceOSMmetadataevents10495TraceOSMmetadataevents10496Turnofffixforbug255417810497TraceOSMmetadataevents10498Trimblankcharactersincludingcontolcharacters10499TraceOSMmetadataevents10500turnontracesforSMON跟踪SMON进程10501periodicallycheckselectedheap10502CBOdisablethefixforbug209812010503enableuser-specifiedgraduatedbindlengths10504CBOdisablethefixforbug260702910505CBOenabledynamicsamplingdumptotable10506Disablefixforbug258821710507Tracebindequivalencelogic10508Enablefixforbug1477254510509Checkkghusubheapsatcallboundaries10510turnoffSMONchecktoofflinependingofflinerollbacksegment10511turnoffSMONchecktocleanupundodictionary10512turnoffSMONchecktoshrinkrollbacksegments10513turnonIPC(ksmsq)debugging10515turnoneventtousephysicalcleanout10519enableALTERTYPERESETsupport10520recreateviewonlyifdefinitionhaschanged10521CMONconnectionpooltestevent10522turnoffwrapsourcecompression10523forcerecreatepackageevenifdefinitionisunchanged10524CMONconnectionpooltraceevent10525Disableautomaticobjectvalidationfordescribe10526enableslightweightthreadtracing10527enablesSGAallocationtracing10528enablesksmgtracing10530lightweightthreadspawnfailed,errorstack:10531lightweightthreadunittestfailureerror10532lightweightthreadencounteredinternalerror10542Enabletracingforblockcompare10543StandbyBlockMediaRecovery(bmr)andsplitbraintestingevent10544Injectstandbyautobmrfailures10545Printstandbyautobmrmessagesinalertlog10546Cannotperformblockmediarecovery;standbydatabasedoesnothaverequisiteredo.10547Cannotperformblockmediarecovery;standbydatabaseisnotcaughtupwithprimary.10548Cannotperformblockmediarecoveryonaread-onlyplugged-indatafile.10549Cannotperformblockmediarecoveryusingaread-onlyplugged-inbackupdatafile.10550signalerrorduringcreateasselect/createindexafternrows10551Internaltestingfor1551errorhandling10552allowunlimitedcorruptionduringrecovery10553IncompatibleUNTILCONSISTENTclause10554Mediarecoveryfailedtobringdatafile toaconsistentpoint10555Disableredodumping10556EnabletracingformultiinstanceRedoApply10557NIDclearsdatabaseincarnationsectionincontrolfile10558DisableunkeepmarkerhandlingforADG10559LGWRcodepathdebuggingeventfordeferredlogflushonping10560blocktype''10561blocktype'',dataobject#10562Erroroccurredwhileapplyingredotodatablock(file#,block#)10563Testrecoveryhadtocorruptdatablock(file#,block#)inordertoproceed10564tablespace10565Anothertestrecoverysessionisactive10566Testrecoveryhasusedallthememoryitcanuse10567Redoisinconsistentwithdatablock(file#,block#,fileoffsetis bytes)10568Failedtoallocaterecoverystateobject:outofSGAmemory10569Tracedatafileheaderwrites10570Testrecoverycomplete10571Testrecoverycanceled10572Testrecoverycanceledduetoerrors10573Testrecoverytestedredofromchange to10574Testrecoverydidnotcorruptanydatablock10575Giveuprestoringrecovereddatafilestoconsistentstate:outofmemory10576Giveuprestoringrecovereddatafilestoconsistentstate:someerroroccurred10577Cannotinvoketestrecoveryformanagedstandbydatabaserecovery10578Cannotallowcorruptionformanagedstandbydatabaserecovery10579Cannotmodifycontrolfileduringtestrecovery10580Cannotmodifydatafileheaderduringtestrecovery10581Cannotmodifyredologheaderduringtestrecovery10582Thecontrolfileisnotabackupcontrolfile10583Cannotrecoveryfile renamedasmissingduringtestrecovery10584Cannotinvokeparallelrecoveryfortestrecovery10585Testrecoverycannotapplyredothatmaymodifycontrolfile10586Testrecoveryhadtocorrupt1datablockinordertoproceed10587InvalidcountforALLOWnCORRUPTIONoption10588mediarecoveryfileheadervalidation10589Testrecoveryhadtocorrupt datablocksinordertoproceed10590kga(argusdebugger)testflags10591kga(argusdebugger)testflags10592kga(argusdebugger)testflags10593kga(argusdebugger)testflags10594kga(argusdebugger)testflags10595kga(argusdebugger)testflags10596kga(argusdebugger)testflags10597kga(argusdebugger)testflags10598kga(argusdebugger)testflags10599kga(argusdebugger)testflags10600checkcursorframeallocation10601turnondebuggingforcursor_sharing(literalreplacement)10603causeanerrortooccurduringtruncate(fortestingpurposes)10604traceparallelcreateindex10605enableparallelcreateindexbydefault10606traceparallelcreateindex10607traceindexrowidpartitionscan10608tracecreatebitmapindex跟踪位图索引的创建10609traceforarrayindexinsertion10610tracecreateindexpseudooptimizer10611causesmigrationtofail-testingonly10612printsdebuginformationforauto-spacemanagedsegments10613printsdebuginformationforauto-spacemanagedsegments10614Operationnotallowedonthissegment10615Invalidtablespacetypefortemporarytablespace10616Operationnotallowedonthistablespace10617Cannotcreaterollbacksegmentindictionarymanagedtablespace10618Operationnotallowedonthissegment10619Avoidassertionswhenpossible10620Operationnotallowedonthissegment10621specifyretrycountforonlineindexbuildcleanupDMLlockget10622test/traceonlineindex(re)buildtestortraceonlineindexbuildorrebuild10623testsynchronizedflowofSORTrowsintoFORUPDATElockphase10624DisableUJVinvalidationondropindex10625TurnoffredologdumpfortheindexwhenOERI1270010626specifytimeoutforonlineindexrebuildtowaitforDML10627Dumpthecontentoftheindexleafblock10628Turnonsanitycheckforkdissindexskipscanstate10629forceonlineindexbuildtobackoffandretryDMLlockupgrade10630IllegalsyntaxspecifiedwithSHRINKclause10631SHRINKclauseshouldnotbespecifiedforthisobject10632Invalidrowid10633Nospacefoundinthesegment10634Segmentisalreadybeingshrunk10635Invalidsegmentortablespacetype10636ROWMOVEMENTisnotenabled10637Thesegmentdoesnotexist10638Indexstatusisinvalid10639Dumplibrarycacheduringreparseloops10640OperationnotpermittedduringSYSTEMtablespacemigration10641Cannotfindarollbacksegmenttobindto10642Foundrollbacksegmentsindictionarymanagedtablespaces10643DatabaseshouldbemountedinrestrictedmodeandExclusivemode10644SYSTEMtablespacecannotbedefaulttemporarytablespace10645RecursiveExtensioninSYSTEMtablespaceduringmigration10646ToomanyrecursiveextensionsduringSYSTEMtablespacemigration10647TablespaceotherthanSYSTEM,, notfoundinreadonlymode10648TablespaceSYSAUXisnotoffline10649Turnoff/tracelobindexfreelistcoalesce10650disablecache-callbackoptimisation10651incorrectfilenumberblocknumberspecified10652Objecthason-commitmaterializedviews10653Tableisinacluster10654Tableisoftypetemporaryorexternal10655Segmentcanbeshrunk10656Tableisinunusablestateduetoincompleteoperation10657Lobcolumntobeshrunkdoesnotexist10658Lobcolumntobeshrunkismarkedunused10659Segmentbeingshrunkisnotalob10660Segmentisasharedlobsegment10661Invalidoptionspecified10662Segmenthaslongcolumns10663Objecthasrowidbasedmaterializedviews10664Tablehasbitmapjoinindexes10665InjectEvilLiterals10666Donotgetdatabaseenqueuename10667Causesppsttocheckforvalidprocessids10668InjectEvilIdentifiers10690Setshadowprocesscorefiledumptype(Unixonly)10691Setbackgroundprocesscorefiletype(Unixonly)10693Internalevent10700Alteraccessviolationexceptionhandler10701Dumpdirectloaderindexkeys10702Applicationcontinuitydebuggingwasnotenabled10706Printoutinformationaboutglobalenqueuemanipulation跟踪全局enqueues10707Simulateprocessdeathforinstanceregistration10708printouttraceinformationfromtheRACbuffercache跟踪RAC的buffercache10709enableparallelinstancesincreateindexbydefault10718eventtodisableautomaticcompactionafterindexcreation10719tracebitmapindexdml10720tracedbscheduling10721Internaltesting-temptabletransformation10722setparametersforCPUfrequencycalculation(debug)在12c中，traceserverleveldatabasescheduling10723Internaltesting-releasebufferforbuffercacheshrink10724tracecross-instancebroadcast10725bitmapindexversioncontrol10726frequentitemsetcounting10727introducefailureeventsinIPC10728setparametersforCPUfrequencycalculation(debug)10732honorpctfreeduringinsertintoAQIOTs10733testtransient-IOTmetadataduringPMOcleanup10734rerouteexternalprocedures10735debugkswsoperations10736buffercachepinhistorydump10737testblockchecking10738internalblocktesting10739debugWLM(kywm)operations10740disablesfixforbug59886110741tracemissingBRRgeneration10742dumpprocessstateonflushbuffer_cache10743definethemisbehavedvtdumpthresholds10744disableLMDstalecvaktracesanddumps10745enableLCK1kqlmbivg-NULL-kglhdracdump10746enableKGCE_DEBUG_MODE10750testrollbacksegmentblksizeguessingforindexarrayinsert10751overrideforremoterowsourcemaximumbuffersize10752overridefortheExponentialMovingAveragefactor10753enforcedeterministicbehaviourforprefetchingrowsource10754disablefixforbug14173995formulti-tableselectforupdate10755EventtostoreSIG_1551stackstoKST10756Eventtoenablesvpt/autotxntracing10757Eventtocontroltracingrowsource:rowstodumpperrowset10758Eventtocontroltracingrowsource:startrownumber10759Eventtocontroltracingrowsource:endrownumber10760Eventtocontroltracingrowsource:maximumencodedoperandstocheck10761Eventtocontroltracingrowsource:sizeofdictionary10780LogMinerAPItraceevent10781LogMinerreadertraceevent10782LogMinerpreparertraceevent10783LogMinerbuildertraceevent10784LogMinerdictionarytraceevent10785LogMinertraceevent10786callpush/pop(KSU)10787traceintra-instancebroadcast10788tracecallstacks10789LogMinertestevent10790LogMinertraceevent10791LogicalStandbyswithover/failovertraceevent10792LogicalStandbyXDATtraceevent10793LogicalStandbytraceevent10794LogicalStandbytraceevent10795VKTMProcesstraceevent10796ElevateSchedulerPrioritytraceevent10797LogicalStandbyTestEvent10798debugGSMoperations10800disableSmartDiskscan10804reservedforksxb10806Switchto7.3modewhendetachingsessions10807Disableuseridcheckwhenswitchingtoaglobaltransaction10808Enableassertwhenwaitingwithoutareason10809Tracestateobjectallocate/freehistory10810Tracesnapshottooold10811Traceblockcleanouts10812TraceConsistentReads10826enableupgrade/downgradeerrormessagetrace10827enableupgrade/downgradediagnostics10828memoryallocatorerror10830Tracegroupbysortrowsource10831Tracegroupbyrolluprowsource10832TraceapproximateNDVrowsource10833Runtimedistributionkeysforadaptivepartialrollup10834Runtimebehaviorcontrolforadaptivepartialrollup10835excludeSYS_OP_CYCLED_SEQfromTQkeysforscalablepercentile10839trace/debugcachingmodule(qesca.c)10840trace/debugpl/sqlcachingmodule(kkxmInitCache)10841Defaultun-inintializedcharactsetformtoSQLCS_IMPLICIT10842EventforOCITracingandStatisticsInfo10843Eventforclientresultcachetracing10844turnonNativeNetIPCdebugging(skgxp)10845EnableDirectortracing10846EnableDirectorSingleNodeTesting在12c中，Eventfornon-blockingtesting10847OCIdumpactionisbeinginvokedforinternalerror10848OCINonBlockingnotsupportedwith10849InternalOCIeventnumber10850Enabletimemanagertracing10851AllowDropcommandtodropqueuetables10852EnabletracingforEnqueueDequeueOperations10853EnabletracingforReplicatingAQOperations10854SetspollcountusedforAQlistencodeunderRAC10856DisableAQpropagatorfromusingstreaming10857ForceAQpropagatortousetwo-phasecommit10858CrashtheAQpropagatoratdifferentstagesofcommit10859Disableupdatesofmessageretrycount10860eventforAQadmindisablenewnameparser10861disablestoringextendedmessageproperties10862resolvedefaultqueueownertocurrentuserinenqueue/dequeue10863Controlbehaviorofbufferedbackgroundoperations10864eventtoenableAQdedicatedpropagation10865Controltracingofnotificationoperations10866eventtoorderdequeuebycondition10867eventtoturnoffauthenticationforemontoociclientconnections在12c中，turnoffauthenticationforemontoociclientanddisableHArstat10868eventtoenableinteroppatchforAQenqueueoptions10870Disablemulti-instancestandbyroletransition10871dumpfileopen/closetimestampduringmediarecovery10872FlashbackDatabasefaultinsertionevent#.10873file needstobeeithertakenoutofbackupmodeormediarecovered10874ChangemaxlogfilesinhashtableinkrfbVerifyRedoAvailable10875Requireinstancebounceafterswitchovertoprimary10876IDRTestevent10877errorsignaledinparallelrecoveryslave10878parallelrecoveryslavediedunexpectedly10879errorsignaledinparallelrecoveryslave10880traceJavaVMexecution10883EventforFastApplicationNotificationtracing10884TTCevent10885Switchovertestevent10886Recoverytestevent10887AnOracleActiveDataGuardlicenseisrequiredtoopenapluggabledatabasewhilestandbyrecoveryisapplyingchanges.10888TTCeventforoptimizedfetch10889minimumnumberofinstancesneededforredoapplyunavailable10890ADGtestevent10891disablecolumnpruninginANSIjointransformation10892multi-instanceredoapplyencounterednonloggedoperation10893TTCtraceevent10898LGWRtimingevent10900extentmanagerfaultinsertionevent#10901disablethefixforbug123079810902disableseghdrconversionforrooperation10903Forcetablespacestobecomelocallymanaged10904Allowlocallymanagedtablespacestohaveuserallocation10905Docacheverification(kcbcxx)onextentallocation10906Unabletoextendsegmentafterinsertdirectload10907Traceextentmanagementevents10908Tracetemptablespaceevents10909Tracefreelistevents10910injectcornercaseeventsintotheRACbuffercache10911LocallymanagedSYSTEMtablespacebitmapscanbemodifiedonlyunderthesupervisionofOracleSupport10912UsedtoperformadminoperationsonlocallymanagedSYSTEMtablespace10913Createlocallymanageddatabaseifcompatible>920bydefault10914invalidTABLESPACEGROUPclause10915TABLESPACEGROUPcannotbespecifiedforthistypeoftablespace10916TABLESPACEGROUPalreadyspecified10917TABLESPACEGROUPcannotbespecified10918TABLESPACEGROUPnamecannotbethesameastablespacename10919Defaulttemporarytablespacegroupmusthaveatleastonetablespace10920Cannotofflinetablespacebelongingtodefaulttemporarytablespacegroup10921Cannotdroptablespacebelongingtodefaulttemporarytablespacegroup10922Temporarytablespacegroupisempty10923printsdebuginformationforobjectspaceservermanageability10924importstorageparseerrorignoreevent10925tracenamecontextforever10926tracenamecontextforever10927tracenamecontextforever10929tracenamecontextforever10930tracenamecontextforever10931tracenamecontextforever10932tracenamecontextforever10933tracenamecontextforever10934tracenamecontextforever10936tracenamecontextforever10937tracenamecontextforever10939tracenamecontextforever10940tracenamecontextforever10941tracenamecontextforever10943tracenamecontextforever10944tracenamecontextforever10945tracenamecontextforever10946tracenamecontextforever10947tracenamecontextforever10948tracenamecontextforever10949Disableautotunedirectpathreadforfulltablescan10960AQtracingevent10961EnabletracingforSchedulersubscribercleanup10970backouteventforbug213335710971printsdebugginginformationforLOBs10972raisea1551exceptioninkdu_array_flush10973backoutevetfor261950910974TurnonLOBintegrityverification10975traceexecutionofparallelpropagation10976internalpackagerelatedtracing10977traceeventforRepAPI10978generaleventformaterializedviewlogs10979traceflagsforjoinindeximplementation10980preventsharingofparsedqueryduringMaterializedViewquerygeneration10981dscncomputation-relatedeventinreplication10982eventtoturnoffCDC-formatMVLogs10983eventtoenableCreate_Change_Tabledebugging10984subquerymaterializedview-relatedevent10985eventforNULLrefreshofmaterializedviews10986donotuseHASH_AJinrefresh10987eventforthesupportofcachingtablewithobjectfeature10988eventtogetexclusivelockduringmaterializedviewrefreshinIAS10989eventtointernallycreatestatisticsMV10990dumpspreadsheetinfo10991eventforoptimizingtheonlineredefinitioninstantiation10992eventtoenabledbms_jobinsteadofdbms_scheduler10993RuntimeenableIOQbatching10994CompiletimeenableIOQbatching10995generaleventformaterializedviews10997anotherstartup/shutdownoperationofthisinstanceinprogress10998eventtoenableshortstackdumpsinsystemstatedumps10999donotgetdatabaseenqueuename28401屏蔽密码延迟验证，
28401,00000,"Eventtodisabledelayafterthreefailedloginattempts"
//*Document:NO
//*Cause:N/A
//*Action:Setthiseventinyourenvironmenttodisablethelogindelay
// whichwillotherwisetakeplaceafterthreefailedloginattempts.
//*Note:THISISNOTAUSERERRORNUMBER/MESSAGE.THISDOESNOTNEEDTOBE
// TRANSLATEDORDOCUMENTED.ALTERSYSTEMSETEVENTS'28401TRACENAMECONTEXTFOREVER,LEVEL1';--屏蔽密码延迟验证
ALTERSYSTEMSETEVENTS'28401TRACENAMECONTEXTOFF';--关闭28401事件5614566如果数据库版本为Oracle10g以前，那么只能清空整个SharedPool，命令为：“ALTERSYSTEMFLUSHSHARED_POOL;”。在Oracle10g中提供了一个包DBMS_SHARED_POOL，该包可以实现该功能。若该包没有安装，则可以通过$ORACLE_HOME/rdbms/admin/dbmspool.sql进行安装。在Oracle10.2.0.4中有BUG（MOS为：751876.1），需要通过设置事件来规避该问题，命令为：“ALTERSESSIONSETEVENTS'5614566TRACENAMECONTEXTFOREVER';”
使用这种方法，就可以精确的将一个SQL从共享池中删除，从而使得Oracle为这个SQL重新生成执行计划。这种方法只针对单个SQL语句，使得解决问题的同时不会造成任何的误伤。
SYS@lhrdb> SELECTADDRESS,HASH_VALUEFROMV$SQLAREAWHEREROWNUM<=1;
ADDRESS HASH_VALUE
--------------------------
0000000092D263D03231842444
SYS@lhrdb>EXECDBMS_SHARED_POOL.PURGE('0000000092D263D0,3231842444','C');
PL/SQLproceduresuccessfullALTERSESSIONSETEVENTS'5614566TRACENAMECONTEXTFOREVER';
看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注亿速云行业资讯频道，感谢您对亿速云的支持。
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
