Oracle诊断事件列表

经常有人问，Oracle有哪些诊断事件，各是什么含义，怎样使用？

这些问题问得太多太多，Oracle没有过多的说明，实际上也不需要太多的说明。

我们可以通过以下代码查询得到Oracle的诊断事件及说明，通过这些，我想就足够了。列举在这里给自己参考。

1.代码

SET linesize 120SET feedback offSET SERVEROUTPUT ONDECLAREerr_msg VARCHAR2(120);BEGINdbms_output.enable (1000000);FOR err_num IN 10000..10999LOOPerr_msg := SQLERRM (-err_num);IF err_msg NOT LIKE '%Message '||err_num||' not found%' THENdbms_output.put_line (err_msg);END IF;END LOOP;END;

2.列表

ORA-10000: controlfile debug event, name 'control_file'ORA-10001: controlfile crash event1ORA-10002: controlfile crash event2ORA-10003: controlfile crash event3ORA-10004: controlfile crash event4ORA-10005: trace latch operations for debuggingORA-10006: testing - block recovery forcedORA-10007: log switch debug crash after new log select, thread ORA-10008: log switch debug crash after new log header write, thread ORA-10009: log switch debug crash after old log header write, thread ORA-10010: Begin TransactionORA-10011: End TransactionORA-10012: Abort TransactionORA-10013: Instance RecoveryORA-10014: Roll Back to Save PointORA-10015: Undo Segment RecoveryORA-10016: Undo Segment extendORA-10017: Undo Segment WrapORA-10018: Data Segment CreateORA-10019: Data Segment RecoveryORA-10020: partial link restored to linked list (KSG)ORA-10021: latch cleanup for state objects (KSS)ORA-10022: trace ktsgspORA-10023: Create Save Undo SegmentORA-10024: Write to Save UndoORA-10025: Extend Save Undo SegmentORA-10026: Apply Save UndoORA-10027: Specify Deadlock Trace Information to be DumpedORA-10028: Dump trace information during lock / resource latch cleanupORA-10029: session logon (KSU)ORA-10030: session logoff (KSU)ORA-10031: sort debug event (S*)ORA-10032: sort statistics (SOR*)ORA-10033: sort run information (SRD*/SRS*)ORA-10035: parse SQL statement (OPIPRS)ORA-10036: create remote row source (QKANET)ORA-10037: allocate remote row source (QKARWS)ORA-10038: dump row source tree (QBADRV)ORA-10039: type checking (OPITCA)ORA-10040: dirty cache listORA-10041: dump undo records skippedORA-10042: trap error during undo applicationORA-10043: check consistency of owner/waiter/converter lists in KSQORA-10044: free list undo operationsORA-10045: free list update operations - ktsrsp, ktsunlORA-10046: enable SQL statement timingORA-10047: trace switching of sessionsORA-10048: Undo segment shrinkORA-10049: protect library cache memory heapsORA-10050: sniper traceORA-10051: trace OPI callsORA-10052: don't clean up obj$ORA-10053: CBO Enable optimizer traceORA-10054: trace UNDO handling in MLSORA-10055: trace UNDO handingORA-10056: dump analyze stats (kdg)ORA-10057: suppress file names in error messagesORA-10058: use table scan cost in tab$.spare1ORA-10059: simulate error in logfile create/clearORA-10060: CBO Enable predicate dumpORA-10061: disable SMON from cleaning temp segmentORA-10062: disable usage of OS Roles in osdsORA-10063: disable usage of DBA and OPER privileges in osdsORA-10064: thread enable debug crash level , thread ORA-10065: limit library cache dump information for state object dumpORA-10066: simulate failure to verify fileORA-10067: force redo log checksum errors - block numberORA-10068: force redo log checksum errors - file numberORA-10069: Trusted Oracle test eventORA-10070: force datafile checksum errors - block numberORA-10071: force datafile checksum errors - file numberORA-10072: protect latch recovery memoryORA-10073: have PMON dump info before latch cleanupORA-10074: default trace function mask for kstORA-10075: CBO Disable outer-join to regular join conversionORA-10076: CBO Enable cartesian product join costingORA-10077: CBO Disable view-merging optimization for outer-joinsORA-10078: CBO Disable constant predicate elimination optimizationORA-10079: trace data sent/received via SQL*NetORA-10080: dump a block on a segment list which cannot be exchangedORA-10081: segment High Water Mark has been advancedORA-10082: free list head block is the same as the last blockORA-10083: a brand new block has been requested from space managementORA-10084: free list becomes emptyORA-10085: free lists have been mergedORA-10086: CBO Enable error if kko and qka disagree on oby sortORA-10087: disable repair of media corrupt data blocksORA-10088: CBO Disable new NOT IN optimizationORA-10089: CBO Disable index sortingORA-10090: invoke other events before crash recoveryORA-10091: CBO Disable constant predicate mergingORA-10092: CBO Disable hash joinORA-10093: CBO Enable force hash joinsORA-10094: before resizing a data fileORA-10095: dump debugger commands to trace fileORA-10096: after the cross instance call when resizing a data fileORA-10097: after generating redo when resizing a data fileORA-10098: after the OS has increased the size of a data fileORA-10099: after updating the file header with the new file sizeORA-10100: after the OS has decreased the size of a data fileORA-10101: atomic redo write recoveryORA-10102: switch off anti-joinsORA-10103: CBO Disable hash join swappingORA-10104: dump hash join statistics to trace fileORA-10105: CBO Enable constant pred trans and MPs w WHERE-clauseORA-10106: CBO Disable evaluating correlation pred last for NOT INORA-10107: CBO Always use bitmap indexORA-10108: CBO Don't use bitmap indexORA-10109: CBO Disable move of negated predicatesORA-10110: CBO Try index rowid range scansORA-10111: Bitmap index creation switchORA-10112: Bitmap index creation switchORA-10113: Bitmap index creation switchORA-10114: Bitmap index creation switchORA-10115: CBO Bitmap optimization use maximal expressionORA-10116: CBO Bitmap optimization switchORA-10117: CBO Disable new parallel cost model ORA-10118: CBO Enable hash join costing ORA-10119: QKA Disable GBY sort eliminationORA-10120: generate relative file # different from absoluteORA-10121: CBO Don't sort bitmap chainsORA-10122: Disable transformation of count(col) to count(*)ORA-10123: QKA Disable Bitmap And-EQualsORA-10124: Force creation of segmented arrays by kscsAllocateORA-10125: Disable remote sort eliminationORA-10126: Debug oracle java xaORA-10127: Disable remote query block operationORA-10128: Dump Partition Pruning InformationORA-10129: Alter histogram lookup for remote queriesORA-10130: sort disable readaheadsORA-10131: use v$sql_plan code path for explain planORA-10132: dump plan after compilationORA-10133: testing for SQL Memory ManagementORA-10134: tracing for SQL Memory Management for sessionORA-10135: CBO do not count 0 rows partitionsORA-10136: CBO turn off fix for bug 1089848ORA-10137: CBO turn off fix for bug 1344111ORA-10138: CBO turn off fix for bug 1577003ORA-10139: CBO turn off fix for bug 1386119ORA-10140: CBO turn off fix for bug 1332980ORA-10141: CBO disable additional keys for inlist in bitmap optimizationORA-10142: CBO turn off advanced OR-expansion checksORA-10143: CBO turn off hintsORA-10144: CBO turn off cost based selection of bji over bsj subqueryORA-10145: test auditing network errorsORA-10146: enable Oracle TRACE collectionORA-10147: enable join push through UNION viewORA-10148: Use pre-7.3.3 random generatorORA-10149: allow the creation of constraints with illegal date constantsORA-10150: import exceptionsORA-10151: Force duplicate dependency removalORA-10152: CBO don't consider function costs in plansORA-10153: Switch to use public synonym if private one does not translateORA-10154: Switch to disallow synonyms in DDL statementsORA-10155: CBO disable generation of transitive OR-chainsORA-10156: CBO disable index fast full scanORA-10157: CBO disable index access path for in-listORA-10158: CBO preserve predicate order in post-filtersORA-10159: CBO disable order-by sort pushdown into domain indexesORA-10160: CBO disable use of join indexORA-10161: CBO recursive semi-join on/off-switchORA-10162: CBO join-back elimination on/off-switchORA-10163: CBO join-back elimination on/off-switchORA-10164: CBO disable subquery-adjusted cardinality fixORA-10165: mark session to be aborted during shutdown normalORA-10166: trace long operation statistics updatesORA-10167: CBO use old index MIN/MAX optimizationORA-10168: CBO disable single-table predicate predicate generationORA-10169: CBO disable histograms for multi partitionsORA-10170: CBO use old bitmap costingORA-10171: CBO disable transitive join predicatesORA-10172: CBO force hash join backORA-10173: CBO no constraint-based join-back eliminationORA-10174: view join-back elimination switchORA-10175: CBO star transformation switchORA-10176: CBO colocated join switchORA-10177: CBO colocated join switchORA-10178: CBO turn off hash cluster filtering through memcmpORA-10179: CBO turn off transitive predicate replacementORA-10180: temp table transformation print error messagesORA-10181: CBO disable multi-column in-list processingORA-10182: CBO disable generation of implied predicatesORA-10183: CBO disable cost roundingORA-10184: CBO disable OR-exp if long inlist on bitmap columnORA-10185: CBO force index joinsORA-10186: CBO disable index joinORA-10187: CBO additional index join switchORA-10188: CBO additional index join switchORA-10189: CBO turn off FFS null fixORA-10190: Analyze use old frequency histogram collection and densityORA-10191: Avoid conversion of in-lists back to OR-expanded formORA-10192: nopushdown when number of groups exceed number of rowsORA-10193: Force repeatable sampling with specified seedORA-10194: CBO disable new LIKE selectivity heuristicORA-10195: CBO don't use check constraints for transitive predicatesORA-10196: CBO disable index skip scanORA-10197: CBO force index skip scanORA-10198: check undo recordORA-10199: set parameter in sessionORA-10200: consistent read buffer statusORA-10201: consistent read undo applicationORA-10202: consistent read block headerORA-10203: block cleanoutORA-10204: signal recursive extendORA-10205: row cache debuggingORA-10206: transaction table consistent readORA-10207: consistent read transactions' status reportORA-10208: consistent read loop checkORA-10209: enable simulated error on controlfileORA-10210: check data block integrityORA-10211: check index block integrityORA-10212: check cluster integrityORA-10213: crash after controlfile writeORA-10214: simulate write errors on controlfileORA-10215: simulate read errors on controlfileORA-10216: dump controlfile headerORA-10217: debug sequence numbersORA-10218: dump uba of applied undoORA-10219: monitor multi-pass row lockingORA-10220: show updates to the transaction tableORA-10221: show changes done with undoORA-10222: row cacheORA-10223: transaction layer - turn on verification codesORA-10224: index block split/delete traceORA-10225: free/used extent row cacheORA-10226: trace CR applications of undo for data operationsORA-10227: verify (multi-piece) row structureORA-10228: trace application of redo by kcocbkORA-10229: simulate I/O error against datafilesORA-10230: check redo generation by copying before applyingORA-10231: skip corrupted blocks on _table_scans_ORA-10232: dump corrupted blocks symbolically when kcbgottenORA-10233: skip corrupted blocks on index operationsORA-10234: trigger event after calling kcrapc to do redo N timesORA-10235: check memory manager internal structuresORA-10236: library cache managerORA-10237: simulate ^C (for testing purposes)ORA-10238: instantiation managerORA-10239: multi-instance library cache managerORA-10240: dump dba's of blocks that we wait forORA-10241: remote SQL execution tracing/validationORA-10242: suppress OER 2063 (for testing distrib w/o different error log)ORA-10243: simulated error for test of K2GTAB latch cleanupORA-10244: make tranids in error msgs print as 0.0.0 (for testing)ORA-10245: simulate lock conflict error for testing PMONORA-10246: print trace of PMON actions to trace fileORA-10247: Turn on scgcmn tracing. (VMS ONLY)ORA-10248: turn on tracing for dispatchersORA-10249: turn on tracing for multi-stated serversORA-10250: Trace all allocate and free calls to the topmost SGA heapORA-10251: check consistency of transaction table and undo blockORA-10252: simulate write error to data file headerORA-10253: simulate write error to redo logORA-10254: trace cross-instance callsORA-10255: pl/sql parse checkingORA-10256: turn off shared server load balancingORA-10257: trace shared server load balancingORA-10258: force shared servers to be chosen round-robinORA-10259: get error message text from remote using explicit callORA-10260: Trace calls to SMPRSET (VMS ONLY)ORA-10261: Limit the size of the PGA heapORA-10262: Don't check for memory leaksORA-10263: Don't free empty PGA heap extentsORA-10264: Collect statistics on context area usage (x$ksmcx)ORA-10265: Keep random system generated output out of error messagesORA-10266: Trace OSD stack usageORA-10267: Inhibit KSEDMP for testingORA-10268: Don't do forward coalesce when deleting extentsORA-10269: Don't do coalesces of free space in SMONORA-10270: Debug shared cursorsORA-10271: distributed transaction after COLLECTORA-10272: distributed transaction before PREPAREORA-10273: distributed transaction after PREPAREORA-10274: distributed transaction before COMMITORA-10275: distributed transaction after COMMITORA-10276: distributed transaction before FORGETORA-10277: Cursor sharing (or not) related event (used for testing)ORA-10278: Internal testingORA-10279: Simulate block corruption in kdb4chkORA-10280: Internal testing - segmentation fault during crash recoveryORA-10281: maximum time to wait for process creationORA-10282: Inhibit signalling of other backgrounds when one diesORA-10283: simulate asynch I/O never completingORA-10284: simulate zero/infinite asynch I/O bufferingORA-10285: Simulate controlfile header corruptionORA-10286: Simulate controlfile open errorORA-10287: Simulate archiver errorORA-10288: Do not check block type in ktrgetORA-10289: Do block dumps to trace file in hex rather than fromattedORA-10290: kdnchk - checkvalid event - not for general purpose use.ORA-10291: die in tbsdrv to test controlfile undoORA-10292: dump uet entries on a 1561 from dtsdrvORA-10293: dump debugging information when doing block recoveryORA-10294: enable PERSISTENT DLM operations on non-compliant systemsORA-10295: die after file header update durning cf xactORA-10296: disable ORA-379ORA-10297: customize dictionary object number cacheORA-10298: ksfd i/o tracingORA-10299: Trace prefetch tracking decisions made by CKPTORA-10300: disable undo compatibility check at database openORA-10301: Enable LCK timeout table consistency checkORA-10302: trace create or drop internal triggerORA-10303: trace loading of library cache for internal triggersORA-10304: trace replication triggerORA-10305: trace updatable materialized view triggerORA-10306: trace materialized view log triggerORA-10307: trace RepCat executionORA-10308: replication testing eventORA-10309: Trigger Debug eventORA-10310: trace synchronous change table triggerORA-10311: Disable Flashback Table Timestamp checkingORA-10312: Allow disable to log rows into the mapping tableORA-10313: Allow Row CR operations for single instanceORA-10314: Enable extra stats gathering for CRORA-10316: Events for extensible txn header, non zero ext header sizeORA-10317: Events for extensible txn header, zero ext header sizeORA-10318: Trace extensible txn header movementsORA-10319: Trace PGA statistics maintenanceORA-10320: Enable data layer (kdtgrs) tracing of space management callsORA-10321: Datafile header verification debug failure.ORA-10322: CBO don't simplify inlist predicatesORA-10323: before committing an add datafile commandORA-10324: Enable better checking of redo logs errorsORA-10325: Trace control file record section expand and shrink operationsORA-10326: clear logfile debug crash at , log ORA-10327: simulate ORA-00235 error for testingORA-10328: disable first-to-mount split-brain error, for testingORA-10329: simulate lost write, test detection by two-pass recoveryORA-10330: clear MTTR statistics in checkpoint progress recordORA-10331: simulate resilvering during recoveryORA-10332: force ALTER SYSTEM QUIESCE RESTRICTED command to failORA-10333: dump MTTR statistics each time it is updatedORA-10334: force FG to wait to be killed during MTTR advisory simulationORA-10336: Do remote object transfer using remote SQLORA-10337: enable padding owner name in slave sqlORA-10338: CBO don't use inlist iterator with function-based indexesORA-10339: CBO disable DECODE simplificationORA-10340: Buffer queues sanity check for corrupted buffersORA-10341: Simulate out of PGA memory in DBWR during object reuseORA-10342: Raise unknown exception in ACQ_ADD when checkpointingORA-10343: Raise an out of memory exception-OER 4031 in ACQ_ADDORA-10344: Simulate kghxal returning 0 in ACQ_ADD but no exceptionORA-10345: validate queue when linking or unlinking a bufferORA-10346: check that all buffers for checkpoint have been writtenORA-10347: dump active checkpoint entries and checkpoint buffersORA-10348: test abnormal termination of process initiating file checkpointORA-10349: do not allow ckpt to completeORA-10350: Simulate more than one object & tsn id in object reuseORA-10351: size of slotsORA-10352: report direct path statisticsORA-10353: number of slotsORA-10354: turn on direct read path for parallel queryORA-10355: turn on direct read path for scansORA-10356: turn on hint usage for direct readORA-10357: turn on debug information for direct pathORA-10358: Simulate out of PGA memory in cache advisory resetORA-10359: turn off updates to control file for direct writesORA-10360: enable dbwr consistency checkingORA-10365: turn on debug information for adaptive direct readsORA-10370: parallel query server kill eventORA-10371: disable TQ hintORA-10372: parallel query server kill event procORA-10373: parallel query server kill eventORA-10374: parallel query server interrupt (validate lock value)ORA-10375: turn on checks for statistics rollupsORA-10376: turn on table queue statisticsORA-10377: turn off load balancingORA-10378: force hard process/range affinityORA-10379: direct read for rowid range scans (unimplemented)ORA-10380: kxfp latch cleanup testing eventORA-10381: kxfp latch cleanup testing eventORA-10382: parallel query server interrupt (reset)ORA-10383: auto parallelization testing eventORA-10384: parallel dataflow scheduler tracingORA-10385: parallel table scan range sampling methodORA-10386: parallel SQL hash and range statisticsORA-10387: parallel query server interrupt (normal)ORA-10388: parallel query server interrupt (failure)ORA-10389: parallel query server interrupt (cleanup)ORA-10390: Trace parallel query slave executionORA-10391: trace PX granule allocation/assignmentORA-10392: parallel query debugging bitsORA-10393: print parallel query statisticsORA-10394: generate a fake load to test adaptive and load balancingORA-10395: adjust sample size for range table queuesORA-10396: circumvent range table queues for queriesORA-10397: suppress verbose parallel coordinator error reportingORA-10398: enable timeouts in parallel query threadsORA-10399: trace buffer allocationORA-10400: turn on system state dumps for shutdown debuggingORA-10401: turn on IPC (ksxp) debuggingORA-10402: turn on IPC (skgxp) debuggingORA-10403: fake CPU number for default degree of parallelismORA-10404: crash dbwr after writeORA-10405: emulate broken mirrorsORA-10406: enable datetime TIMESTAMP, INTERVAL datatype creationORA-10407: enable datetime TIME datatype creationORA-10408: disable OLAP builtin window function usageORA-10409: enable granule memset and block invalidation at startupORA-10410: trigger simulated communications errors in KSXPORA-10411: simulate errors in IMRORA-10412: trigger simulated errors in CGS/CM interfaceORA-10413: force simulated error for testing purposesORA-10414: simulated error from event level ORA-10425: enable global enqueue service open event traceORA-10426: enable global enqueue service convert event traceORA-10427: enable global enqueue service traffic controller event traceORA-10428: enable tracing of global enqueue service distributed resourceORA-10429: enable tracing of global enqueue service IPC callsORA-10430: enable tracing of global enqueue service AST callsORA-10431: enable verification messages on pi consistencyORA-10432: enable tracing of global cache service fusion callsORA-10433: global enqueue service testing eventORA-10434: enable tracing of global enqueue service multiple LMSORA-10435: enable tracing of global enqueue service deadlock detetctionORA-10436: enable global cache service duplicate ping checkingORA-10437: enable trace of global enqueue service S optimized resourcesORA-10442: enable trace of kst for ORA-01555 diagnosticsORA-10450: signal ctrl-c in kdddca (drop column) after n rowsORA-10496: Turn off fix for bug 2554178ORA-10498: Trim blank characters including contol charactersORA-10499: revert to old scale behaviourORA-10500: turn on traces for SMONORA-10501: periodically check selected heapORA-10502: CBO disable the fix for bug 2098120ORA-10503: enable user-specified graduated bind lengthsORA-10504: CBO disable the fix for bug 2607029ORA-10510: turn off SMON check to offline pending offline rollback segmentORA-10511: turn off SMON check to cleanup undo dictionaryORA-10512: turn off SMON check to shrink rollback segmentsORA-10513: turn off wrap source compressionORA-10515: turn on event to use physical cleanoutORA-10520: recreate package/procedure/view only if definition has changedORA-10550: signal error during create as select/create index after n rowsORA-10560: block type ''ORA-10561: block type '', data object# ORA-10562: Error occurred while applying redo to data block (file# , block# )ORA-10563: Test recovery had to corrupt data block (file# , block# ) in order to proceedORA-10564: tablespace ORA-10565: Another test recovery session is activeORA-10566: Test recovery has used all the memory it can useORA-10567: Redo is inconsistent with data block (file# , block# )ORA-10568: Failed to allocate recovery state object: out of SGA memoryORA-10570: Test recovery completeORA-10571: Test recovery canceledORA-10572: Test recovery canceled due to errorsORA-10573: Test recovery tested redo from change to ORA-10574: Test recovery did not corrupt any data blockORA-10575: Give up restoring recovered datafiles to consistent state: out of memoryORA-10576: Give up restoring recovered datafiles to consistent state: some error occurredORA-10577: Can not invoke test recovery for managed standby database recoveryORA-10578: Can not allow corruption for managed standby database recoveryORA-10579: Can not modify control file during test recoveryORA-10580: Can not modify datafile header during test recoveryORA-10581: Can not modify redo log header during test recoveryORA-10582: The control file is not a backup control fileORA-10583: Can not recovery file renamed as missing during test recoveryORA-10584: Can not invoke parallel recovery for test recoveryORA-10585: Test recovery can not apply redo that may modify control fileORA-10586: Test recovery had to corrupt 1 data block in order to proceedORA-10587: Invalid count for ALLOW n CORRUPTION optionORA-10588: Can only allow 1 corruption for normal media/standby recoveryORA-10589: Test recovery had to corrupt data blocks in order to proceedORA-10590: kga (argus debugger) test flagsORA-10591: kga (argus debugger) test flagsORA-10592: kga (argus debugger) test flagsORA-10593: kga (argus debugger) test flagsORA-10594: kga (argus debugger) test flagsORA-10595: kga (argus debugger) test flagsORA-10596: kga (argus debugger) test flagsORA-10597: kga (argus debugger) test flagsORA-10598: kga (argus debugger) test flagsORA-10599: kga (argus debugger) test flagsORA-10600: check cursor frame allocationORA-10601: turn on debugging for cursor_sharing (literal replacement)ORA-10602: cause an access violation (for testing purposes)ORA-10603: cause an error to occur during truncate (for testing purposes)ORA-10604: trace parallel create indexORA-10605: enable parallel create index by defaultORA-10606: trace parallel create indexORA-10607: trace index rowid partition scanORA-10608: trace create bitmap indexORA-10609: trace for array index insertionORA-10610: trace create index pseudo optimizerORA-10611: causes migration to fail - testing onlyORA-10612: prints debug information for auto-space managed segmentsORA-10613: prints debug information for auto-space managed segmentsORA-10614: Operation not allowed on this segmentORA-10615: Invalid tablespace type for temporary tablespaceORA-10616: Operation not allowed on this tablespaceORA-10617: Cannot create rollback segment in dictionary managed tablespaceORA-10618: Operation not allowed on this segmentORA-10619: Avoid assertions when possibleORA-10620: Operation not allowed on this segmentORA-10621: data block does not belong to the segmentORA-10622: test/trace online index (re)buildORA-10623: Enable Index range scan Prefetch - testing onlyORA-10624: Disable UJV invalidation on drop indexORA-10625: Turn off redo log dump for the index when OERI 12700ORA-10627: Dump the content of the index leaf blockORA-10628: Turn on sanity check for kdiss index skip scan stateORA-10640: Operation not permitted during SYSTEM tablespace migrationORA-10641: Cannot find a rollback segment to bind toORA-10642: Found rollback segments in dictionary managed tablespacesORA-10643: Database should be mounted in restricted mode and Exclusive modeORA-10644: SYSTEM tablespace cannot be default temporary tablespaceORA-10645: Recursive Extension in SYSTEM tablespace during migrationORA-10646: Too many recursive extensions during SYSTEM tablespace migrationORA-10647: Tablespace other than SYSTEM,, not found in read only modeORA-10650: disable cache-callback optimisationORA-10651: incorrect file number block number specifiedORA-10666: Do not get database enqueue nameORA-10667: Cause sppst to check for valid process idsORA-10690: Set shadow process core file dump type (Unix only)ORA-10691: Set background process core file type (Unix only)ORA-10700: Alter access violation exception handlerORA-10701: Dump direct loader index keysORA-10702: Enable histogram data generationORA-10703: Simulate process death during enqueue getORA-10704: Print out information about what enqueues are being obtainedORA-10705: Print Out Tracing information for every I/O done by ODSsORA-10706: Print out information about global enqueue manipulationORA-10707: Simulate process death for instance registrationORA-10708: print out trace information from the RAC buffer cacheORA-10709: enable parallel instances in create index by defaultORA-10710: trace bitmap index accessORA-10711: trace bitmap index mergeORA-10712: trace bitmap index orORA-10713: trace bitmap index andORA-10714: trace bitmap index minusORA-10715: trace bitmap index conversion to rowidsORA-10716: trace bitmap index compress/decompressORA-10717: trace bitmap index compaction trace for index creationORA-10718: event to disable automatic compaction after index creationORA-10719: trace bitmap index dmlORA-10720: trace db schedulingORA-10721: Internal testing - temp table transformationORA-10722: set parameters for CPU frequency calculation (debug)ORA-10723: Internal testing - release buffer for buffer cache shrinkORA-10724: trace cross-instance broadcastORA-10730: trace row level security policy predicatesORA-10731: dump SQL for CURSOR expressionsORA-10740: disables fix for bug 598861ORA-10750: test rollback segment blksize guessing for index array insertORA-10800: disable Smart Disk scanORA-10801: enable Smart Disk traceORA-10802: reserved for Smart DiskORA-10803: write timing statistics on cluster database recovery scanORA-10804: reserved for ksxbORA-10806: Switch to 7.3 mode when detaching sessionsORA-10807: Disable user id check when switching to a global transactionORA-10810: Trace snapshot too oldORA-10811: Trace block cleanoutsORA-10812: Trace Consistent ReadsORA-10826: enable upgrade/downgrade error message traceORA-10827: database must be opened with MIGRATE optionORA-10830: Trace group by sort row sourceORA-10831: Trace group by rollup row sourceORA-10841: Default un-inintialized charact set form to SQLCS_IMPLICITORA-10842: Event for OCI Tracing and Statistics InfoORA-10850: Enable time manager tracingORA-10851: Allow Drop command to drop queue tablesORA-10852: Enable tracing for Enqueue Dequeue OperationsORA-10853: event for AQ statistics latch cleanup testingORA-10856: Disable AQ propagator from using streamingORA-10857: Force AQ propagator to use two-phase commitORA-10858: Crash the AQ propagator at different stages of commitORA-10859: Disable updates of message retry countORA-10860: event for AQ admin disable new name parserORA-10861: disable storing extended message propertiesORA-10862: resolve default queue owner to current user in enqueue/dequeueORA-10871: dump file open/close timestamp during media recoveryORA-10900: extent manager fault insertion event #ORA-10902: disable seghdr conversion for ro operationORA-10903: Force tablespaces to become locally managedORA-10904: Allow locally managed tablespaces to have user allocationORA-10905: Do cache verification (kcbcxx) on extent allocationORA-10906: Unable to extend segment after insert direct loadORA-10907: Trace extent management eventsORA-10908: Trace temp tablespace eventsORA-10909: Trace free list eventsORA-10910: inject corner case events into the RAC buffer cacheORA-10911: Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle SupportORA-10912: Used to perform admin operations on locally managed SYSTEM tablespaceORA-10913: Create locally managed database if compatible > 920 by defaultORA-10924: import storage parse error ignore eventORA-10925: trace name context foreverORA-10926: trace name context foreverORA-10927: trace name context foreverORA-10928: trace name context foreverORA-10929: trace name context foreverORA-10930: trace name context foreverORA-10931: trace name context foreverORA-10932: trace name context foreverORA-10933: trace name context foreverORA-10934: Reserved. Used only in version 7.x.ORA-10935: Reserved. Used only in version 7.x.ORA-10936: trace name context foreverORA-10937: trace name context foreverORA-10938: trace name context foreverORA-10939: trace name context foreverORA-10940: trace name context foreverORA-10941: trace name context foreverORA-10943: trace name context foreverORA-10944: trace name context foreverORA-10945: trace name context foreverORA-10970: backout event for bug 2133357ORA-10975: trace execution of parallel propagationORA-10976: internal package related tracingORA-10977: trace event for RepAPIORA-10979: trace flags for join index implementationORA-10980: prevent sharing of parsed query during Materialized View query generationORA-10981: dscn computation-related event in replicationORA-10982: event to turn off CDC-format MV LogsORA-10983: event to enable Create_Change_Table debuggingORA-10984: subquery materialized view-related eventORA-10985: event for NULL refresh of materialized viewsORA-10986: donot use HASH_AJ in refreshORA-10987: event for the support of caching table with object featureORA-10988: event to get exclusive lock during materialized view refresh in IASORA-10989: event to internally create statistics MVORA-10996: event to make a process hold a latch in ksuORA-10999: do not get database enqueue name

3.Oracle本身提供的帮助也包含这部分信息:

$ORACLE_HOME/rdbms/mesg/oraus.msg

从10000 至 10999，包含所有公布的和未公布的事件

这个文件不包含在windows发布中，你可以在这里下载: oraus.msg