TRACE EVENTS

Trace events code

To Enable trace events :

SQL> alter session set events '10093 trace name context forever , level 1';

To Disable it :

alter session set events ‘10093 trace name context off’;

For example :

if you need to enable forcing index :

SQL> alter session set events '10110 trace name context forever , level 1';

List

Code   Trace Information
10000   Controlfile debug event, name 'control_file'
10001   Controlfile crash event1
10002   Controlfile crash event2
10003   Controlfile crash event3
10004   Controlfile crash event4
10005   Trace latch operations for debugging
10006   Testing - block recovery forced
10007   Log switch debug crash after new log select, thread %s
10008   Log switch debug crash after new log header write, thread %s
10009   Log switch debug crash after old log header write, thread %s
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   Data Segment Recovery
10020   Partial link restored to linked list (KSG)
10021   Latch cleanup for state objects (KSS)
10022   Trace ktsgsp
10023   Create Save Undo Segment
10024   Write to Save Undo
10025   Extend Save Undo Segment
10026   Apply Save Undo
10027   Latch cleanup for enqueue locks (KSQ)
10028   Latch cleanup for enqueue resources (KSQ)
10029   Session logon (KSU)
10030   Session logoff (KSU)
10031   Sort debug event (S*)
10032   Sort statistics (SOR*)
10033   Sort run information (SRD*/SRS*)
10034   Access path analysis (APA*)
10035   Parse SQL statement (OPIPRS)
10036   Create remote row source (QKANET)
10037   Allocate remote row source (QKARWS)
10038   Dump row source tree (QBADRV)
10039   Type checking (OPITCA)
10040   Dirty cache list
10041   Dump undo records skipped
10042   Trap error during undo application
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
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
10054   Trace UNDO handling in MLS
10055   Trace UNDO handing
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
10061   Disable SMON from cleaning temp segment
10062   Disable usage of OS Roles in osds
10063   Disable usage of DBA and OPER privileges in osds
10064   Thread enable debug crash level %s, thread %s
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   Trusted Oracle test event
10070   Force datafile checksum errors - block number
10071   Force datafile checksum errors - file number
10072   Protect latch recovery memory
10073   Have PMON dump info before latch cleanup
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
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   A brand new block has been requested from space management
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   Atomic redo write recovery
10102   Switch off anti-joins
10103   CBO Disable hash join swapping
10104   Dump hash join statistics to trace file
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
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   QKA Disable Bitmap And-EQuals
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   Use v$sql_plan code path for explain plan
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
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 enable dynamic selectivity estimation
10143   CBO force dynamic selectivity estimation (if enabled)
10145   Test auditing network errors
10146   Enable Oracle TRACE collection
10148   Use pre-7.3.3 random generator
10149   Allow the creation of constraints with illegal date constants
10150   Import exceptions
10151   Force duplicate dependency removal
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 to be aborted during shutdown normal
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   CBO no constraint-based join-back elimination
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
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
10198   Check undo record
10199   Set parameter in session
10200   Consistent read buffer status
10201   Consistent read undo application
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 controlfile
10210   Check data block integrity
10211   Check index block integrity
10212   Check cluster integrity
10213   Crash after controlfile write
10214   Simulate write errors on controlfile
10215   Simulate read errors on controlfile
10216   Dump controlfile 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   Check redo generation by copying before applying
10231   Skip corrupted blocks on _table_scans_
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
10236   Library cache manager
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 %s of K2GTAB latch cleanup
10244   Make tranids in error msgs print as 0.0.0 (for testing)
10245   Simulate lock conflict error for testing PMON
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   Simulate write error to data file header
10253   Simulate write error to redo log
10254   Trace cross-instance calls
10255   Pl/sql parse checking
10256   Turn off shared server load balancing
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   Trace calls to SMPRSET (VMS ONLY)
10261   Limit the size of the PGA heap
10262   Don't check for memory leaks
10263   Don't free empty PGA heap extents
10264   Collect statistics on context area usage (x$ksmcx)
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
10269   Don't do coalesces of free space in SMON
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
10283   Simulate asynch I/O never completing
10284   Simulate zero/infinite asynch I/O buffering
10285   Simulate controlfile header corruption
10286   Simulate controlfile 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 fromatted
10290   Kdnchk - checkvalid event - not for general purpose use.
10291   Die in tbsdrv to test controlfile undo
10292   Dump uet entries on a 1561 from dtsdrv
10293   Dump debugging information when doing block recovery
10294   Enable PERSISTENT DLM operations on non-compliant systems
10295   Die after file header update durning cf xact
10296   Disable ORA-379
10297   Customize dictionary object number cache
10298   Ksfd i/o tracing
10299   Trace prefetch tracking decisions made by CKPT
10300   Disable undo compatibility check at database open
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
10319   Trace PGA statistics maintenance
10320   Enable data layer (kdtgrs) tracing of space management calls
10321   Datafile header verification debug failure.
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 %s, log %s
10327   Simulate ORA-00235 error for testing
10328   Disable first-to-mount split-brain error, for testing
10329   Simulate lost write, test detection by two-pass recovery
10330   Clear MTTR statistics in checkpoint progress record
10331   Simulate resilvering during recovery
10332   Force ALTER SYSTEM QUIESCE RESTRICTED command to fail
10336   Do remote object transfer using remote SQL
10337   Enable padding owner name in slave sql
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   Simulate kghxal returning 0 in ACQ_ADD but no exception
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
10359   Turn off updates to control file for direct writes
10360   Enable dbwr consistency checking
10365   Turn on debug information for adaptive direct reads
10370   Parallel query server kill event
10371   Disable TQ hint
10372   Parallel query server kill event proc
10373   Parallel query server kill event
10374   Parallel query server interrupt (validate lock value)
10375   Turn on checks for statistics rollups
10376   Turn on table queue statistics
10377   Turn off load balancing
10378   Force hard process/range affinity
10379   Direct read for rowid range scans (unimplemented)
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
10396   Circumvent range table queues for queries
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
10410   Trigger simulated communications errors in KSXP
10411   Simulate errors in IMR
10412   Trigger simulated errors in CGS/CM interface
10425   Enable global enqueue service open event trace
10426   Enable global enqueue service convert event trace
10427   Enable global enqueue service traffic controller event trace
10428   Enable tracing of global enqueue service distributed resource
10429   Enable tracing of global enqueue service IPC calls
10430   Enable tracing of global enqueue service AST calls
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 muliple LMS
10435   Enable tracing of global enqueue service deadlock detetction
10450   Signal ctrl-c in kdddca (drop column) after n rows
10500   Turn on traces for SMON
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
10515   Turn on event to use physical cleanout
10550   Signal error during create as select/create index after n rows
10560   Block type '%s'
10561   Block type '%s', data object# %s
10562   Error occurred while applying redo to data block (file# %s, block# %s)
10563   Test recovery had to corrupt data block (file# %s, block# %s) in order to proceed
10564   Tablespace %s
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# %s, block# %s)
10568   Failed to allocate recovery state object: out of SGA memory
10570   Test recovery complete
10571   Test recovery canceled
10572   Test recovery canceled due to errors
10573   Test recovery tested redo from change %s to %s
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 %s 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   Can only allow 1 corruption for normal media/standby recovery
10589   Test recovery had to corrupt %s 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)
10602   Cause an access violation (for testing purposes)
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 this tablespace
10618   Operation not allowed on this segment
10619   Avoid assertions when possible
10620   Operation not allowed on this segment
10621   Data block does not belong to the segment
10622   Test/trace online index (re)build
10623   Enable Index range scan Prefetch - testing only
10650   Disable cache-callback optimisation
10651   Incorrect file number block number specified
10666   Do not get database enqueue name
10667   Cause sppst to check for valid process ids
10690   Set shadow process core file dump type (Unix only)
10691   Set background process core file type (Unix only)
10700   Alter access violation exception handler
10701   Dump direct loader index keys
10702   Enable histogram data generation
10703   Simulate process death during enqueue get
10704   Print out information about what enqueues are being obtained
10705   Print Out Tracing information for every I/O done by ODSs
10706   Print out information about global enqueue manipulation
10707   Simulate process death for instance registration
10708   Print out Tracing information for skxf multi instance comms
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
10722   Set parameters for CPU frequency calculation (debug)
10723   Internal testing - release buffer for buffer cache shrink
10730   Trace row level security policy predicates
10731   Dump SQL for CURSOR expressions
10740   Disables fix for bug 598861
10750   Test rollback segment blksize guessing for index array insert
10800   Disable Smart Disk scan
10801   Enable Smart Disk trace
10802   Reserved for Smart Disk
10803   Write timing statistics on cluster database recovery scan
10804   Reserved for ksxb
10806   Switch to 7.3 mode when detaching sessions
10807   Disable user id check when switching to a global transaction
10810   Trace snapshot too old
10811   Trace block cleanouts
10812   Trace Consistent Reads
10830   Trace group by sort row source
10841   Default un-inintialized charact set form to SQLCS_IMPLICIT
10850   Enable time manager tracing
10851   Allow Drop command to drop queue tables
10852   Enable dumping of the AQ statistics hash table
10853   Event for AQ statistics latch cleanup testing
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
10900   Extent manager fault insertion event #%s
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
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
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
10934   Reserved. Used only in version 7.x.
10935   Reserved. Used only in version 7.x.
10936   Trace name context forever
10937   Trace name context forever
10938   Trace name context forever
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
10975   Trace execution of parallel propagation
10976   Internal package related tracing
10977   Trace event for RepAPI
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   Do not 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
10999   Do not get database enqueue name
10999   End Pseudo-error debugging events