60 | deadlock detected while waiting for resource | Alias for 60 is deadlock |
4063 | | Found in execcr.sql |
10000 | control file debug event, name 'control_file' | |
10001 | control file crash event1 | |
10002 | control file crash event2 | |
10003 | control file crash event3 | |
10004 | block recovery testing - internal error | |
10005 | trace latch operations for debugging | |
10006 | block recovery testing - external error | |
10007 | log switch debug crash after new log select, thread | |
10008 | log switch debug crash after new log header write, thread | |
10009 | log switch debug crash after old log header write, thread | |
10010 | Begin Transaction | |
10011 | End Transaction | |
10012 | Abort Transaction | |
10013 | Instance Recovery | |
10014 | Roll Back to Save Point | |
10015 | Undo Segment Recovery | |
10016 | Undo Segment extend | |
10017 | Undo Segment Wrap | |
10018 | Data Segment Create | |
10019 | Turn off data/space search cache | |
10020 | partial link restored to linked list (KSG) | |
10021 | KST event to trace control file header writes and reads | |
10022 | trace ktsgsp | |
10023 | Create Save Undo Segment | |
10024 | Write to Save Undo | |
10025 | Simulate block recovery errors | |
10026 | Apply Save Undo | |
10027 | Specify Deadlock Trace Information to be Dumped | |
10028 | Dump trace information during lock / resource latch cleanup | |
10029 | session logon (KSU) | |
10030 | session logoff (KSU) | |
10031 | sort debug event (S*) | |
10032 | sort statistics (SOR*) | Alias for 10032 is sort_end |
10033 | sort run information (SRD*/SRS*) | Alias for 10033 is sort_run |
10034 | access path analysis (APA*) | |
10035 | Write parse failures to alert log file | Alias for 10035 is parse_sql_statement |
10036 | create remote row source (QKANET) | |
10037 | allocate remote row source (QKARWS) | |
10038 | dump row source tree (QBADRV) | |
10039 | type checking (OPITCA) | |
10040 | disable result-cache | |
10041 | dump undo records skipped | |
10042 | file header reads return youngest mirror | |
10043 | check consistency of owner/waiter/converter lists in KSQ | |
10044 | free list undo operations | |
10045 | free list update operations - ktsrsp, ktsunl | |
10046 | enable SQL statement timing | Aka sql_trace , trace files can be analyzed with tkprof or trca. For parameters see oradebug doc event name sql_trace . See also row source statistics |
10047 | trace switching of sessions | |
10048 | Undo segment shrink | |
10049 | protect library cache memory heaps | |
10050 | sniper trace | |
10051 | trace OPI calls | |
10052 | don't clean up obj$ | |
10053 | CBO Enable optimizer trace | Document the considarations made and decisions taken by the optimizer. Compare with dbms_sqldiag.dump_trace which also produces a 10053 trace, but does not execute the SQL statement. Compare with alter session set events 'trace[rdbms.SQL_Optimizer.*][sql:…] . |
10054 | CBO Enable optimizer trace for recursive statement (RPI) | |
10055 | Rowsets: turn off rowsets for various operations | See rowset in column projection of plan_table |
10056 | dump analyze stats (kdg) | |
10057 | suppress file names in error messages | |
10058 | use table scan cost in tab$.spare1 | |
10059 | simulate error in logfile create/clear | |
10060 | CBO Enable predicate dump | See Julian Dyke |
10061 | disable SMON from cleaning temp segment | Set to level 10, see also MOS Note 33567.1. Compare with event 10269. |
10062 | disable usage of OS Roles in osds | |
10063 | disable usage of DBA and OPER privileges in osds | |
10064 | thread enable debug crash level , thread | |
10065 | limit library cache dump information for state object dump | |
10066 | simulate failure to verify file | |
10067 | force redo log checksum errors - block number | |
10068 | force redo log checksum errors - file number | |
10069 | Flashback images for offline file are lost | |
10070 | force datafile checksum errors - block number | |
10071 | force datafile checksum errors - file number | |
10072 | local tempspace tracing - recovery layer | |
10073 | latch cleanup tracing | |
10074 | default trace function mask for kst | |
10075 | CBO Disable outer-join to regular join conversion | |
10076 | CBO Enable cartesian product join costing | |
10077 | CBO Disable view-merging optimization for outer-joins | |
10078 | CBO Disable constant predicate elimination optimization | |
10079 | trace data sent/received via SQL*Net | set level to 2 for more details. |
10080 | dump a block on a segment list which cannot be exchanged | |
10081 | segment High Water Mark has been advanced | |
10082 | free list head block is the same as the last block | |
10083 | Trace IMCDT in LIMITED mode | |
10084 | free list becomes empty | |
10085 | free lists have been merged | |
10086 | CBO Enable error if kko and qka disagree on oby sort | |
10087 | disable repair of media corrupt data blocks | |
10088 | CBO Disable new NOT IN optimization | |
10089 | CBO Disable index sorting | |
10090 | invoke other events before crash recovery | |
10091 | CBO Disable constant predicate merging | |
10092 | CBO Disable hash join | |
10093 | CBO Enable force hash joins | |
10094 | before resizing a data file | |
10095 | dump debugger commands to trace file | |
10096 | after the cross instance call when resizing a data file | |
10097 | after generating redo when resizing a data file | |
10098 | after the OS has increased the size of a data file | |
10099 | after updating the file header with the new file size | |
10100 | after the OS has decreased the size of a data file | |
10101 | DBWR refresh fails on cross instance resize call | |
10102 | switch off anti-joins | |
10103 | CBO Disable hash join swapping | |
10104 | dump hash join statistics to trace file | lvl = 1 … 10, 10 dumping the most detailed information |
10105 | CBO Enable constant pred trans and MPs w WHERE-clause | |
10106 | CBO Disable evaluating correlation pred last for NOT IN | |
10107 | CBO Always use bitmap index | |
10108 | CBO Don't use bitmap index | |
10109 | CBO Disable move of negated predicates | |
10110 | CBO Try index rowid range scans | |
10111 | Bitmap index creation switch | Named enable tiny index improvements: consider small indexes as cachhe in v$system_fix_control |
10112 | Bitmap index creation switch | |
10113 | Bitmap index creation switch | |
10114 | Bitmap index creation switch | |
10115 | CBO Bitmap optimization use maximal expression | |
10116 | CBO Bitmap optimization switch | |
10117 | CBO Disable new parallel cost model | |
10118 | CBO Enable hash join costing | |
10119 | QKA Disable GBY sort elimination | |
10120 | generate relative file # different from absolute | |
10121 | CBO Don't sort bitmap chains | |
10122 | Disable transformation of count(col) to count(*) | |
10123 | Rowsets: turn off rowsets for various operations | See rowset in column projection of plan_table |
10124 | Force creation of segmented arrays by kscsAllocate | |
10125 | Disable remote sort elimination | |
10126 | Debug oracle java xa | |
10127 | Disable remote query block operation | |
10128 | Dump Partition Pruning Information | |
10129 | Alter histogram lookup for remote queries | |
10130 | sort disable readaheads | |
10131 | CONNECT BY debug event | |
10132 | dump plan after compilation | |
10133 | testing for SQL Memory Management | |
10134 | tracing for SQL Memory Management for session | |
10135 | CBO do not count 0 rows partitions | See also v$system_fix_control |
10136 | CBO turn off fix for bug 1089848 | |
10137 | CBO turn off fix for bug 1344111 | |
10138 | CBO turn off fix for bug 1577003 | |
10139 | CBO turn off fix for bug 1386119 | |
10140 | CBO turn off fix for bug 1332980 | |
10141 | CBO disable additional keys for inlist in bitmap optimization | |
10142 | CBO turn off advanced OR-expansion checks | |
10143 | CBO turn off hints | |
10144 | CBO turn off cost based selection of bji over bsj subquery | |
10145 | test auditing network errors | |
10146 | enable Oracle TRACE collection | |
10147 | enable join push through UNION view | |
10148 | Quarantine trace event | |
10149 | allow the creation of constraints with illegal date constants (for example col_xyz > '10-MAY-81' ) | Found in utlconst.sql , see also ORA-02436: date or system variable wrongly specified in CHECK constraint. |
10150 | import exceptions | |
10152 | CBO don't consider function costs in plans | |
10153 | Switch to use public synonym if private one does not translate | |
10154 | Switch to disallow synonyms in DDL statements | |
10155 | CBO disable generation of transitive OR-chains | |
10156 | CBO disable index fast full scan | |
10157 | CBO disable index access path for in-list | |
10158 | CBO preserve predicate order in post-filters | |
10159 | CBO disable order-by sort pushdown into domain indexes | |
10160 | CBO disable use of join index | |
10161 | CBO recursive semi-join on/off-switch | |
10162 | CBO join-back elimination on/off-switch | |
10163 | CBO join-back elimination on/off-switch | |
10164 | CBO disable subquery-adjusted cardinality fix | |
10165 | mark session for special handling during instance administration | |
10166 | trace long operation statistics updates | |
10167 | CBO use old index MIN/MAX optimization | |
10168 | CBO disable single-table predicate predicate generation | |
10169 | CBO disable histograms for multi partitions | |
10170 | CBO use old bitmap costing | |
10171 | CBO disable transitive join predicates | |
10172 | CBO force hash join back | |
10173 | Dynamic Sampling time-out error | |
10174 | view join-back elimination switch | |
10175 | CBO star transformation switch | |
10176 | CBO colocated join switch | |
10177 | CBO colocated join switch | |
10178 | CBO turn off hash cluster filtering through memcmp | |
10179 | CBO turn off transitive predicate replacement | |
10180 | temp table transformation print error messages | Compare with the TEMP TABLE TRANSFORMATION plan operation. |
10181 | CBO disable multi-column in-list processing | |
10182 | CBO disable generation of implied predicates | |
10183 | CBO disable cost rounding | |
10184 | CBO disable OR-exp if long inlist on bitmap column | |
10185 | CBO force index joins | |
10186 | CBO disable index join | |
10187 | CBO additional index join switch | |
10188 | CBO additional index join switch | |
10189 | CBO turn off FFS null fix | |
10190 | Analyze use old frequency histogram collection and density | |
10191 | Avoid conversion of in-lists back to OR-expanded form | |
10192 | nopushdown when number of groups exceed number of rows | |
10193 | Force repeatable sampling with specified seed | |
10194 | CBO disable new LIKE selectivity heuristic | |
10195 | CBO don't use check constraints for transitive predicates | |
10196 | CBO disable index skip scan | |
10197 | CBO force index skip scan | |
10199 | set parameter in session | |
10200 | consistent read buffer status | alter session set events='10200 trace name context forever, level 2'; . Compare with Event 10812 |
10201 | consistent read undo application | Can be used to trace consistent read reads (which are caused by applying undo blocks) |
10202 | consistent read block header | |
10203 | block cleanout | |
10204 | signal recursive extend | |
10205 | row cache debugging | |
10206 | transaction table consistent read | |
10207 | consistent read transactions' status report | |
10208 | consistent read loop check | |
10209 | enable simulated error on control file | |
10210 | check data block integrity | Compare with event 10231 (and 10211?) |
10212 | check cluster integrity | |
10213 | crash after control file write | |
10214 | simulate write errors on control file | |
10215 | simulate read errors on control file | |
10216 | dump control file header | |
10217 | debug sequence numbers | |
10218 | dump uba of applied undo | |
10219 | monitor multi-pass row locking | |
10220 | show updates to the transaction table | |
10221 | show changes done with undo | |
10222 | row cache | |
10223 | transaction layer - turn on verification codes | |
10224 | index block split/delete trace | |
10225 | free/used extent row cache | |
10226 | trace CR applications of undo for data operations | |
10227 | verify (multi-piece) row structure | |
10228 | trace application of redo by kcocbk | |
10229 | simulate I/O error against datafiles | |
10230 | KSFD block repair test event | |
10231 | skip corrupted blocks on _table_scans_ | Compare with event 10210 (and 10211?) |
10232 | dump corrupted blocks symbolically when kcbgotten | |
10233 | skip corrupted blocks on index operations | |
10234 | trigger event after calling kcrapc to do redo N times | |
10235 | check memory manager internal structures | Compare with event 10501 |
10236 | dump redo on object no. or block type mismatch errors 1410/8103 | See also error ORA-08103 and MOS Note 21246723.8 |
10237 | simulate ^C (for testing purposes) | |
10238 | instantiation manager | |
10239 | multi-instance library cache manager | |
10240 | dump dba's of blocks that we wait for | |
10241 | remote SQL execution tracing/validation | |
10242 | suppress OER 2063 (for testing distrib w/o different error log) | |
10243 | simulated error for test of K2GTAB latch cleanup | |
10244 | make tranids in error msgs print as 0.0.0 (for testing) | |
10245 | Testing event used by server I/O ksfd/ksfq module | |
10246 | print trace of PMON actions to trace file | |
10247 | Turn on scgcmn tracing. (VMS ONLY) | |
10248 | turn on tracing for dispatchers | |
10249 | turn on tracing for multi-stated servers | |
10250 | Trace all allocate and free calls to the topmost SGA heap | |
10251 | check consistency of transaction table and undo block | |
10252 | shared IO pool error simulation | |
10253 | limit SQL text returned from X$KGLNA | |
10254 | trace cross-instance calls | |
10255 | pl/sql parse checking | |
10256 | shared server debug event | |
10257 | trace shared server load balancing | |
10258 | force shared servers to be chosen round-robin | |
10259 | get error message text from remote using explicit call | |
10260 | PGA limit (MB) exceeded - process terminated | |
10261 | limit the size of the PGA heap | See also the hidden init parameter _dump_10261_level |
10262 | Don't check for memory leaks | alter system set events '10262 trace name CONTEXT forever,level 90000'; . This event is typically used to prevent unwanted ORA-00600 [729] errors and does not produce any output. Thus, the event is used to ignore small memory leaks. level = 1 disables space leak checking, otherwise it indicates the number of bytes space leak to ignore. See also MOS Notes 21235.1 and 403584.1. |
10263 | Don't free empty PGA heap extents | |
10265 | Keep random system generated output out of error messages | |
10266 | Trace OSD stack usage | |
10267 | Inhibit KSEDMP for testing | |
10268 | Don't do forward coalesce when deleting extents | Set to level 10, see also MOS Note 33567.1 |
10269 | Don't do coalesces of free space in SMON | Setting the level to 10 prevent SMON from cleaning up temp segment (see MOS Note 793380.1). Compare with event 10061 |
10270 | Debug shared cursors | |
10271 | distributed transaction after COLLECT | |
10272 | distributed transaction before PREPARE | |
10273 | distributed transaction after PREPARE | |
10274 | distributed transaction before COMMIT | |
10275 | distributed transaction after COMMIT | |
10276 | distributed transaction before FORGET | |
10277 | Cursor sharing (or not) related event (used for testing) | |
10278 | Internal testing | |
10279 | Simulate block corruption in kdb4chk | |
10280 | Internal testing - segmentation fault during crash recovery | |
10281 | maximum time to wait for process creation | |
10282 | Inhibit signalling of other backgrounds when one dies | |
10284 | simulate zero/infinite asynch I/O buffering | |
10285 | Simulate control file header corruption | |
10286 | Simulate control file open error | |
10287 | Simulate archiver error | |
10288 | Do not check block type in ktrget | |
10289 | Do block dumps to trace file in hex rather than formatted | This event might be necessary when dumping a corrupt block whose content cannot be parsed anymore. |
10290 | Internal sequence tracing event | |
10291 | die in tbsdrv to test control file undo | |
10292 | hang analysis trace event | |
10293 | trace log switch media recovery checkpoints | |
10294 | ksrpc tracing | |
10295 | die after file header update durning cf xact | |
10296 | disable ORA-379 («no free buffers available in buffer pool for block size K») | |
10297 | shared I/O pool tracing | |
10298 | ksfd i/o tracing | |
10299 | Trace prefetch tracking decisions made by CKPT | |
10300 | Distributed transaction tracing | |
10301 | Enable LCK timeout table consistency check | |
10302 | trace create or drop internal trigger | |
10303 | trace loading of library cache for internal triggers | |
10304 | trace replication trigger | |
10305 | trace updatable materialized view trigger | |
10306 | trace materialized view log trigger | |
10307 | trace RepCat execution | |
10308 | replication testing event | |
10309 | Trigger Debug event | |
10310 | trace synchronous change table trigger | |
10311 | Disable Flashback Table Timestamp checking | |
10312 | Allow disable to log rows into the mapping table | |
10314 | Enable extra stats gathering for CR | |
10316 | Events for extensible txn header, non zero ext header size | |
10317 | Events for extensible txn header, zero ext header size | |
10318 | Trace extensible txn header movements | |
10319 | Trace PGA statistics maintenance | |
10320 | Enable data layer (kdtgrs) tracing of space management calls | |
10321 | Datafile header verification debug failure. | |
10322 | CBO don't simplify inlist predicates | |
10323 | before committing an add datafile command | |
10324 | Enable better checking of redo logs errors | |
10325 | Trace control file record section expand and shrink operations | |
10326 | clear logfile debug crash at , log | |
10327 | simulate ORA-00235 error for testing | |
10328 | disable first-to-mount split-brain error, for testing | |
10329 | simulate out-of-memory error during first pass of recovery | |
10330 | clear MTTR statistics in checkpoint progress record | |
10331 | simulate resilvering during recovery | |
10332 | force ALTER SYSTEM QUIESCE RESTRICTED command to fail | |
10333 | dump MTTR statistics each time it is updated | |
10334 | force FG to wait to be killed during MTTR advisory simulation | |
10335 | trace database open status | |
10336 | Do remote object transfer using remote SQL | |
10337 | enable padding owner name in slave sql | |
10338 | CBO don't use inlist iterator with function-based indexes | |
10339 | CBO disable DECODE simplification | |
10340 | Buffer queues sanity check for corrupted buffers | |
10341 | Simulate out of PGA memory in DBWR during object reuse | |
10342 | Raise unknown exception in ACQ_ADD when checkpointing | |
10343 | Raise an out of memory exception-OER 4031 in ACQ_ADD | |
10344 | reserved for simulating object hash reorganization | |
10345 | validate queue when linking or unlinking a buffer | |
10346 | check that all buffers for checkpoint have been written | |
10347 | dump active checkpoint entries and checkpoint buffers | |
10348 | test abnormal termination of process initiating file checkpoint | |
10349 | do not allow ckpt to complete | |
10350 | Simulate more than one object & tsn id in object reuse | |
10351 | size of slots | |
10352 | report direct path statistics | |
10353 | number of slots | |
10354 | turn on direct read path for parallel query | |
10355 | turn on direct read path for scans | |
10356 | turn on hint usage for direct read | |
10357 | turn on debug information for direct path | «Event 10357 level 8 at session level will show direct path called for kcbldrget» (MOS Note Event 10357 level 8 at session level will show direct path called for kcbldrget). This revent seems also to be referred to as buffer cache tracing (MOS Note 19787571.8). Compare with trace[KDSFTS] disk=high |
10358 | Simulate out of PGA memory in cache advisory reset | |
10359 | turn off updates to control file for direct writes | |
10360 | enable dbwr consistency checking | |
10361 | check buffer change vector count consistency | |
10362 | simulate a write error to take a file offline | |
10363 | Simulate messaging error for fast object reuse/checkpoint | |
10364 | Do not clear GIMH_STC_SHUT_BEGIN state during shutdown | |
10365 | turn on debug information for adaptive direct reads | |
10366 | kgnfs tracing | |
10367 | kgodm tracing | |
10368 | maximum number of internal errors a process will tolerate | |
10369 | test SQL monitoring feature | |
10370 | parallel query server kill event | |
10371 | disable TQ hint | |
10372 | parallel query server kill event proc | |
10373 | parallel query server kill event | |
10375 | turn on checks for statistics rollups | |
10376 | enable archive compression loads | |
10377 | force slave allocation | |
10378 | force hard process/range affinity | |
10380 | kxfp latch cleanup testing event | |
10381 | kxfp latch cleanup testing event | |
10382 | parallel query server interrupt (reset) | |
10383 | auto parallelization testing event | |
10384 | parallel dataflow scheduler tracing | |
10385 | parallel table scan range sampling method | |
10386 | parallel SQL hash and range statistics | |
10387 | parallel query server interrupt (normal) | |
10388 | parallel query server interrupt (failure) | |
10389 | parallel query server interrupt (cleanup) | |
10390 | Trace parallel query slave execution | |
10391 | trace PX granule allocation/assignment | |
10392 | parallel query debugging bits | |
10393 | print parallel query statistics | |
10394 | generate a fake load to test adaptive and load balancing | |
10395 | adjust sample size for range table queues | |
10397 | suppress verbose parallel coordinator error reporting | |
10398 | enable timeouts in parallel query threads | |
10399 | trace buffer allocation | |
10400 | turn on system state dumps for shutdown debugging | |
10401 | turn on IPC (ksxp) debugging | |
10402 | turn on IPC (skgxp) debugging | |
10403 | fake CPU number for default degree of parallelism | |
10404 | crash dbwr after write | |
10405 | emulate broken mirrors | |
10406 | enable datetime TIMESTAMP, INTERVAL datatype creation | |
10407 | enable datetime TIME datatype creation | |
10408 | disable OLAP builtin window function usage | |
10409 | enable granule memset and block invalidation at startup | |
10410 | trigger simulated communications errors in KSXP | |
10412 | dump the call stack if an error is signaled | |
10413 | force simulated error for testing purposes | |
10414 | simulated error from event level | |
10415 | parallel degree specified is too large, max value allowed | |
10416 | disable fix for 2736734 | |
10417 | limit 1 file per sbtinfo2() validation call | |
10418 | disable re-creating tempfile | |
10419 | create tempfile without create_scn and time | |
10420 | trace KSO OS-process operations | |
10421 | enable dump from ksbwco if there is no reply | |
10422 | KSU debugging | |
10423 | dump the call stack if the specified error is cleared | |
10424 | KGE debugging | |
10425 | enable global enqueue operations event trace | |
10426 | enable ges/gcs reconfiguration event trace | |
10427 | enable global enqueue service traffic controller event trace | |
10428 | enable tracing of global enqueue service cached resource | |
10429 | enable tracing of global enqueue service IPC calls | |
10430 | enable ges/gcs dynamic remastering event trace | |
10431 | enable verification messages on pi consistency | |
10432 | enable tracing of global cache service fusion calls | |
10433 | global enqueue service testing event | |
10434 | enable tracing of global enqueue service multiple LMS | |
10435 | enable tracing of global enqueue service deadlock detetction | |
10436 | enable global cache service duplicate ping checking | |
10437 | enable trace of global enqueue service S optimized resources | |
10438 | force lowest node to be master of all gcs resources | |
10439 | enable tracing of global cache service fusion calls - part 2 | |
10440 | enable global enqueue service inquire resource modes trace | |
10441 | enable diagnosibility daemon (DIAG) trace | |
10442 | enable trace of kst for ORA-01555 diagnostics | |
10443 | reserved for data layer diagnostics and debugging | |
10444 | enable DLM timeout testing | |
10445 | enable tracing of LMS priority management | |
10446 | reserved for data layer diagnostics and debugging | |
10447 | reserved for data layer diagnostics and debugging | |
10448 | Dump trace for OLTP partial compression features diagnostics | |
10449 | enable trace of kst for undo manageability features diagnostics | |
10450 | signal ctrl-c in kdddca (drop column) after n rows | |
10451 | Force heap segment compression bypassing compatibility checks | |
10452 | Cannot do block media recovery; media recovery session may be in progress | |
10453 | Dump compression statistics to trace file | |
10454 | Disable column reordering during compression | |
10455 | Do Compression Block Checking | |
10456 | cannot open standby database; media recovery session may be in progress | |
10457 | cannot close standby database due to active media recovery | |
10458 | standby database requires recovery | |
10459 | cannot start media recovery on standby database; conflicting state detected | |
10460 | Perform backward tablescans for consistent read reduction | |
10461 | Simulate control file corruption during write operation | |
10462 | enable recovery debug module | |
10463 | enable controlfile test | |
10464 | enable incremental checkpoint debug for split brain check | |
10465 | force slave death during parallel crash recovery | |
10466 | enable HARD check for block write | |
10467 | amplify control file record expansion for testing | |
10468 | log writer debug module | |
10469 | error creating control file backup, no checkpoint | |
10470 | Lost write detection related event | |
10471 | PQ slave allocation timeout test | |
10472 | dump reading log buffer hit ratio histogram to lgwr trace file | |
10473 | enable BRR tracing | |
10474 | controlfile time tracing | |
10475 | readable standby debug event | |
10476 | control file corruption range testing | |
10477 | simulated rollback error | |
10478 | DBW0 file identification trace event | |
10479 | disk sector size test event | |
10480 | Soft asserts for fast detection of datafile storage problems | |
10481 | Backup data block for data file has an unlogged change | |
10482 | Automatic block repair cannot repair an offline or read-only data file | |
10483 | Simulate overly advanced incremental checkpoint | |
10484 | Enable tracing for online data file move operation | |
10485 | Real-Time Query cannot be enabled while applying migration redo. | |
10486 | Verify data file-related SGA alignment | |
10487 | Dump redo memory protection information. | |
10488 | Dump block headers read for media recovery. | |
10489 | Generate future redo for testing | |
10490 | Trace OSM misc. events | |
10491 | Trace OSM messaging (KFN) events | |
10492 | Trace OSM metadata events | |
10493 | Return empty define buffers on 1422 | |
10494 | Trace OSM metadata events | |
10495 | Trace OSM metadata events | |
10496 | Turn off fix for bug 2554178 | |
10497 | Trace OSM metadata events | |
10498 | Trim blank characters including contol characters | |
10499 | Trace OSM metadata events | |
10500 | turn on traces for SMON | |
10501 | periodically check selected heap | Compare with event 10235 |
10502 | CBO disable the fix for bug 2098120 | |
10503 | enable user-specified graduated bind lengths | |
10504 | CBO disable the fix for bug 2607029 | |
10505 | CBO enable dynamic sampling dump to table | |
10506 | Disable fix for bug 2588217 | |
10507 | Trace bind equivalence logic | |
10508 | Enable fix for bug 14772545 | |
10509 | Check kghu subheaps at call boundaries | |
10510 | turn off SMON check to offline pending offline rollback segment | |
10511 | turn off SMON check to cleanup undo dictionary | |
10512 | turn off SMON check to shrink rollback segments | |
10513 | turn on IPC (ksmsq) debugging | If event 10513 is set in SMON process (with level=2), transaction recovery is disabled (See MOS Note 1577988.1) |
10515 | turn on event to use physical cleanout | |
10519 | enable ALTER TYPE RESET support | |
10520 | recreate view only if definition has changed | Found in catrelod.sql or owainst.sql . This event avoids unnecessary re-compilations. |
10521 | CMON connection pool test event | |
10522 | turn off wrap source compression | |
10523 | force recreate package even if definition is unchanged | |
10524 | CMON connection pool trace event | |
10525 | Disable automatic object validation for describe | |
10526 | enables lightweight thread tracing | |
10527 | enables SGA allocation tracing | |
10528 | enables ksmg tracing | |
10529 | enables SGA range protection tracing | |
10530 | lightweight thread spawn failed, error stack: | |
10531 | lightweight thread unit test failure error | |
10532 | lightweight thread encountered internal error | |
10542 | Enable tracing for block compare | |
10543 | Standby Block Media Recovery (bmr) and split brain testing event | |
10544 | Inject standby autobmr failures | |
10545 | Print standby autobmr messages in alert log | |
10546 | Cannot perform block media recovery; standby database does not have requisite redo. | |
10547 | Cannot perform block media recovery; standby database is not caught up with primary. | |
10548 | Cannot perform block media recovery on a read-only plugged-in datafile. | |
10549 | Cannot perform block media recovery using a read-only plugged-in backup datafile. | |
10550 | signal error during create as select/create index after n rows | |
10551 | Internal testing for ORA-1551 error handling | |
10552 | allow unlimited corruption during recovery | |
10553 | Incompatible UNTIL CONSISTENT clause | |
10554 | Media recovery failed to bring datafile to a consistent point | |
10556 | Enable tracing for multi instance Redo Apply | |
10557 | NID clears database incarnation section in controlfile | |
10558 | Disable unkeep marker handling for ADG | |
10559 | LGWR code path debugging event for deferred log flush on ping | |
10560 | block type '' | |
10561 | block type '', data object# | |
10562 | Error occurred while applying redo to data block (file# , block# ) | |
10563 | Test recovery had to corrupt data block (file# , block# ) in order to proceed | |
10564 | tablespace | |
10565 | Another test recovery session is active | |
10566 | Test recovery has used all the memory it can use | |
10567 | Redo is inconsistent with data block (file# , block# , file offset is bytes) | |
10568 | Failed to allocate recovery state object: out of SGA memory | |
10569 | Trace datafile header writes | |
10570 | Test recovery complete | |
10571 | Test recovery canceled | |
10572 | Test recovery canceled due to errors | |
10573 | Test recovery tested redo from change to | |
10574 | Test recovery did not corrupt any data block | |
10575 | Give up restoring recovered datafiles to consistent state: out of memory | |
10576 | Give up restoring recovered datafiles to consistent state: some error occurred | |
10577 | Can not invoke test recovery for managed standby database recovery | |
10578 | Can not allow corruption for managed standby database recovery | |
10579 | Can not modify control file during test recovery | |
10580 | Can not modify datafile header during test recovery | |
10581 | Can not modify redo log header during test recovery | |
10582 | The control file is not a backup control file | |
10583 | Can not recovery file renamed as missing during test recovery | |
10584 | Can not invoke parallel recovery for test recovery | |
10585 | Test recovery can not apply redo that may modify control file | |
10586 | Test recovery had to corrupt 1 data block in order to proceed | |
10587 | Invalid count for ALLOW n CORRUPTION option | |
10588 | media recovery file header validation | |
10589 | Test recovery had to corrupt data blocks in order to proceed | |
10590 | kga (argus debugger) test flags | |
10591 | kga (argus debugger) test flags | |
10592 | kga (argus debugger) test flags | |
10593 | kga (argus debugger) test flags | |
10594 | kga (argus debugger) test flags | |
10595 | kga (argus debugger) test flags | |
10596 | kga (argus debugger) test flags | |
10597 | kga (argus debugger) test flags | |
10598 | kga (argus debugger) test flags | |
10599 | kga (argus debugger) test flags | |
10600 | check cursor frame allocation | |
10601 | turn on debugging for cursor_sharing (literal replacement) | Can this one also be used to test SQL translation (dbms_sql_translator )? |
10602 | ? | Found in Oracle's documentation on autonomous health. |
10603 | cause an error to occur during truncate (for testing purposes) | |
10604 | trace parallel create index | |
10605 | enable parallel create index by default | |
10606 | trace parallel create index | |
10607 | trace index rowid partition scan | |
10608 | trace create bitmap index | |
10609 | trace for array index insertion | |
10610 | trace create index pseudo optimizer | |
10611 | causes migration to fail - testing only | |
10612 | prints debug information for auto-space managed segments | |
10613 | prints debug information for auto-space managed segments | |
10614 | Operation not allowed on this segment | |
10615 | Invalid tablespace type for temporary tablespace | |
10616 | Operation not allowed on this tablespace | |
10617 | Cannot create rollback segment in dictionary managed tablespace | |
10618 | Operation not allowed on this segment | |
10619 | Avoid assertions when possible | |
10620 | Operation not allowed on this segment | |
10621 | specify retry count for online index build cleanup DML lock get | |
10622 | test or trace online index build or rebuild | |
10623 | test synchronized flow of SORT rows into FOR UPDATE lock phase | |
10624 | Disable UJV invalidation on drop index | |
10625 | Turn off redo log dump for the index when OERI 12700 | |
10626 | specify timeout for online index rebuild to wait for DML | |
10627 | Dump the content of the index leaf block | |
10628 | Turn on sanity check for kdiss index skip scan state | |
10629 | force online index build to backoff and retry DML lock upgrade | |
10630 | Illegal syntax specified with SHRINK clause | |
10631 | SHRINK clause should not be specified for this object | |
10632 | Invalid rowid | |
10633 | No space found in the segment | |
10634 | Segment is already being shrunk | |
10635 | Invalid segment or tablespace type | |
10636 | ROW MOVEMENT is not enabled | |
10637 | The segment does not exist | |
10638 | Index status is invalid | |
10639 | Dump library cache during reparse loops | |
10640 | Operation not permitted during SYSTEM tablespace migration | |
10641 | Cannot find a rollback segment to bind to | |
10642 | Found rollback segments in dictionary managed tablespaces | |
10643 | Database should be mounted in restricted mode and Exclusive mode | |
10644 | SYSTEM tablespace cannot be default temporary tablespace | |
10645 | Recursive Extension in SYSTEM tablespace during migration | |
10646 | Too many recursive extensions during SYSTEM tablespace migration | |
10647 | Tablespace other than SYSTEM, , not found in read only mode | |
10648 | Tablespace SYSAUX is not offline | |
10649 | Turn off/trace lob index freelist coalesce | |
10650 | disable cache-callback optimisation | |
10651 | incorrect file number block number specified | |
10652 | Object has on-commit materialized views | |
10653 | Table is in a cluster | |
10654 | Table is of type temporary or external | |
10655 | Segment can be shrunk | |
10656 | Table is in unusable state due to incomplete operation | |
10657 | Lob column to be shrunk does not exist | |
10658 | Lob column to be shrunk is marked unused | |
10659 | Segment being shrunk is not a lob | |
10660 | Segment is a shared lob segment | |
10661 | Invalid option specified | |
10662 | Segment has long columns | |
10663 | Object has rowid based materialized views | |
10664 | Table has bitmap join indexes | |
10665 | Inject Evil Literals | Compare 10668 |
10666 | Do not get database enqueue name | |
10667 | Cause sppst to check for valid process ids | |
10668 | Inject Evil Identifiers | Compare 10665 |
10690 | Set shadow process core file dump type (Unix only) | |
10691 | Set background process core file type (Unix only) | |
10692 | Trace preserving buffer across standby role transition | |
10693 | Internal event | |
10700 | Alter access violation exception handler | |
10701 | Dump direct loader index keys | |
10702 | Application continuity debugging was not enabled | |
10704 | Print out information about what enqueues are being obtained (arguments to calls to ksqcmi and ksqlrl and their return values) | In 23c: Trace deadlock ID from transaction |
10706 | Print out information about global enqueue manipulation | |
10707 | Simulate process death for instance registration | |
10708 | print out trace information from the RAC buffer cache | |
10709 | enable parallel instances in create index by default | |
10710 | trace bitmap index access | |
10711 | trace bitmap index merge | |
10712 | trace bitmap index or | |
10713 | trace bitmap index and | |
10714 | trace bitmap index minus | |
10715 | trace bitmap index conversion to rowids | |
10716 | trace bitmap index compress/decompress | |
10717 | trace bitmap index compaction trace for index creation | |
10718 | event to disable automatic compaction after index creation | |
10719 | trace bitmap index dml | |
10720 | trace db scheduling | |
10721 | Internal testing - temp table transformation | Compare with the TEMP TABLE TRANSFORMATION plan operation. |
10722 | trace server level database scheduling | |
10723 | Internal testing - release buffer for buffer cache shrink | |
10724 | trace cross-instance broadcast | |
10725 | bitmap index version control | |
10726 | frequent itemset counting | |
10727 | introduce failure events in IPC | |
10728 | set parameters for CPU frequency calculation (debug) | |
10730 | trace row level security policy predicates | RAC Component Data Security VPD Rewrite (XSVPD) |
10731 | dump SQL for CURSOR expressions | alter session set events '10731 trace name context forever, level lvl'; . lvl = 1: Print parent query and subquery, lvl = 2: Print subquery only. |
10732 | honor pctfree during insert into AQ IOTs | |
10733 | test transient-IOT metadata during PMO cleanup | PMO = Partition maintenance operation? |
10734 | reroute external procedures | |
10735 | debug ksws operations | |
10736 | buffer cache pin history dump | |
10737 | test block checking | |
10738 | internal block testing | |
10739 | debug WLM (kywm) operations | |
10740 | disables fix for bug 598861 | |
10741 | trace missing BRR generation | |
10742 | dump process state on flush buffer_cache | |
10743 | define the misbehaved vt dump thresholds | |
10744 | disable LMD stale cvak traces and dumps | |
10745 | enable LCK1 kqlmbivg-NULL-kglhdrac dump | |
10746 | enable KGCE_DEBUG_MODE | |
10750 | test rollback segment blksize guessing for index array insert | |
10751 | override for remote row source maximum buffer size | |
10752 | override for the Exponential Moving Average factor | |
10753 | enforce deterministic behaviour for prefetching row source | |
10754 | disable fix for bug 14173995 for multi-table select for update | |
10755 | Event to store SIG_1551 stacks to KST | |
10756 | Event to enable svpt/autotxn tracing | |
10757 | Event to control tracing row source: rows to dump per rowset | |
10758 | Event to control tracing row source: start row number | |
10759 | Event to control tracing row source: end row number | |
10760 | Event to control tracing row source: maximum encoded operands to check | |
10761 | Event to control tracing row source: size of dictionary | |
10770 | Disable optimization to avoid buffering the right side of a cartesian join | |
10780 | LogMiner API trace event | |
10781 | LogMiner reader trace event | |
10782 | LogMiner preparer trace event | |
10783 | LogMiner builder trace event | |
10784 | LogMiner dictionary trace event | |
10785 | LogMiner trace event | |
10786 | call push/pop (KSU) | |
10787 | trace intra-instance broadcast | |
10788 | trace call stacks | |
10789 | LogMiner test event | |
10790 | LogMiner trace event | |
10791 | Logical Standby swithover/failover trace event | |
10792 | Logical Standby XDAT trace event | |
10793 | Logical Standby trace event | |
10794 | Logical Standby trace event | |
10795 | VKTM Process trace event | |
10796 | Elevate Scheduler Priority trace event | |
10797 | Logical Standby Test Event | |
10798 | debug GSM (Global Service Manager) operations | |
10800 | disable Smart Disk scan | |
10804 | reserved for ksxb | |
10805 | Trace state object operations | |
10806 | Switch to 7.3 mode when detaching sessions | |
10807 | Disable user id check when switching to a global transaction | |
10808 | Enable assert when waiting without a reason | |
10809 | Trace state object allocate / free history | |
10810 | Trace snapshot too old | |
10811 | Trace block cleanouts | |
10812 | Trace Consistent Reads | Compare with event 10200 |
10826 | enable upgrade/downgrade error message trace | |
10827 | enable upgrade/downgrade diagnostics | |
10828 | memory allocator error | |
10829 | enable error suppression in NORMAL mode | Found in catpcatses.sql . Suppresses expected errors in NORMAL mode. |
10830 | Trace group by sort row source | |
10831 | Trace group by rollup row source | |
10832 | Trace approximate NDV row source | |
10833 | Runtime distribution keys for adaptive partial rollup | |
10834 | Runtime behavior control for adaptive partial rollup | |
10835 | exclude SYS_OP_CYCLED_SEQ from TQ keys for scalable percentile | |
10839 | trace / debug caching module (qesca.c) | |
10840 | trace / debug pl/sql caching module (kkxmInitCache) | |
10841 | Default un-inintialized charact set form to SQLCS_IMPLICIT | |
10842 | Event for OCI Tracing and Statistics Info | |
10843 | Event for client result cache tracing | |
10844 | turn on Native Net IPC debugging (skgxp) | |
10845 | Enable Director tracing | |
10846 | Event for non-blocking testing | |
10847 | OCI dump action is being invoked for internal error ORA- | |
10848 | OCI Non Blocking not supported with | |
10849 | Internal OCI event number | |
10850 | Enable time manager tracing | |
10851 | Allow Drop command to drop queue tables | Comment in c1102000.sql is Turn ON/OFF the event to enable/disable DDL on AQ tables. |
10852 | Enable tracing for Enqueue Dequeue Operations | |
10853 | Enable tracing for Replicating AQ Operations | |
10854 | Sets poll count used for AQ listen code under RAC | |
10856 | Disable AQ propagator from using streaming | |
10857 | Force AQ propagator to use two-phase commit | |
10858 | Crash the AQ propagator at different stages of commit | |
10859 | Disable updates of message retry count | |
10860 | event for AQ admin disable new name parser | |
10861 | disable storing extended message properties | |
10862 | resolve default queue owner to current user in enqueue/dequeue | |
10863 | Control behavior of buffered background operations | |
10864 | event to enable AQ dedicated propagation | |
10865 | Control tracing of notification operations | |
10866 | event to order dequeue by condition | |
10867 | turn off authentication for emon to oci client and disable HA rstat | |
10868 | event to enable interop patch for AQ enqueue options | |
10870 | Disable multi-instance standby role transition | |
10871 | dump file open/close timestamp during media recovery | |
10872 | Flashback Database fault insertion event #. | |
10873 | file needs to be either taken out of backup mode or media recovered | |
10874 | Change max logfiles in hashtable in krfbVerifyRedoAvailable | |
10875 | Require instance bounce after switchover to primary | |
10876 | IDR Test event | |
10877 | error signaled in parallel recovery slave | |
10878 | parallel recovery slave died unexpectedly | |
10879 | error signaled in parallel recovery slave | |
10880 | trace Java VM execution | |
10883 | Event for Fast Application Notification tracing | |
10884 | TTC event | |
10885 | Switchover test event | |
10886 | Recovery test event | |
10887 | An Oracle Active Data Guard license is required to open a pluggable database while standby recovery is applying changes. | |
10888 | TTC event for optimized fetch | |
10889 | minimum number of instances needed for redo apply unavailable | |
10890 | ADG test event | |
10891 | disable column pruning in ANSI join transformation | |
10892 | multi-instance redo apply encountered nonlogged operation | |
10893 | TTC trace event | |
10898 | LGWR timing event | |
10900 | extent manager fault insertion event # | |
10901 | disable the fix for bug 1230798 | |
10902 | disable seghdr conversion for ro operation | |
10903 | Force tablespaces to become locally managed | |
10904 | Allow locally managed tablespaces to have user allocation | |
10905 | Do cache verification (kcbcxx) on extent allocation | |
10906 | Unable to extend segment after insert direct load | |
10907 | Trace extent management events | |
10908 | Trace temp tablespace events | |
10909 | Trace free list events | |
10910 | inject corner case events into the RAC buffer cache | |
10911 | Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle Support | |
10912 | Used to perform admin operations on locally managed SYSTEM tablespace | |
10913 | Create locally managed database if compatible > 920 by default | |
10914 | invalid TABLESPACE GROUP clause | |
10915 | TABLESPACE GROUP cannot be specified for this type of tablespace | |
10916 | TABLESPACE GROUP already specified | |
10917 | TABLESPACE GROUP cannot be specified | |
10918 | TABLESPACE GROUP name cannot be the same as tablespace name | |
10919 | Default temporary tablespace group must have at least one tablespace | |
10920 | Cannot offline tablespace belonging to default temporary tablespace group | |
10921 | Cannot drop tablespace belonging to default temporary tablespace group | |
10922 | Temporary tablespace group is empty | |
10923 | prints debug information for object space server manageability | |
10924 | import storage parse error ignore event | |
10925 | trace name context forever | |
10926 | trace name context forever | |
10927 | trace name context forever | |
10928 | trace name context forever | Controls if tracing of all executed PL/SQL pseudo codes is enabled. See also Event 10938, MOS Note 52481.1 and Pete Finnigans blog |
10929 | trace name context forever | |
10930 | trace name context forever | |
10931 | trace name context forever | |
10932 | trace name context forever | |
10933 | trace name context forever | Found in catcr.sql . Turns off/on an SQL behavior event («PL/SQL) event used by APPS. |
10934 | trace name context forever | |
10936 | trace name context forever | |
10937 | trace name context forever | |
10938 | trace name context forever | Controls what information is traced (see event 10928). See also MOS Note 52481.1. As per Julian Dyke dumps PL/SQL execution statistics. Results are written into tables that are created with rdbms/admin/tracetab.sql . See also init parameter _plsql_dump_buffer_events and event 10940. |
10939 | trace name context forever | |
10940 | trace name context forever | |
10941 | trace name context forever | |
10943 | trace name context forever | |
10944 | trace name context forever | |
10945 | trace name context forever | |
10946 | trace name context forever | |
10947 | trace name context forever | |
10948 | trace name context forever | |
10949 | Disable autotune direct path read read for full table scan | |
10960 | AQ tracing event | |
10961 | Enable tracing for Scheduler subscriber cleanup | |
10970 | backout event for bug 2133357 | |
10971 | prints debugging information for LOBs | |
10972 | raise a 1551 exception in kdu_array_flush | |
10973 | backout event for 2619509 | |
10974 | Turn on LOB integrity verification | |
10975 | trace execution of parallel propagation | |
10976 | internal package related tracing | |
10977 | trace event for RepAPI | |
10978 | general event for materialized view logs | |
10979 | trace flags for join index implementation | |
10980 | prevent sharing of parsed query during Materialized View query generation | |
10981 | dscn computation-related event in replication | |
10982 | event to turn off CDC-format MV Logs | |
10983 | event to enable Create_Change_Table debugging | |
10984 | subquery materialized view-related event | |
10985 | event for NULL refresh of materialized views | |
10986 | donot use HASH_AJ in refresh | |
10987 | event for the support of caching table with object feature | |
10988 | event to get exclusive lock during materialized view refresh in IAS | |
10989 | event to internally create statistics MV | |
10990 | dump spreadsheet info | |
10991 | event for optimizing the online redefinition instantiation | |
10992 | event to enable dbms_job instead of dbms_scheduler | |
10993 | Runtime enable IOQ batching | |
10994 | Compiletime enable IOQ batching | |
10995 | general event for materialized views | |
10997 | another startup/shutdown operation of this instance inprogress | |
10998 | event to enable short stack dumps in system state dumps | |
10999 | do not get database enqueue name | |
12498 | | Found in catxev.sql . Used to add column refcount to xdb$resconfig table. |
14524 | Always allow partitioning. To be used only by trusted clients | '14524 trace name context forever, level 1' : Turn the event on that disables partition check. Found in $ORACLE_HOME/rdbms/admin/catost.sql . Apparently used to circumvent partition check when creating a partition without having Partitioning Option. |
14529 | copy hakan factor during ctas at facilitate exchange partition | Found in catawrtb.sql . Turns on or off create partition exchange tables with CTAS. |
14533 | Event for ALTER TABLE enhancements for code point semantics | Comment in c1202000.sql is Disable column validation… |
19056 | Turn on csx dml internal event to let internal columns be reloaded. | Found in $ORACLE_HOME/rdbms/admin/utl32k.sql |
19119 | event for turning on XMLQUERY and XMLTABLE features | Found in xdbeo112.sql or xdbxtbix.sql |
19027 | event for suppressing query rewrite with XML operators | Found in xdbud111.sql . Used to turn on rewrite for updxml/delxml/insertxml over collections? |
22372 | event for type dictionary upgrade | Found in dbmsobj.sql . Needed to create packed image typed tables. |
22825 | event set during import/export | Somehow related to the opaque_transform hint. |
22829 | Event to allow LATERAL views | Apparently, setting event 22829 in an Oracle 11 environment enables lateral joins (see for example Jonathan Lewis' Blog). |
22830 | Event enabling VARRAYs columns to be created as OCTs | Found in catqm_int.sql . Turns off the REF cascade semantics for resource$ . |
27401 | Scheduler debug event | Found here. alter system set events '27401 trace name context forever, level 262144' (See Oracle FILE_WATCHER and its troubleshooting) |
27402 | Scheduler tracing event | Found here |
27403 | scheduler stop job event | Found here |
30579 | | Setting level 2 enables result set interface with SDATA, see MOS Note 1940905.1. |
31061 | XDB error: | Found in xdbuend.sql . Traces «further lxs-0002x errors» |
31098 | internal event to turn on XDB tracing | Traces requests for the protocol server of XML DB. |
31150 | unrecoverable error in handler | Found in catqm_int.sql , xdbuend.sql or prvtxdz2.plb . Sets xdk scheme cache event. |
31156 | internal event to turn off validation during schema registration | Found in catxdbc1.sql . Register Config Schema? |
38003 | CBO Disable column stats for the dictionary objects in recursive SQL | Setting this event affects the bootstrap process of loading the fixed cache in kqlblfc() : Bootstrap objects that are not defined as such in bootstrap$ ) will be left as non-bootstrapped. |
39098 | Worker process received data objects while loading metadata. Invalid process order range is .. | Seems to be related to the data pump |
44715 | Event for XDB initialization | Found in catqm.sql . This event denotes XDB initialization (start/complete). |
46049 | | RAC Component Data Security (XSXDS) |
46110 | | RAC Component ACLs (XSACL) |
46148 | Trace application session events, such as createSession and attachSession | RAC Component Application Sessions (XSSESSION). ALTER SESSION SET EVENTS '46148 trace name context forever, level="1", level="2", level="3"'; or ALTER SESSION SET EVENTS 'TRACE [XSSESSION] disk=[low, medium, high]' |
46149 | | RAC Compnonent Security Classes (XSSECCLASS) |
46150 | | RAC Compnonent Application Principals (XSPRINCIPAL) |
46151 | | RAC Compnonen Mid-Tier Caches (XS_MIDTIER) |
55622 | DML, ALTER and CREATE UNIQUE INDEX operations are not allowed on table ""."" | Found in a21.sql . |