/Oracle數(shù)據(jù)庫診斷事件詳解什么是Oracle數(shù)據(jù)庫的診斷事件呢？簡而言之的來說Oracle的診斷事件就是Oracle數(shù)據(jù)庫中用于實現(xiàn)一些特殊功用的類別，一般主要用于實現(xiàn)以下幾個方面的功用：改變Oracle數(shù)據(jù)庫的行為啟用收集Oracle數(shù)據(jù)庫的跟蹤或者調(diào)試信息啟用對Oracle數(shù)據(jù)庫的額外的錯誤檢測

一、Oracle數(shù)據(jù)庫診斷事件簡介

什么是Oracle數(shù)據(jù)庫的診斷事件呢？簡而言之的來說Oracle的診斷事件就是Oracle數(shù)據(jù)庫中用于實現(xiàn)一些特殊功用的類別，一般主要用于實現(xiàn)以下幾個方面的功用：

?改變Oracle數(shù)據(jù)庫的行為

?啟用收集Oracle數(shù)據(jù)庫的跟蹤或者調(diào)試信息

?啟用對Oracle數(shù)據(jù)庫的額外的錯誤檢測如何去設置Oracle數(shù)據(jù)庫的各種診斷事件呢？我們首先來給設置診斷事件下一個簡單的定義，就是讓Oracle數(shù)據(jù)庫產(chǎn)生跟蹤信息日志文件。設置診斷事件有如下的四種方法：

?在INIT或者SPFILE初始化文件中設置

這種設置的診斷事件都是針對于整個實例的：

event='eventtracenamecontextforever,levellevel';

如果需要設置多個診斷事件，可以通過以下兩種方法：

方法一：使用冒號分隔開兩個診斷事件

event="10248tracenamecontextforever,level10:10249tracenamecontextforever,level10"

方法二：使用連續(xù)的行設置診斷事件

event="10248tracenamecontextforever,level10"

event="10249tracenamecontextforever,level10"

?在當前SQL會話中設置

針對整個實例的診斷事件的設置：

ALTERSYSTEMSETEVENTS'eventtracenamecontextforever,levellevel';

禁用設置的診斷事件：

ALTERSYSTEMSETEVENTS'eventtracenamecontextoff';

針對當前會話的診斷事件的設置：

ALTERSESSIONSETEVENTS'eventtracenamecontextforever,levellevel';

禁用設置的診斷事件：

ALTERSESSIONSETEVENTS'eventtracenamecontextoff';

?在另外一個SQL會話中使用DBMS_SYSTEM.SETEV存儲過程設置

EXECUTEsys.dbms_system.set_ev(sid,serial#,,,'')

其中的SID,SERIAL#都是從視圖V$SESSION中獲得的。

?在另外一個會話中使用debug工具設置

對一個進程設置診斷事件：

ORADEBUGEVENTeventTRACENAMECONTEXTFOREVER,LEVELlevel

禁用設置的診斷事件：

ORADEBUGEVENTeventTRACENAMECONTEXTOFF

對一個會話設置診斷事件：

ORADEBUGSESSION_EVENTeventTRACENAMECONTEXTFOREVER,LEVELlevel

禁用設置的診斷事件：

ORADEBUGSESSION_EVENTeventTRACENAMECONTEXTOFF注：在Oracle8i以上的版本中，是使用sysdba權限的用戶登陸sqlplus后執(zhí)行ORADEBUG命令；在Oracle7.3/8.0的版本中，是使用internal用戶登陸svrmgrl后執(zhí)行ORADEBUG命令；在更早的Oracle版本中使用ORADBX(ORAMBX在VMS系統(tǒng)上)。因為oradebug允許在另外的會話中設置診斷事件，這樣就可以跟蹤一些平時不太trace的會話，例如對export工具的診斷。診斷事件可以分成會話級的診斷事件和進程級的診斷事件，進程級的診斷事件是可以在INIT初始化參數(shù)文件中設定，會話級的診斷事件則可以使用"altersession..."或者"altersystem..."命令來設定。Oracle數(shù)據(jù)庫在檢測診斷事件的時候都是先檢測會話級的診斷事件，然后再檢測進程級的診斷事件。對于設置Oracle數(shù)據(jù)庫的診斷事件都必須遵循一定的語法，例如在會話級別上設置診斷事件可以按照以下的語法來設置：

altersessionsetevents'10181tracenamecontextforever,level1000';

而同樣的診斷事件在INIT初始化參數(shù)文件中就應該按照以下語法設置：

event="10181tracenamecontextforever,level1000"

在INIT初始化參數(shù)文件中設置診斷事件的時候，一般來說最好在診斷事件后加上相關的注釋，注釋的內(nèi)容一般來說應該包括診斷事件的作用、為什么要使用這個診斷事件以及設置診斷事件的時間。

下面這個圖是關于設置診斷事件的語法表：

診斷事件規(guī)定的語法為：

{:}*

EventName:它代表關聯(lián)事件的符號名或者是一個事件號。如果是immediate，代表是一個立即無條件的診斷事件，不用去等待任何人發(fā)布它；也可以是指定的Oracle錯誤號碼，還可以是具體的事件名。

Action：分為和。ActionKeyWord的值可以是trace、debugger、crash，而qualifiers的語法則是依賴于具體的Action。

?當為crash的時候，語法為：

""(默認為空)|"off"(在等待事件中禁用crash)|"aftertimes"(發(fā)生此事件N次后crash)

?當為debugger的時候，語法為：

""(默認為空)|"off"(在等待事件中禁用debugger)|"aftertimes"(發(fā)生此事件N次后debugger)|"forever"(一旦開始debugger,以后每次發(fā)生事件時都要debugger)|"lifetime"(一旦開始debugger,以后N次發(fā)生事件時都要debugger，然后在此診斷事件中禁用debugger)

?當為trace的時候，語法為：

"name"{,}*

TraceName:是關聯(lián)內(nèi)部trace號的符號名。其中，context是一種特殊的tracename，它不會去調(diào)用調(diào)試dump操作，但是卻會返回給發(fā)起診斷事件者是否context跟蹤被激活，跟蹤是什么級別的。跟蹤的級別是指dump程序內(nèi)部使用來控制dump出來詳細信息的級別，通常來說，級別越高，dump出來的信息就會越詳細，最低級別是1。All是另外一種特殊的tracename，它意味著通過"ksdtradv"宏在編譯的時候聲明所有的tracenames。如果在診斷事件中關聯(lián)多余一個以上的trace，至少有一個應該是context，相應的，診斷事件中最后一個關聯(lián)的動作將返回跟蹤的級別，而且在不同的調(diào)用中診斷事件號最好唯一。

tracequalifier的語法為：

""(默認為空)|"off"(在等待事件中禁用這個trace)|"aftertimes"(發(fā)生此事件N次后開始trace)|"forever"(一旦激活trace,以后每次發(fā)生事件時都要trace)|"lifetime"(一旦開始trace,以后N次成功發(fā)生事件時都要trace，然后在此診斷事件中禁用trace)|"level"(當trace第一次被激活，設置初始化級別為N，之后激活的trace的級別則由tracetype來決定)|"type"(如何修改以后激活的trace的級別)

tracetype：

"increment"升高級別直至最高

"decrement"降低級別到0并且禁用

"constant"保持級別不變

此外，對于trace的指定，如果設置診斷事件是immediate，那么意味著trace將不會等待診斷事件，在tracequalifier中只需要設置trace的級別，lifetime默認為1。對于設置診斷事件，Oracle數(shù)據(jù)庫提供了四個跟蹤信息的類別可以供我們來使用：

?類別一：DumpSomething

這個類別的Trace文件是無條件立即生成的，一般都是dump出Oracle數(shù)據(jù)庫的數(shù)據(jù)，例如查看重做日志文件的頭或者是查看控制文件中的內(nèi)容等。這類的診斷事件是不可以在INIT或者SPFILE的初始化參數(shù)文件中指定的。

?類別二：TraponError

這個類別的診斷事件是讓Oracle每次生成一個errorstack的錯誤信息的trace文件。

?類別三：Changeexecutionpath

這個類別的診斷事件主要是用于修改某些代碼段的可執(zhí)行路徑。例如，設置診斷事件10269就可以讓Oracle數(shù)據(jù)庫的后臺SMON進程不再進行自由空間的重組的操作。

?類別四：Tracesomething

這個類別的診斷事件主要是用于某種特殊的目的而需要獲取相應的trace信息，例如對sql調(diào)優(yōu)。最常見的診斷事件10046就是讓Oracle數(shù)據(jù)庫去跟蹤每條執(zhí)行的sql語句的訪問路徑。

每種類別的診斷事件都有一種或者多種級別，級別有以下四種表現(xiàn)形式：

?Range，例如從1到10

?bitmask例如0x010x020x040x080x10

?flag例如0代表off，1代表on

?identifier例如objectid,memoryaddress等等在設置使用各種診斷事件的時候，有一些事項是需要注意的：

?確定使用的診斷事件對于當前的Oracle數(shù)據(jù)庫版本是合法的：因為對于不同版本的Oracle數(shù)據(jù)庫來說，診斷事件的含義和用法都有所不同。

?確定使用的診斷事件允許設定的級別，在很多時候設定的級別不同是會影響到診斷事件所代表的行為的。

?在INITSID.ORA文件中設置的任何診斷事件，如果Oracle數(shù)據(jù)庫需要升級，一定要提前注釋或者取消。

大局部的診斷事件的數(shù)值都是在10000至10999范圍內(nèi)，使用如下的腳本可以查看到所有的診斷事件：

SETSERVEROUTPUTON

DECLARE

err_msgVARCHAR2(120);

BEGIN

dbms_output.enable(1000000);

FORerr_numIN10000..10999

LOOP

err_msg:=SQLERRM(-err_num);

IFerr_msgNOTLIKE'%Message'||err_num||'notfound%'THEN

dbms_output.put_line(err_msg);

ENDIF;

ENDLOOP;

END;

/

在UNIX系統(tǒng)中，可以在$ORACLE_HOME/rdbms/mesg/oraus.msg這個文件中找到所有的診斷事件的名稱和定義。使用如下腳本可以輸出所有的詳細的診斷事件的信息：

event=10000

while[$event-ne10999]

do

event=`expr$event+1`

oerrora$event

done使用如下腳本可以檢查當前會話中設置了哪些診斷事件：

SETSERVEROUTPUTON

DECLARE

l_levelNUMBER;

BEGIN

FORl_eventIN10000..10999

LOOP

dbms_system.read_ev(l_event,l_level);

IFl_level>0THEN

dbms_output.put_line('Event'||TO_CHAR(l_event)||

'issetatlevel'||TO_CHAR(l_level));

ENDIF;

ENDLOOP;

END;

/大局部的診斷事件的數(shù)值都是在10000至10999范圍內(nèi)，使用如下的腳本可以查看到所有的診斷事件：SETSERVEROUTPUTONDECLAREerr_msgVARCHAR2(120);BEGINdbms_output.enable(1000000);FORerr_numIN10000..10999LOOPerr_msg:=SQLERRM(-err_num);IFerr_msgNOTLIKE'%Message'||err_num||'notfound%'THENdbms_output.put_line(err_msg);ENDIF;ENDLOOP;END;/ORA-10000:controlevent,name'control_file'ORA-10001:controlevent1ORA-10002:controlevent2ORA-10003:controlevent3ORA-10004:blockrecoverytesting-internalerrorORA-10005:tracelatchoperationsfordebuggingORA-10006:blockrecoverytesting-externalerrorORA-10007:logswitchdebugcrashafternewlogselect,threadORA-10008:logswitchdebugcrashafternewlogheaderwrite,threadORA-10009:logswitchdebugcrashafteroldlogheaderwrite,threadORA-10010:BeginTransactionORA-10011:EndTransactionORA-10012:AbortTransactionORA-10013:InstanceRecoveryORA-10014:RollBacktoSavePointORA-10015:UndoSegmentRecoveryORA-10016:UndoSegmentextendORA-10017:UndoSegmentWrapORA-10018:DataSegmentCreateORA-10020:partiallinkrestoredtolinkedlist(KSG)ORA-10021:KSTeventtotracecontrolwritesandreadsORA-10022:tracektsgspORA-10023:CreateSaveUndoSegmentORA-10024:WritetoSaveUndoORA-10026:ApplySaveUndoORA-10027:SpecifyDeadlockTraceInformationtobeDumpedORA-10028:Dumptraceinformationduringlock/resourcelatchcleanupORA-10029:sessionlogon(KSU)ORA-10030:sessionlogoff(KSU)ORA-10031:sortdebugevent(S*)ORA-10032:sortstatistics(SOR*)ORA-10033:sortruninformation(SRD*/SRS*)ORA-10035:WriteparsefailurestoalertlogfileORA-10036:createremoterowsource(QKANET)ORA-10037:allocateremoterowsource(QKARWS)ORA-10038:dumprowsourcetree(QBADRV)ORA-10039:typechecking(OPITCA)ORA-10041:dumpundorecordsskippedORA-10043:checkconsistencyofowner/waiter/converterlistsinKSQORA-10044:freelistundooperationsORA-10045:freelistupdateoperations-ktsrsp,ktsunlORA-10046:enableSQLstatementtimingORA-10047:traceswitchingofsessionsORA-10048:UndosegmentshrinkORA-10049:protectlibrarycachememoryheapsORA-10050:snipertraceORA-10051:traceOPIcallsORA-10052:don'tcleanupobj$ORA-10053:CBOEnableoptimizertraceORA-10056:dumpanalyzestats(kdg)ORA-10057:suppressinerrormessagesORA-10058:usetablescancostintab$.spare1ORA-10059:simulateerrorinlogORA-10060:CBOEnablepredicatedumpORA-10061:disableSMONfromcleaningtempsegmentORA-10062:disableusageofOSRolesinosdsORA-10063:disableusageofDBAandOPERprivilegesinosdsORA-10064:threadenabledebugcrashlevel,threadORA-10065:limitlibrarycachedumpinformationforstateobjectdumpORA-10066:simulatefailuretoverifyfileORA-10067:forceredologchecksumerrors-blocknumberORA-10068:forceredologchecksumerrors-ORA-10070:forcedataerrors-blocknumberORA-10071:forcedataerrors-ORA-10072:protectlatchrecoverymemoryORA-10073:latchcleanuptracingORA-10074:defaulttracefunctionmaskforkstORA-10075:CBODisableouter-jointoregularjoinconversionORA-10076:CBOEnablecartesianproductjoincostingORA-10077:CBODisableview-mergingoptimizationforouter-joinsORA-10078:CBODisableconstantpredicateeliminationoptimizationORA-10079:tracedatasent/receivedviaSQL*NetORA-10080:dumpablockonasegmentlistwhichcannotbeexchangedORA-10081:segmentHighWaterMarkhasbeenadvancedORA-10082:freelistheadblockisthesameasthelastblockORA-10084:freelistbecomesemptyORA-10085:freelistshavebeenmergedORA-10086:CBOEnableerrorifkkoandqkadisagreeonobysortORA-10087:disablerepairofmediacorruptdatablocksORA-10088:CBODisablenewNOTINoptimizationORA-10089:CBODisableindexsortingORA-10090:invokeothereventsbeforecrashrecoveryORA-10091:CBODisableconstantpredicatemergingORA-10092:CBODisablehashjoinORA-10093:CBOEnableforcehashjoinsORA-10094:beforeresizingadatafileORA-10095:dumpdebuggercommandstotracefileORA-10096:afterthecrossinstancecallwhenresizingadatafileORA-10097:aftergeneratingredowhenresizingadatafileORA-10098:aftertheOShasincreasedthesizeofadatafileORA-10099:afterupdatingthewiththenewORA-10100:aftertheOShasdecreasedthesizeofadatafileORA-10102:switchoffanti-joinsORA-10103:CBODisablehashjoinsORA-10104:dumphashjoinstatisticstotracefileORA-10105:CBOEnableconstantpredtransandMPswWHERE-clauseORA-10106:CBODisableevaluatingcorrelationpredlastforNOTINORA-10107:CBOAlwaysusebitmapindexORA-10108:CBODon'tusebitmapindexORA-10109:CBODisablemoveofnegatedpredicatesORA-10110:CBOTryindexrowidrangescansORA-10111:BitmapindexcreationswitchORA-10112:BitmapindexcreationswitchORA-10113:BitmapindexcreationswitchORA-10114:BitmapindexcreationswitchORA-10115:CBOBitmapoptimizationusemaximalexpressionORA-10116:CBOBitmapoptimizationswitchORA-10117:CBODisablenewparallelcostmodelORA-10118:CBOEnablehashjoincostingORA-10119:QKADisableGBYsorteliminationORA-10120:generaterelativefile#differentfromabsoluteORA-10121:CBODon'tsortbitmapchainsORA-10122:Disabletransformationofcount(col)tocount(*)ORA-10124:ForcecreationofsegmentedarraysbykscsAllocateORA-10125:DisableremotesorteliminationORA-10126:DebugoraclejavaxaORA-10127:DisableremotequeryblockoperationORA-10128:DumpPartitionPruningInformationORA-10129:AlterhistogramlookupforremotequeriesORA-10130:sortdisablereadaheadsORA-10132:dumpplanaftercompilationORA-10133:testingforSQLMemoryManagementORA-10134:tracingforSQLMemoryManagementforsessionORA-10135:CBOdonotcount0rowspartitionsORA-10136:CBOturnofffixforbug1089848ORA-10137:CBOturnofffixforbug1344111ORA-10138:CBOturnofffixforbug1577003ORA-10139:CBOturnofffixforbug1386119ORA-10140:CBOturnofffixforbug1332980ORA-10141:CBOdisableadditionalkeysforinlistinbitmapoptimizationORA-10142:CBOturnoffadvancedOR-expansionchecksORA-10143:CBOturnoffhintsORA-10144:CBOturnoffcostbasedselectionofbjioverbsjsubqueryORA-10145:testauditingnetworkerrorsORA-10146:enableOracleTRACEcollectionORA-10147:enablejoinpushthroughUNIONviewORA-10149:allowthecreationofconstraintswithillegaldateconstantsORA-10150:importexceptionsORA-10152:CBOdon'tconsiderfunctioncostsinplansORA-10153:SwitchtousepublicsynonymifprivateonedoesnottranslateORA-10154:SwitchtodisallowsynonymsinDDLstatementsORA-10155:CBOdisablegenerationoftransitiveOR-chainsORA-10156:CBOdisableindexfastfullscanORA-10157:CBOdisableindexaccesspathforin-listORA-10158:CBOpreservepredicateorderinpost-filtersORA-10159:CBOdisableorder-bysortpushdownintodomainindexesORA-10160:CBOdisableuseofjoinindexORA-10161:CBOrecursivesemi-joinon/off-switchORA-10162:CBOjoin-backeliminationon/off-switchORA-10163:CBOjoin-backeliminationon/off-switchORA-10164:CBOdisablesubquery-adjustedcardinalityfixORA-10165:marksessiontobeabortedduringshutdownnormalORA-10166:tracelongoperationstatisticsupdatesORA-10167:CBOuseoldindexMIN/MAXoptimizationORA-10168:CBOdisablesingle-tablepredicatepredicategenerationORA-10169:CBOdisablehistogramsformultipartitionsORA-10170:CBOuseoldbitmapcostingORA-10171:CBOdisabletransitivejoinpredicatesORA-10172:CBOforcehashjoinbackORA-10173:DynamicSamplingtime-outerrorORA-10174:viewjoin-backeliminationswitchORA-10175:CBOstartransformationswitchORA-10176:CBOcolocatedjoinswitchORA-10177:CBOcolocatedjoinswitchORA-10178:CBOturnoffhashclusterfilteringthroughmemcmpORA-10179:CBOturnofftransitivepredicatereplacementORA-10180:temptabletransformationprinterrormessagesORA-10181:CBOdisablemulti-columnin-listprocessingORA-10182:CBOdisablegenerationofimpliedpredicatesORA-10183:CBOdisablecostroundingORA-10184:CBOdisableOR-expiflonginlistonbitmapcolumnORA-10185:CBOforceindexjoinsORA-10186:CBOdisableindexjoinORA-10187:CBOadditionalindexjoinswitchORA-10188:CBOadditionalindexjoinswitchORA-10189:CBOturnoffFFSnullfixORA-10190:AnalyzeuseoldfrequencyhistogramcollectionanddensityORA-10191:Avoidconversionofin-listsbacktoOR-expandedformORA-10192:nopushdownwhennumberofgroupsexceednumberofrowsORA-10193:ForcerepeatablesamplingwithspecifiedseedORA-10194:CBOdisablenewLIKEselectivityheuristicORA-10195:CBOdon'tusecheckconstraintsfortransitivepredicatesORA-10196:CBOdisableindexskipscanORA-10197:CBOforceindexskipscanORA-10199:setparameterinsessionORA-10200:consistentreadbufferstatusORA-10201:consistentreadundoapplicationORA-10202:consistentreadblockheaderORA-10203:blockcleanoutORA-10204:signalrecursiveextendORA-10205:rowcachedebuggingORA-10206:transactiontableconsistentreadORA-10207:consistentreadtransactions'statusreportORA-10208:consistentreadloopcheckORA-10209:enablesimulatederroroncontrolfileORA-10210:checkdatablockintegrityORA-10212:checkclusterintegrityORA-10213:crashaftercontrolORA-10214:simulatewriteerrorsoncontrolfileORA-10215:simulatereaderrorsoncontrolfileORA-10216:dumpcontrolORA-10217:debugsequencenumbersORA-10218:dumpubaofappliedundoORA-10219:monitormulti-passrowlockingORA-10220:showupdatestothetransactiontableORA-10221:showchangesdonewithundoORA-10222:rowcacheORA-10223:transactionlayer-turnonverificationcodesORA-10224:indexblocksplit/deletetraceORA-10225:free/usedextentrowcacheORA-10226:traceCRapplicationsofundofordataoperationsORA-10227:verify(multi-piece)rowstructureORA-10228:traceapplicationofredobykcocbkORA-10229:simulateI/OerroragainstdatafilesORA-10231:skipcorruptedblockson_table_scans_ORA-10232:dumpcorruptedblockssymbolicallywhenkcbgottenORA-10233:skipcorruptedblocksonindexoperationsORA-10234:triggereventaftercallingkcrapctodoredoNtimesORA-10235:checkmemorymanagerinternalstructuresORA-10236:dumpredoonobjectno.orblocktypemismatcherrors1410/8103ORA-10237:simulate^C(fortestingpurposes)ORA-10238:instantiationmanagerORA-10239:multi-instancelibrarycachemanagerORA-10240:dumpdba'sofblocksthatwewaitforORA-10241:remoteSQLexecutiontracing/validationORA-10242:suppressOER2063(fortestingdistribw/odifferenterrorlog)ORA-10243:simulatederrorfortestofK2GTABlatchcleanupORA-10244:maketranidsinerrormsgsprintas0.0.0(fortesting)ORA-10246:printtraceofPMONactionstotracefileORA-10247:Turnonscgcmntracing.(VMSONLY)ORA-10248:turnontracingfordispatchersORA-10249:turnontracingformulti-statedserversORA-10250:TraceallallocateandfreecallstothetopmostSGAheapORA-10251:checkconsistencyoftransactiontableandundoblockORA-10254:tracecross-instancecallsORA-10255:pl/sqlparsecheckingORA-10257:tracesharedserverloadbalancingORA-10258:forcesharedserverstobechosenround-robinORA-10259:geterrormessagetextfromremoteusingexplicitcallORA-10261:LimitthesizeofthePGAheapORA-10262:Don'tcheckformemoryleaksORA-10263:Don'tfreeemptyPGAheapextentsORA-10265:KeeprandomsystemgeneratedoutputoutoferrormessagesORA-10266:TraceOSDstackusageORA-10267:InhibitKSEDMPfortestingORA-10268:Don'tdoforwardcoalescewhendeletingextentsORA-10269:Don'tdocoalescesoffreespaceinSMONORA-10270:DebugsharedcursorsORA-10271:distributedtransactionafterCOLLECTORA-10272:distributedtransactionbeforePREPAREORA-10273:distributedtransactionafterPREPAREORA-10274:distributedtransactionbeforeCOMMITORA-10275:distributedtransactionafterCOMMITORA-10276:distributedtransactionbeforeFORGETORA-10277:Cursorsharing(ornot)relatedevent(usedfortesting)ORA-10278:InternaltestingORA-10279:Simulateblockcorruptioninkdb4chkORA-10280:Internaltesting-segmentationfaultduringcrashrecoveryORA-10281:maximumtimetowaitforprocesscreationORA-10282:InhibitsignallingofotherbackgroundswhenonediesORA-10284:simulatezero/infiniteasynchI/ObufferingORA-10285:SimulatecontrolcorruptionORA-10286:SimulatecontrolerrorORA-10287:SimulatearchivererrorORA-10288:DonotcheckblocktypeinktrgetORA-10289:DoblockdumpstotracehexratherthanfromattedORA-10290:kdnchk-checkvalidevent-notforgeneralpurposeuse.ORA-10291:dieintbsdrvtotestcontrolORA-10293:tracelogswitchmediarecoverycheckpointsORA-10295:dieafterupdatedurningcfxactORA-10296:disableORA-379ORA-10297:customizedictionaryobjectnumbercacheORA-10298:ksfdi/otracing