诊断事件按作用大概可分为四种:
1.Dump diagnostic information on request立即转储诊断信息,可以是File headers (control file, redo log files, data files),System state dumps,Process state dumps.
它的event name是固定的immediate,trace name是具体转储内容<dump>.
立即转储一般使用alter session set events 'immediate trace name <dump> level <n>'或者oradebug dump <dump> <level>或者sys.dbms_system.set_ev(sid,serial#,65535,<level>,'<dump>').
2.Dump diagnostic information when an error occurs根据指定的错误号触发转储信息.
它的event name是错误号Error#,trace name是固定的errorstack.
错误触发转储一般使用参数文件event = "<error> trace name errorstack level <n>"或者alter session set events '<error> trace name errorstack level <level>'或者oradebug event <error> trace name errorstack level <level>
3.Change database behavior改变数据库运行行为.
它的event name是事件号Event#,trace name是固定的context.
改变数据库运行行为一般使用参数文件event = "<event> trace name context forever,level <level>"或者alter system set event ="<event> trace name context forever,level <level>" scope=spfile
4.Produce trace diagnostics as the database runs产生数据库运行的诊断信息.
它的event name是事件号Event#,trace name是固定的context.
产生数据库运行的诊断信息一般使用参数文件event = "<event> trace name context forever,level <level>"或者alter session/system set event ="<event> trace name context forever,level <level>"
设定诊断事件的方法也可分为四种:
1.The event initialization parameter在pfile初始化参数文件中设定诊断事件.
在参数文件中设定诊断事件,如果要设定多个事件,可以用多个event,event之间要连续(若不连续,只会最后一个event生效),例如:
event = "10015 trace name context forever"
event = "10046 trace name context forever, level 4"
也可以用一个event,用:隔开,例如:
event = "10015 trace name context forever:10046 trace name context forever, level 4"
2.The ALTER {SESSION|SYSTEM} SET EVENTS command通过alter session/system设定诊断事件.
alter system设定的诊断事件是会写到spfile上的.若要取消可以通过alter system reset event scope=spfile.
3.The sys.dbms_system.set_ev(…) procedure通过dbms_system包设定诊断事件.
sys.dbms_system.set_ev格式execute sys.dbms_system.set_ev(sid,serial#,event,level,action),例如:
execute sys.dbms_system.set_ev(8, 219, 10046, 12, '');
4.The ORADEBUG utility通过oradebug命令设定诊断事件.
oradebug命令功能强大,以下是命令help
SQL> oradebug help
HELP [command] Describe one or all commands
SETMYPID Debug current process
SETOSPID <ospid> Set OS pid of process to debug
SETORAPID <orapid> ['force'] Set Oracle pid of process to debug
SETORAPNAME <orapname> Set Oracle process name to debug
SHORT_STACK Get abridged OS stack
CURRENT_SQL Get current SQL
DUMP <dump_name> <lvl> [addr] Invoke named dump
PDUMP [interval=<interval>] Invoke named dump periodically
[ndumps=<count>] <dump_name> <lvl> [addr]
DUMPSGA [bytes] Dump fixed SGA
DUMPLIST Print a list of available dumps
EVENT <text> Set trace event in process
SESSION_EVENT <text> Set trace event in session
DUMPVAR <p|s|uga> <name> [level] Print/dump a fixed PGA/SGA/UGA variable
DUMPTYPE <address> <type> <count> Print/dump an address with type info
SETVAR <p|s|uga> <name> <value> Modify a fixed PGA/SGA/UGA variable
PEEK <addr> <len> [level] Print/Dump memory
POKE <addr> <len> <value> Modify memory
WAKEUP <orapid> Wake up Oracle process
SUSPEND Suspend execution
RESUME Resume execution
FLUSH Flush pending writes to trace file
CLOSE_TRACE Close trace file
TRACEFILE_NAME Get name of trace file
SETTRACEFILEID <identifier name> Set tracefile identifier
LKDEBUG Invoke global enqueue service debugger
NSDBX Invoke CGS name-service debugger
-G <Inst-List | def | all> Parallel oradebug command prefix
-R <Inst-List | def | all> Parallel oradebug prefix (return output
SETINST <instance# .. | all> Set instance list in double quotes
SGATOFILE <SGA dump dir> Dump SGA to file; dirname in double quotes
DMPCOWSGA <SGA dump dir> Dump & map SGA as COW; dirname in double quotes
MAPCOWSGA <SGA dump dir> Map SGA as COW; dirname in double quotes
HANGANALYZE [level] [syslevel] Analyze system hang
FFBEGIN Flash Freeze the Instance
FFDEREGISTER FF deregister instance from cluster
FFTERMINST Call exit and terminate instance
FFRESUMEINST Resume the flash frozen instance
FFSTATUS Flash freeze status of instance
SKDSTTPCS <ifname> <ofname> Helps translate PCs to names
WATCH <address> <len> <self|exist|all|target> Watch a region of memory
DELETE <local|global|target> watchpoint <id> Delete a watchpoint
SHOW <local|global|target> watchpoints Show watchpoints
DIRECT_ACCESS <set/enable/disable command | select query> Fixed table access
IPC Dump ipc information
UNLIMIT Unlimit the size of the trace file
CALL [-t count] <func> [arg1]...[argn] Invoke function with arguments
CORE Dump core without crashing process
PROCSTAT Dump process statistics
#可使用的dump项
SQL> oradebug dumplist
ADJUST_SCN
ALRT_TEST
ARCHIVE_ERROR
ASHDUMP
ASHDUMPSECONDS
ASM_EVENREAD
ASMDISK_ERR_OFF
ASMDISK_ERR_ON
ASMDISK_READ_ERR_ON
ATSK_TEST
AWR_FLUSH_TABLE_OFF
AWR_FLUSH_TABLE_ON
AWR_TEST
BC_SANITY_CHECK
BG_MESSAGES
BLK0_FMTCHG
BUFFER
BUFFERS
CALLSTACK
CGS
CHECK_ROREUSE_SANITY
CONTEXTAREA
CONTROLF
CROSSIC
CRS
CSS
CURSOR_STATS
CURSORDUMP
CURSORTRACE
DATA_ERR_OFF
DATA_ERR_ON
DATA_READ_ERR_ON
DBSCHEDULER
DEAD_CLEANUP_STATE
DROP_SEGMENTS
DUMP_ADV_SNAPSHOTS
DUMP_ALL_COMP_GRANULE_ADDRS
DUMP_ALL_COMP_GRANULES
DUMP_ALL_OBJSTATS
DUMP_ALL_REQS
DUMP_PINNED_BUFFER_HISTORY
DUMP_TEMP
DUMP_TRANSFER_OPS
DUMPGLOBALDATA
ENQUEUES
ERRORSTACK
EVENT_TSM_TEST
EXCEPTION_DUMP
FAILOVER
FBHDR
FBINC
FBTAIL
FILE_HDRS
FLASHBACK_GEN
FLUSH_CACHE
FLUSH_JAVA_POOL
FULL_DUMPS
GC_ELEMENTS
GES_STATE
GIPC
GLOBAL_AREA
GLOBAL_BUFFER_DUMP
HANGANALYZE
HANGANALYZE_GLOBAL
HANGANALYZE_PROC
HANGDIAG_HEADER
HEAPDUMP
HEAPDUMP_ADDR
HM_FDG_VERS
HM_FW_TRACE
HNGDET_MEM_USAGE_DUMP
INSTANTIATIONSTATE
IOERREMUL
IOERREMULRNG
IR_FW_TRACE
JAVAINFO
KCB_WORKING_SET_DUMP
KCBI_DUMP_FREELIST
KCBO_OBJ_CHECK_DUMP
KCBS_ADV_INT_DUMP
KDLIDMP
KRA_OPTIONS
KRA_TRACE
KRB_BSET_DAYS
KRB_CORRUPT_INTERVAL
KRB_CORRUPT_OFFSET
KRB_CORRUPT_REPEAT
KRB_CORRUPT_SIZE
KRB_CORRUPT_SPBAD_INTERVAL
KRB_CORRUPT_SPBAD_REPEAT
KRB_CORRUPT_SPBITMAP_INTERVAL
KRB_CORRUPT_SPBITMAP_REPEAT
KRB_CORRUPT_SPHEADER_INTERVAL
KRB_CORRUPT_SPHEADER_REPEAT
KRB_FAIL_INPUT_FILENO
KRB_OPTIONS
KRB_OVERWRITE_ACTION
KRB_PIECE_FAIL
KRB_SET_TIME_SWITCH
KRB_SIMULATE_NODE_AFFINITY
KRB_TRACE
KRB_UNUSED_OPTION
KRBABR_TRACE
KRBMROR_LIMIT
KRBMRSR_LIMIT
KRC_TRACE
KRDRSBF
KSDTRADV_TEST
KSFQP_LIMIT
KSKDUMPTRACE
KSTDUMPALLPROCS
KSTDUMPALLPROCS_CLUSTER
KSTDUMPCURPROC
KTPR_DEBUG
KUPPLATCHTEST
KXFPBLATCHTEST
KXFPCLEARSTATS
KXFPDUMPTRACE
KXFRHASHMAP
KXFXCURSORSTATE
KXFXSLAVESTATE
LATCHES
LDAP_KERNEL_DUMP
LDAP_USER_DUMP
LIBRARY_CACHE
LIBRARY_CACHE_OBJECT
LISTENER_REGISTRATION
LOCKS
LOGERROR
LOGHIST
LONGF_CREATE
MMAN_ALLOC_MEMORY
MMAN_CREATE_DEF_REQUEST
MMAN_CREATE_IMM_REQUEST
MMAN_IMM_REQUEST
MMON_TEST
MODIFIED_PARAMETERS
NEXT_SCN_WRAP
OBJECT_CACHE
OCR
OLAP_DUMP
OPEN_FILES
PGA_DETAIL_CANCEL
PGA_DETAIL_DUMP
PGA_DETAIL_GET
PGA_SUMMARY
PIN_BLOCKS
PIN_RANDOM_BLOCKS
POKE_ADDRESS
POKE_LENGTH
POKE_VALUE
POKE_VALUE0
POOL_SIMULATOR
PROCESSSTATE
REALFREEDUMP
RECORD_CALLSTACK
RECOVERY
REDOHDR
REDOLOGS
REFRESH_OS_STATS
ROW_CACHE
RULESETDUMP
RULESETDUMP_ADDR
SAVEPOINTS
SCN_AUTO_ROLLOVER_TS_OVERRIDE
SELFTESTASM
SET_NBLOCKS
SET_TSN_P1
SHARED_SERVER_STATE
SIMULATE_EOV
SQLNET_SERVER_TRACE
SYSTEMSTATE
SYSTEMSTATE_GLOBAL
TEST_DB_ROBUSTNESS
TEST_GET_CALLER
TEST_SPACEBG
TEST_STACK_DUMP
TR_CORRUPT_ONE_SIDE
TR_CRASH_AFTER_WRITE
TR_READ_ONE_SIDE
TR_RESET_NORMAL
TR_SET_ALL_BLOCKS
TR_SET_BLOCK
TR_SET_SIDE
TRACE_BUFFER_OFF
TRACE_BUFFER_ON
TREEDUMP
UPDATE_BLOCK0_FORMAT
WORKAREATAB_DUMP
XS_SESSION_STATE
oracle错误号的10000~10999是诊断事件号,可在$ORACLE_HOME/rdbms/mesg/oraus.msg中查看.
10000, 00000, "control file debug event, name 'control_file'"
10001, 00000, "control file crash event1"
10002, 00000, "control file crash event2"
10003, 00000, "control file crash event3"
10004, 00000, "block recovery testing - internal error"
10005, 00000, "trace latch operations for debugging"
Enable tracing for various latch operations
*Comment:
level 1 - trace latch gets and frees
level 2 - protectunprotect latch recovery areas
level 4 - trace multiple posts by processes when latch is freed
level 8 - signal error on bad latch waits
10006, 00000, "block recovery testing - external error"
10007, 00000, "log switch debug crash after new log select, thread %s"
level 1 - closed thread only
level 2 - open thread only
level 3 - open or closed thread
10008, 00000, "log switch debug crash after new log header write, thread %s"
level 1 - closed thread only
level 2 - open thread only
level 3 - open or closed thread
10009, 00000, "log switch debug crash after old log header write, thread %s"
level 1 - closed thread only
level 2 - open thread only
level 3 - open or closed thread
10010, 00000, "Begin Transaction"
10011, 00000, "End Transaction"
10012, 00000, "Abort Transaction"
10013, 00000, "Instance Recovery"
10014, 00000, "Roll Back to Save Point"
10015, 00000, "Undo Segment Recovery"
10016, 00000, "Undo Segment extend"
10017, 00000, "Undo Segment Wrap"
10018, 00000, "Data Segment Create"
10019, 00000, "Turn off dataspace search cache"
10020, 00000, "partial link restored to linked list (KSG)"
10021, 00000, "KST event to trace control file header writes and reads"
Not set by default.
10022, 00000, "trace ktsgsp"
10023, 00000, "Create Save Undo Segment"
10024, 00000, "Write to Save Undo"
10025, 00000, "Simulate block recovery errors"
*Cause:
*Action: The level is a bitmask that can be used as follows:
0x0001 -- Corruption on first attempt to get previous block version
10026, 00000, "Apply Save Undo"
10027, 00000, "Specify Deadlock Trace Information to be Dumped"
The level is a bitmask that can be used as follows:
0x01 - Do NOT produce a processstate (default is to dump this)
0x02 - Dump a systemstate
0x04 - Dump short stacks of all processes
10028, 00000, "Dump trace information during lock resource latch cleanup"
The level is a bitmask that can be used as follows:
0x01 - Dump information during resource cleanup
0x02 - Dump information during lock cleanup
10029, 00000, "session logon (KSU)"
10030, 00000, "session logoff (KSU)"
10031, 00000, "sort debug event (S*)"
*Cause:
*Action: Set this event only under the supervision of Oracle development.
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Trace sort auto memory management requirements
0x0002 Dump sort subheaps before freeing or resetting
0x0004 Trace use of new vs old sort
0x0008 Reserved for sort IO tracing
0x0010 Disable storing duplicates in linked list (also disables
part of top n rank optimization)
0x0020 Trace cluster-by-rowid (CBRID) sort
10032, 00000, "sort statistics (SOR*)"
Set this event only under the supervision of Oracle development.
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x01 Output sort statistics in the trace file at the end of sort.
0x02 Level 1 plus print more information as the sort progresses.
0x04 Level 2 plus dump extra information (track IOs).
10033, 00000, "sort run information (SRD*SRS*)"
10034, 00000, "access path analysis (APA*)"
10035, 00000, "Write parse failures to alert log file"
*Cause:
10036, 00000, "create remote row source (QKANET)"
10037, 00000, "allocate remote row source (QKARWS)"
10038, 00000, "dump row source tree (QBADRV)"
10039, 00000, "type checking (OPITCA)"
10040, 00000, "disable result-cache"
10041, 00000, "dump undo records skipped"
10042, 00000, "file header reads return youngest mirror"
10043, 00000, "check consistency of ownerwaiterconverter lists in KSQ"
10044, 00000, "free list undo operations"
10045, 00000, "free list update operations - ktsrsp, ktsunl"
10046, 00000, "enable SQL statement timing"
10047, 00000, "trace switching of sessions"
10048, 00000, "Undo segment shrink"
10049, 00000, "protect library cache memory heaps"
Use the OS memory protection (if available) to protect library
cache memory heaps that are pinned.
10050, 00000, "sniper trace"
10051, 00000, "trace OPI calls"
10052, 00000, "don't clean up obj$"
10053, 00000, "CBO Enable optimizer trace"
10054, 00000, "CBO Enable optimizer trace for recursive statement (RPI)"
10056, 00000, "dump analyze stats (kdg)"
10057, 00000, "suppress file names in error messages"
10058, 00000, "use table scan cost in tab$.spare1"
10059, 00000, "simulate error in logfile createclear"
10060, 00000, "CBO Enable predicate dump"
10061, 00000, "disable SMON from cleaning temp segment"
10062, 00000, "disable usage of OS Roles in osds"
10063, 00000, "disable usage of DBA and OPER privileges in osds"
10064, 00000, "thread enable debug crash level %s, thread %s"
level 1 - after new current log header written
level 2 - after current log committed
level 3 - after redo generation complete
10065, 00000, "limit library cache dump information for state object dump"
level 1 - minimal (only the address of state objects)
level 2 - little more (no object details)
level 3 - normal
10066, 00000, "simulate failure to verify file"
level is file number to fail verification
10067, 00000, "force redo log checksum errors - block number"
level is block number to corrupt
10068, 00000, "force redo log checksum errors - file number"
level is file number to corrupt
10070, 00000, "force datafile checksum errors - block number"
level is block number to corrupt
10071, 00000, "force datafile checksum errors - file number"
level is file number to corrupt
10072 is available.
10073, 00000, "latch cleanup tracing"
Enable latch cleanup tracing.
*Comment:
level 1 - PMON cleanup, in-flux latches only
level 2 - PMON cleanup, all latches
level 3 - all cleanup
10074, 00000, "default trace function mask for kst"
10075, 00000, "CBO Disable outer-join to regular join conversion"
10076, 00000, "CBO Enable cartesian product join costing"
10077, 00000, "CBO Disable view-merging optimization for outer-joins"
10078, 00000, "CBO Disable constant predicate elimination optimization"
10079, 00000, "trace data sentreceived via SQL*Net"
level 1 - trace network ops tofrom client
level 2 - in addition to level 1, dump data
level 4 - trace network ops tofrom dblink
level 8 - in addition to level 4, dump data
10080, 00000, "dump a block on a segment list which cannot be exchanged"
At level > 1, dump the block
At level > 5, dump the stack
At level > 10, unlink the block
10081, 00000, "segment High Water Mark has been advanced"
10082, 00000, "free list head block is the same as the last block"
At level > 1, dump the block
At level > 5, dump the stack
10084, 00000, "free list becomes empty"
10085, 00000, "free lists have been merged"
10086, 00000, "CBO Enable error if kko and qka disagree on oby sort"
10087, 00000, "disable repair of media corrupt data blocks"
10088, 00000, "CBO Disable new NOT IN optimization"
10089, 00000, "CBO Disable index sorting"
10090, 00000, "invoke other events before crash recovery"
10091, 00000, "CBO Disable constant predicate merging"
10092, 00000, "CBO Disable hash join"
10093, 00000, "CBO Enable force hash joins"
10094, 00000, "before resizing a data file"
10095, 00000, "dump debugger commands to trace file"
10096, 00000, "after the cross instance call when resizing a data file"
10097, 00000, "after generating redo when resizing a data file"
10098, 00000, "after the OS has increased the size of a data file"
10099, 00000, "after updating the file header with the new file size"
10100, 00000, "after the OS has decreased the size of a data file"
10101, 00000, "DBWR refresh fails on cross instance resize call"
10102, 00000, "switch off anti-joins"
10103, 00000, "CBO Disable hash join swapping"
10104, 00000, "dump hash join statistics to trace file"
10105, 00000, "CBO Enable constant pred trans and MPs w WHERE-clause"
10106, 00000, "CBO Disable evaluating correlation pred last for NOT IN"
10107, 00000, "CBO Always use bitmap index"
10108, 00000, "CBO Don't use bitmap index"
10109, 00000, "CBO Disable move of negated predicates"
10110, 00000, "CBO Try index rowid range scans"
10111, 00000, "Bitmap index creation switch"
10112, 00000, "Bitmap index creation switch"
10113, 00000, "Bitmap index creation switch"
10114, 00000, "Bitmap index creation switch"
10115, 00000, "CBO Bitmap optimization use maximal expression"
10116, 00000, "CBO Bitmap optimization switch"
10117, 00000, "CBO Disable new parallel cost model "
10118, 00000, "CBO Enable hash join costing "
10119, 00000, "QKA Disable GBY sort elimination"
10120, 00000, "generate relative file # different from absolute"
10121, 00000, "CBO Don't sort bitmap chains"
10122, 00000, "Disable transformation of count(col) to count(*)"
10124, 00000, "Force creation of segmented arrays by kscsAllocate"
10125, 00000, "Disable remote sort elimination"
10126, 00000, "Debug oracle java xa"
10127, 00000, "Disable remote query block operation"
10128, 00000, "Dump Partition Pruning Information"
set this event only under the supervision of Oracle development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump pruning decriptor for each partitioned object
0x0002 dump partition iterators
0x0004 dump optimizer decisions about partition-wise join
0x0008 dump rowid range scan pruning information
10129, 00000, "Alter histogram lookup for remote queries"
10130, 00000, "sort disable readaheads"
10131, 00000, "CONNECT BY debug event"
Set this event only under the supervision of Oracle development.
Trace level is a bit field.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Enable use of CONNECT BY cost-based transformation for
queries with subqueries in the START WITH clause
0x0002 Enable use of CONNECT BY cost-based transformation for
queries with subqueries in the CONNECT BY clause
0x0004 Do filtering only (print rows produced by filtering stage)
10132, 00000, "dump plan after compilation"
set this event only under the supervision of Oracle development
10133, 00000, "testing for SQL Memory Management"
never set this event
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 do not unregister work areas at instance level
10134, 00000, "tracing for SQL Memory Management for session"
never set this event
This event can be turned on globally by seting trace name sqlmem_tracing
with the same set of levels with bit one set to 1
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Not used (used for global setting)
0x0002 IMM level registerunregister
10135, 00000, "CBO do not count 0 rows partitions"
10136, 00000, "CBO turn off fix for bug 1089848"
10137, 00000, "CBO turn off fix for bug 1344111"
10138, 00000, "CBO turn off fix for bug 1577003"
10139, 00000, "CBO turn off fix for bug 1386119"
10140, 00000, "CBO turn off fix for bug 1332980"
10141, 00000, "CBO disable additional keys for inlist in bitmap optimization"
10142, 00000, "CBO turn off advanced OR-expansion checks"
10143, 00000, "CBO turn off hints"
10144, 00000, "CBO turn off cost based selection of bji over bsj subquery"
10145, 00000, "test auditing network errors"
10146, 00000, "enable Oracle TRACE collection"
*Comment: This event is obsoleted, and can be reused for some other purpose
although some customer applications which used to rely on
Oracle Trace may still have it enabled by mistake
10147, 00000, "enable join push through UNION view"
10149, 00000, "allow the creation of constraints with illegal date constants"
10150, 00000, "import exceptions"
This should never be set by users. It is used by import to
allow certain commands to succeed, when for normal users they
would fail. An example is to allow grants on invalid views.
10152, 00000, "CBO don't consider function costs in plans"
10153, 00000, "Switch to use public synonym if private one does not translate"
10154, 00000, "Switch to disallow synonyms in DDL statements"
10155, 00000, "CBO disable generation of transitive OR-chains"
10156, 00000, "CBO disable index fast full scan"
10157, 00000, "CBO disable index access path for in-list"
10158, 00000, "CBO preserve predicate order in post-filters"
10159, 00000, "CBO disable order-by sort pushdown into domain indexes"
10160, 00000, "CBO disable use of join index"
10161, 00000, "CBO recursive semi-join onoff-switch"
10162, 00000, "CBO join-back elimination onoff-switch"
10163, 00000, "CBO join-back elimination onoff-switch"
10164, 00000, "CBO disable subquery-adjusted cardinality fix"
10165, 00000, "mark session for special handling during instance administration"
Turn on this event in a session to mark the session as special
so that it can be either killed or ignored during instance
administration operations such as shutdown normal and standby
role transitions.
It is provided for the Oracle Enterprise Manager an other similar
tools.
The level is interpreted as follows
LEVEL ACTION
---------------------------------------------------------------------------
0 Treat this session as a normal session. This clears the
special bits which may have been set by other levels of this
event.
1 Kill this session during shutdown normal
2 Ignore this session during database close
3 Ignore this session during standby role transitions
>= 4 Reserved for future use
10166, 00000, "trace long operation statistics updates"
10167, 00000, "CBO use old index MINMAX optimization"
10168, 00000, "CBO disable single-table predicate predicate generation"
10169, 00000, "CBO disable histograms for multi partitions"
10170, 00000, "CBO use old bitmap costing"
10171, 00000, "CBO disable transitive join predicates"
10172, 00000, "CBO force hash join back"
10173, 00000, "Dynamic Sampling time-out error"
10174, 00000, "view join-back elimination switch"
10175, 00000, "CBO star transformation switch"
10176, 00000, "CBO colocated join switch"
10177, 00000, "CBO colocated join switch"
10178, 00000, "CBO turn off hash cluster filtering through memcmp"
10179, 00000, "CBO turn off transitive predicate replacement"
10180, 00000, "temp table transformation print error messages"
10181, 00000, "CBO disable multi-column in-list processing"
10182, 00000, "CBO disable generation of implied predicates"
10183, 00000, "CBO disable cost rounding"
10184, 00000, "CBO disable OR-exp if long inlist on bitmap column"
10185, 00000, "CBO force index joins"
10186, 00000, "CBO disable index join"
10187, 00000, "CBO additional index join switch"
10188, 00000, "CBO additional index join switch"
10189, 00000, "CBO turn off FFS null fix"
10190, 00000, "Analyze use old frequency histogram collection and density"
10191, 00000, "Avoid conversion of in-lists back to OR-expanded form"
10192, 00000, "nopushdown when number of groups exceed number of rows"
10193, 00000, "Force repeatable sampling with specified seed"
10194, 00000, "CBO disable new LIKE selectivity heuristic"
10195, 00000, "CBO don't use check constraints for transitive predicates"
10196, 00000, "CBO disable index skip scan"
10197, 00000, "CBO force index skip scan"
10199, 00000, "set parameter in session"
10200, 00000, "consistent read buffer status"
10201, 00000, "consistent read undo application"
10202, 00000, "consistent read block header"
10203, 00000, "block cleanout"
10204, 00000, "signal recursive extend"
10205, 00000, "row cache debugging"
At level 1, KQR will dump out latch clean-up debugging traces.
At level 2, KQR will dump out bootstrap debugging traces.
At level 3, KQR will invalidate, remove from the cache and put 0xff's
in row cache objects that are not currently locked.
10206, 00000, "transaction table consistent read"
10207, 00000, "consistent read transactions' status report"
10208, 00000, "consistent read loop check"
10209, 00000, "enable simulated error on control file"
Enables event 10214 to signal an error for a specific file. Level
is the number of the file to enable them for (file number order from
INIT.ORA file). A level greater than the maximum control file multiplexing
factor will signal error for all files.
10210, 00000, "check data block integrity"
10212, 00000, "check cluster integrity"
10213, 00000, "crash after control file write"
10214, 00000, "simulate write errors on control file"
A level of 1-9 simulates write errors on physical blocks 1-9.
If level >= 10 every control file write will force an error.
10215, 00000, "simulate read errors on control file"
For errors 10213,10214, and 10215
level 1 is for header
level 2 is for shared info
level >2 is any other block
No error 10214 will be simulated unless event 10209 is also set to enable
error simulation on that file
10216, 00000, "dump control file header"
10217, 00000, "debug sequence numbers"
10218, 00000, "dump uba of applied undo"
10219, 00000, "monitor multi-pass row locking"
10220, 00000, "show updates to the transaction table"
10221, 00000, "show changes done with undo"
10222, 00000, "row cache"
10223, 00000, "transaction layer - turn on verification codes"
10224, 00000, "index block splitdelete trace"
10225, 00000, "freeused extent row cache"
10226, 00000, "trace CR applications of undo for data operations"
*Cause:
*Action:
10227, 00000, "verify (multi-piece) row structure"
10228, 00000, "trace application of redo by kcocbk"
10229, 00000, "simulate IO error against datafiles"
10230, 00000, "KSFD block repair test event"
Each level is dedicated to a particular ksfd client. When this
event is set, clients corresponding to the level simulate block
verification failure.
10231, 00000, "skip corrupted blocks on _table_scans_"
such blocks are skipped in table scans, and listed in trace files
10232, 00000, "dump corrupted blocks symbolically when kcbgotten"
puts corrupted block in trace file
10233, 00000, "skip corrupted blocks on index operations"
skip corrupted data andor index blocks during index scans.
information is logged to a trace file.
10234, 00000, "trigger event after calling kcrapc to do redo N times"
creates a file named 'crash'
10235, 00000, "check memory manager internal structures"
10236, 00000, "dump redo on object no. or block type mismatch errors 14108103"
10237, 00000, "simulate ^C (for testing purposes)"
10238, 00000, "instantiation manager"
10239, 00000, "multi-instance library cache manager"
10240, 00000, "dump dba's of blocks that we wait for"
10241, 00000, "remote SQL execution tracingvalidation"
Level > 0 dump SQL generated for remote execution (OPIX)
Level > 1 validate RPCs in SELECT statements
10242, 00000, "suppress OER 2063 (for testing distrib wo different error log)"
10243, 00000, "simulated error for test %s of K2GTAB latch cleanup"
*Cause: levels 1..6 for insert, 7..11 for delete
*Action:
10244, 00000, "make tranids in error msgs print as 0.0.0 (for testing)"
*Cause: also makes "alter system enable distributed recovery" synchronous
*Action:
10245, 00000, "Testing event used by server IO ksfdksfq module"
10246, 00000, "print trace of PMON actions to trace file"
10247, 00000, "Turn on scgcmn tracing. (VMS ONLY)"
LEVEL ACTION
---------------------------------------------------------------------------
>= 1 Print lock name, action, mode, comp ast, bast, timeout, val?
>= 2 print Success code of request (NORMAL, SYNCH, or NOTQUEUED)
>= 3 print Value block
>= 5 Print delta CPU and elapsed times.
>= 100 stack dump at level 100-<given_level>.
10248, 00000, "turn on tracing for dispatchers"
10249, 00000, "turn on tracing for multi-stated servers"
10250, 00000, "Trace all allocate and free calls to the topmost SGA heap"
10251, 00000, "check consistency of transaction table and undo block"
MERGE: 10235 RENUMBERED TO 10251
10252, 00000, "shared IO pool error simulation"
level specifies number of IOs after which an error will be simulated
10253, 00000, "limit SQL text returned from X$KGLNA[1]"
level specifies the maximum SQL string length to be returned
10254, 00000, "trace cross-instance calls"
10255, 00000, "plsql parse checking"
sends all dml statements to plsql for parse and semantic check
10256, 00000, "shared server debug event"
10257, 00000, "trace shared server load balancing"
10258, 00000, "force shared servers to be chosen round-robin"
10259, 00000, "get error message text from remote using explicit call"
*Cause: for npigem coverage testing (normally called only for V5 remote)
*Action:
10260, 00000, "limit size (%s) of the PGA heap set by event 10261 exceeded"
*Cause: The PGA memory use exceeded the limit set by the event 10261.
*Action: Check event 10261 settings.
10261, 00000, "Limit the size of the PGA heap"
*Cause: the limit is one kilobyte times the level of the event. If the
pga grows bigger than this signal an internal error.
*Action:
10262, 00000, "Don't check for memory leaks"
*Cause: Setting this event to level one causes memory leak checking to
be disabled. Setting this event to any other non-zero number
allows that number to be used as a threshold value when checking
for memory leaks in the PGA, SGA, and UGA heaps.
*Action:
10263, 00000, "Don't free empty PGA heap extents"
*Cause: This is useful for debugging since watchpoints are lost on free
*Action:
10265, 00000, "Keep random system generated output out of error messages"
*Cause: so test system files don't diff
*Action:
10266, 00000, "Trace OSD stack usage"
*Cause: Porters should implement this to help them debug
their stack implementations. It should be used in at least
smcstk().
*Action:
10267, 00000, "Inhibit KSEDMP for testing"
*Cause: Some tests may generate internal or fatal errors on purpose.
This event can limit the size of tracefile produced for such
tests.
*Action: LEVEL used by KSEDMP is one less than level of this event.
10268, 00000, "Don't do forward coalesce when deleting extents"
*Cause: setting this event keeps kts from coalescing forward at each
extent when dropping a temp segment.
*Action:
10269, 00000, "Don't do coalesces of free space in SMON"
*Cause: setting this event prevents SMON from doing free space coalesces
10270, 00000, "Debug shared cursors"
*Cause: Enables debugging code in shared cursor management modules
*Action:
10271, 00000, "distributed transaction after COLLECT"
10272, 00000, "distributed transaction before PREPARE"
10273, 00000, "distributed transaction after PREPARE"
10274, 00000, "distributed transaction before COMMIT"
10275, 00000, "distributed transaction after COMMIT"
10276, 00000, "distributed transaction before FORGET"
10277, 00000, "Cursor sharing (or not) related event (used for testing)"
10278, 00000, "Internal testing"
10279, 00000, "Simulate block corruption in kdb4chk"
10280, 00000, "Internal testing - segmentation fault during crash recovery"
10281, 00000, "maximum time to wait for process creation"
*Cause: used to override the default SPMXWAIT, level = timeout in sec.
*Action:
10282, 00000, "Inhibit signalling of other backgrounds when one dies"
*Cause: Used in KSB
*Action:
10284, 00000, "simulate zeroinfinite asynch IO buffering"
*Cause: Used in KCF, level=1 out of space (red), level=2 infinite (green)
*Action:
10285, 00000, "Simulate control file header corruption"
If set, will cause control file header verification to fail
10286, 00000, "Simulate control file open error"
If set, will cause the next control file open to have an error
10287, 00000, "Simulate archiver error"
If set, next archive log will generate error
10288, 00000, "Do not check block type in ktrget"
If set, don't do type check in ktrget. This is a work-around
for databases that have 0 as block type in some data blocks.
10289, 00000, "Do block dumps to trace file in hex rather than fromatted"
If set, don't do formatted block dumps. This is a work-around
for block dump routines that accvio when given badly corrupted
blocks. It may also be useful for cases where the type is wrong.
10290, 00000, "Internal sequence tracing event"
Internal Event - Should not be set unless directed by RDBMS DEV
10291, 00000, "die in tbsdrv to test control file undo"
If this event is set, error OERI(10291) is signalled when
issueing tablespace commands. The control file undo should be
applied returning the control file to its previous state.
10292, 00000, "hang analysis trace event"
Enable validation of hang analysis callbacks
*Comment: The following levels may be combined:
0x1 - dump errors to trace file through ksdwrf
0x2 - dump errors to trace file as ORA-600 + 0x1
0x4 - check for involuntary events without callbacks
10293, 0000, "trace log switch media recovery checkpoints"
Print alert log timestamps for the start and end of each log
switch checkpoint during media recovery. This timing may prove
useful in debugging recovery performance problems.
10294, 00000, "ksrpc tracing"
If this event is set then ksrpc module generates tracing on each
remote transfer
10295, 00000, "die after file header update durning cf xact"
If this event is set then some file header updates will
be followed by an error 10295 to abort the command before
the control file xact commits.
10296, 00000, "disable ORA-379"
If this event is set then we will not signal ORA-379 for
buffer cache deadlocks when all buffers in the cache
are pinned.
10297, 00000, "shared IO pool tracing"
If this event is set, then kcbi tracing is enabled. Internal use.
10298, 00000, "ksfd io tracing"
If this event is set then ksfd module generates tracing
for each io request
10299, 00000, "Trace prefetch tracking decisions made by CKPT"
10300, 00000, "Distributed transaction tracing"
Set this event only under the supervision of Oracle development
*Comment: This event will trace the history of KTD actions
level: 0 = always
If this event is set then the prefetch tracking decisions
made by the CKPT process are traced. The trace output is
written to that process' trace file.
10301, 0000, "Enable LCK timeout table consistency check"
10302 - 10318 Reserved for internal triggers
10302, 00000, "trace create or drop internal trigger"
10303, 00000, "trace loading of library cache for internal triggers"
10304, 00000, "trace replication trigger"
10305, 00000, "trace updatable materialized view trigger"
10306, 00000, "trace materialized view log trigger"
10307, 00000, "trace RepCat execution"
10308, 00000, "replication testing event"
10309, 00000, "Trigger Debug event"
*Comment: This event replaces the earlier event number 10250
which had multiple definitions
10310, 00000, "trace synchronous change table trigger"
10311, 00000, "Disable Flashback Table Timestamp checking"
10312, 00000, "Allow disable to log rows into the mapping table"
10314, 00000, "Enable extra stats gathering for CR"
10316, 00000, "Events for extensible txn header, non zero ext header size"
10317, 00000, "Events for extensible txn header, zero ext header size"
10318, 00000, "Trace extensible txn header movements"
10319, 00000, "Trace PGA statistics maintenance"
set this event only under the supervision of Oracle development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump message in trace file when PGA stats are diverging
0x0002 trace top-level PGA allocation and deallocation
0x0004 always check if fullincremental stats are in sync
10320, 0000, "Enable data layer (kdtgrs) tracing of space management calls"
10321, 0000, "Datafile header verification debug failure."
For testing purposes only. Simulates a datafile header
verification error.
10322, 00000, "CBO don't simplify inlist predicates"
10323, 0000, "before committing an add datafile command"
10324, 0000, "Enable better checking of redo logs errors"
Raises internal errors when there are redo log errors
*Comment: Raises internal errors when there are redo log errors
10325 - 10335 reserved for recovery testing
10325, 0000, "Trace control file record section expand and shrink operations"
trace control file record section expand and shrink operations to
the alert file
10326, 00000, "clear logfile debug crash at %s, log %s"
level 1 - after prepare, before clearing the log members
level 2 - after clearing the log members, before final cf xaction
level 3 - just before clearing member 1
level 4 - just before clearing member 2
10327, 00000, "simulate ORA-00235 error for testing"
10328, 00000, "disable first-to-mount split-brain error, for testing"
for testing only.
10329, 00000, "simulate out-of-memory error during first pass of recovery"
for testing only.
10330, 00000, "clear MTTR statistics in checkpoint progress record"
clear MTTR statistics in this thread
10331, 00000, "simulate resilvering during recovery"
for testing only.
10332, 00000, "force ALTER SYSTEM QUIESCE RESTRICTED command to fail"
for testing only.
10333, 00000, "dump MTTR statistics each time it is updated"
dump MTTR statistics in this thread each time it is updated
10334, 00000, "force FG to wait to be killed during MTTR advisory simulation"
for testing only.
10335, 00000, "trace database open status"
for debugging purpose
10336, 00000, "Do remote object transfer using remote SQL"
10337, 00000, "enable padding owner name in slave sql"
*Document: NO
*Cause: owner name is not padded by default in slave sql
*Action: pad owner name during generation of slave sql
*Comment: applicable only for explain plan queries(for testing purposes)
10338, 00000, "CBO don't use inlist iterator with function-based indexes"
10339, 00000, "CBO disable DECODE simplification"
10340, 00000, "Buffer queues sanity check for corrupted buffers"
*Document: NO
*Cause:
*Action: Check all buffer queues for corrupted buffer every 5 minutes
reserve events 10341 - 10350 for checkpoints
10341, 00000, "Simulate out of PGA memory in DBWR during object reuse"
checks that DBWR can still perform invalidatino
*Comment: only used during testing
10342, 00000, "Raise unknown exception in ACQ_ADD when checkpointing"
should cause process to dump trace file and die
*Comment: This event is obsoleted, and can be reused for another test.
10343, 00000, "Raise an out of memory exception-OER 4031 in ACQ_ADD"
For Backgrounds, try to handle checkpoint using reserved entries
*Comment: Only enabled during testing
10344, 00000, "reserved for simulating object hash reorganization"
Set this to trigger obj hash table reorg to simulate large number
of objects per hash buckets. Done by DBWR interrupt action.
10345, 00000, "validate queue when linking or unlinking a buffer"
checks low RBA ordering of queue associated with latch
*Comment: Raises an error if low RBA ordering on queue is wrong
10346, 00000, "check that all buffers for checkpoint have been written"
Scans the cache to see that all candidate buffers are written
*Comment: Usually only enabled for TESTING since it involves a cache scan
10347, 00000, "dump active checkpoint entries and checkpoint buffers"
Prints the checkpoint queue and buffers to the trace file
*Comment: Usually only enabled for TESTING and code coverage
10348, 00000, "test abnormal termination of process initiating file checkpoint"
Causes abnormal termination of process starting a file checkpoint
*Comment: Only enabled for TESTING and code coverage
10349, 00000, "do not allow ckpt to complete"
disables checkpoint completion
*Comment: only enabled for TESTING
10350, 00000, "Simulate more than one object & tsn id in object reuse"
checks that DBWR can service multiple object id's in reuse"
*Comment: only used during testing
reserve events 10351-10359 for direct asynchronous read path
10351, 00000, "size of slots"
sets the size of slots to use
*Comment: a slot is a unit of IO and this factor controls the size
*Comment: of the IO.
10352, 00000, "report direct path statistics"
turns on direct path statistics
*Comment: reports statistics for direct path
10353, 00000, "number of slots"
sets a given number of slots to use
*Comment: a slot is a unit of IO and this factor controls the number
*Comment: of outstanding IOs.
10354, 00000, "turn on direct read path for parallel query"
enable direct read for parallel query
10355, 00000, "turn on direct read path for scans"
enable direct async read for scans
10356, 00000, "turn on hint usage for direct read"
enables using hint for direct async reads
10357, 00000, "turn on debug information for direct path"
turn on debug information for direct path
10358, 00000, "Simulate out of PGA memory in cache advisory reset"
checks that CKPT can set the simulation to OFF
*Comment: only used during testing
10359, 00000, "turn off updates to control file for direct writes"
Control files won't get updated for direct writes for LOBs
when NOCACHE NOLOGGING is set. The only bad impact that it
can have is that if you are using the recovery manager,
it may affect a warning that says that the user should
back everything up. Now the recovery manager won't know
to tell you that the files that were updated with
unrecoverable events should be backed up.
reserve events 10360-10362 for debugging DBWR
10360, 0000, "enable dbwr consistency checking"
*Cause: internal use only
*Action: enables consistency checking of buffers written by
dbwriter and consistency checking of LRU working sets
10361, 00000, "check buffer change vector count consistency"
*Cause: internal use only
*Action: invoke buffer change vector count consistency every 5 minutes
10362, 00000, "simulate a write error to take a file offline"
*Cause: internal use only
*Action: Enables testing of DBWR taking a file offline because of a
write error. The level is the absolute file number of the
file to be taken offline when DBWR attemts to write to it.
10363, 00000, "Simulate messaging error for fast object reusecheckpoint"
*Cause: internal use only
*Action: Enables testing of fast object reusecheckpoint fallback
mechanism due to ksr message publishing issues.
10364, 00000, "Do not clear GIMH_STC_SHUT_BEGIN state during shutdown"
*Cause: internal use only
*Action: Enables testing of shutdown begin event by not
clearing GIMH_STC_SHUT_BEGIN state before shutdown completes.
reserve events 10365-10367 for direct asynchronous read path
10365, 00000, "turn on debug information for adaptive direct reads"
turn on debug information for adaptive direct reads
reserve events 10366-10367 for KGNFSKGODM
10366, 00000, "kgnfs tracing"
If this event is set then kgnfs module generates debug tracing.
10367, 00000, "kgodm tracing"
If this event is set then kgodm module generates debug tracing.
reserve events 10368-10368 for KSE
10368, 00000, "maximum number of internal errors a process will tolerate"
determines the maximum number of ORA-600s after which a
process will commit suicide.
10369, 00000, "test SQL monitoring feature"
crash tests
reserve events for parallel query option. Available range 10370-10399
10370, 00000, "parallel query server kill event"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to commit suicide, codes line
10371, 00000, "disable TQ hint"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: Stops the generation of the TQ hint (for testing purposes)
10372, 00000, "parallel query server kill event proc"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to commit suicide, codes proc & weapon
10373, 00000, "parallel query server kill event"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to commit suicide, code count & context
10375, 00000, "turn on checks for statistics rollups"
enables checks for stat rollup in QC
*Comment: verify that the rollup is being done accurately
10376, 00000, "enable archive compression loads"
Enables archive compression
*Comment: Temporary event
10377, 00000, "force slave allocation"
Set this event only under the supervision of Oracle development.
*Comment: for testing only--force the allocation of slaves in certain nodes
10378, 00000, "force hard processrange affinity"
set this event only under the supervision of Oracle development
*Comment: for testing only
10380, 00000, "kxfp latch cleanup testing event"
set this event only under the supervision of Oracle development
*Comment: for testing only--indicates the server to which the latch
cleanup key applies (0 for QC)
10381, 00000, "kxfp latch cleanup testing event"
set this event only under the supervision of Oracle development
*Comment: for testing only--the latch cleanup key (the number of the
LCTEST() call on which to kill the process)
10382, 00000, "parallel query server interrupt (reset)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to clear its buffers and reset itself
10383, 00000, "auto parallelization testing event"
Set this event only under the supervision of Oracle development
*Comment: For testing only. Trace level bits can be used in combination:
1: parallelize every full table scan (kkfd.c)
2: create every tablecluster parallel (prsc.c)
4: create every tablecluster cache
8: create every tablecluster cache partitions (overrides 4)
10384, 00000, "parallel dataflow scheduler tracing"
set this event only under the supervision of Oracle development
*Comment: trace level is a bitfield (see kkrp.h)
10385, 00000, "parallel table scan range sampling method"
set this event only under the supervision of Oracle development
*Comment: level: 0: (default) sample by random rowid
1: sample by first rows of partition ranges
10386, 00000, "parallel SQL hash and range statistics"
set this event only under the supervision of Oracle development
*Comment: print kxfq hash and range statistics
10387, 00000, "parallel query server interrupt (normal)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to leave the server group normally
10388, 00000, "parallel query server interrupt (failure)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to leave the server group (query
failed)
10389, 00000, "parallel query server interrupt (cleanup)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to leave the server group (signaled
by PMON, coordinator died)
10390, 00000, "Trace parallel query slave execution"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 slave-side execution messages
0x0002 coordinator-side execution messages
0x0004 slave context state changes
0x0008 slave rowid range bind variables and xty
0x0010 slave fetched rows as enqueued to TQ
0x0020 coordinator wait reply handling
0x0040 coordinator wait message buffering
0x0080 slave dump timing
0x0100 coordinator dump timing
0x0200 slave dump allocation file numbers
0x0400 terse format for debug dumps
0x0800 Trace CRI random sampling
0x1000 Trace signals
0x2000 Trace PX granule operations
0x4000 Force compilation by slave 0
10391, 00000, "trace PX granule allocationassignment"
set this event only under the supervision of Oracle development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump summary of each object scanned in parallel
0x0002 full dump of each object except extent map
0x0004 full dump of each object including extent map
0x0010 dump summary of each granule generators
0x0020 full dump of granule generators except granule instances
0x0040 full dump of granule generators including granule instances
0x0080 dump system info
0x0100 dump reference object for the query
0x0200 gives timing in kxfralo
0x0400 trace affinity module
0x0800 trace granule allocation during query execution
0x1000 trace object flush
0x2000 internal
*Comment: print details of PQ parallel granule allocation
10392, 00000, "parallel query debugging bits"
set this event only under the supervision of Oracle development
*Comment: turn onoff various kxfp features (documentation in kxfp.c)
10393, 00000, "print parallel query statistics"
set this event only under the supervision of Oracle development
*Comment: print kxfp statistics after each parallel query
10394, 00000, "generate a fake load to test adaptive and load balancing"
set this event only under the supervision of Oracle development
*Comment: generates a fake load for testing purposes
10395, 00000, "adjust sample size for range table queues"
set this event only under the supervision of Oracle development
*Comment: use reduced sample size for testing only
10397, 00000, "suppress verbose parallel coordinator error reporting"
set this event only under the supervision of Oracle development
*Comment: disable the ORA-12801 message when a parallel query
server gets a SQL error, instead report the slave's
actual error as if signaled in the foreground (for
testing, to match sequential log files)
10398, 00000, "enable timeouts in parallel query threads"
set this event only under the supervision of Oracle development
*Comment: level of this event indicates the number of seconds
before timing out of a kxfpqdeq() call, after which
an internal error will be signaled...for testing so
that test suites don't wedge.
10399, 00000, "trace buffer allocation"
set this event only under the supervision of Oracle development
*Comment: level indicates verbosity of tracing
Level1: Buffer leak checking
Level2: trace buffer init, chunk alloc, free and recovery
Level3: trace buffer alloc & free
10400, 00000, "turn on system state dumps for shutdown debugging"
Enables debugging code for shutdown problems (e.g., hangs)
10401, 00000, "turn on IPC (ksxp) debugging"
Enables debugging code for IPC service layer (ksxp)
10402, 00000, "turn on IPC (skgxp) debugging"
Enables debugging code for IPC layer (skgxp)
10403, 00000, "fake CPU number for default degree of parallelism"
set this event only under the supervision of Oracle development
*Comment: level of this event indicates the number of CPUs you want to
set to
reserve events 10404 - 10405 for mirror resilvering testing
10404, 00000, "crash dbwr after write"
set this event only to test mirror resilvering osds
*Comment: This event causes dbwr to crash after doing a write to
a mirrored datafile. For use in tkbrmrt only.
10405, 00000, "emulate broken mirrors"
set this event to cause mirror resilvering on startup
*Comment: This event is set when starting up after a crash caused
by OER(10404). It is used to persuade the recovery layer
that a mirror was broken.
10406, 00000, "enable datetime TIMESTAMP, INTERVAL datatype creation"
set this event to enable datetime datatype creation
*Comment: This event is set when the user wants to create
a datetime datatype column. The compatible=8.1.0.0.0 parameter
must also be set.
10407, 00000, "enable datetime TIME datatype creation"
set this event to enable datetime datatype creation
*Comment: This event is set when the user wants to create
a datetime datatype column. The compatible=8.1.0.0.0 parameter
must also be set.
10408, 00000, "disable OLAP builtin window function usage"
set this event to disable new OLAP builtin window functions
*Comment: This event is set when the user has a name conflict
with one of the OLAP window function names. This setting
disables the builtin functions so that user functions work.
10409, 00000, "enable granule memset and block invalidation at startup"
set this event to enable the memset and invalidation
*Comment: This event is created to be the safe valve for
startup speedup transaction
Events 10410-10412 reserved for KSXPCGS error simulation
10410, 00000, "trigger simulated communications errors in KSXP"
set this event to simulate communications errors to clients
*Comment: This event is set as 0xCIXXNNNN where C is the client id the
the error will be generated to, I is the instance id the error
will be generated for and NNNN is the minimum message sequence
number for instance I. An initial event value of C=0 indicates
dynamic check of event
10412, 00000, "dump the call stack if an error is signaled"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
10413, 00000, "force simulated error for testing purposes"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
*Comment:
level 1: ALTER TABLESPACE...READ ONLY before kcftro
level 2: ALTER TABLESPACE...READ ONLY after kcftro
level 3: ALTER TABLESPACE...READ ONLY before kcfrdo, after waiting
level 4: ALTER TABLESPACE...READ ONLY after kcfrdo
level 5: ALTER TABLESPACE...READ ONLY after krcrtro
level 6: ALTER TABLESPACE...READ ONLY after kqrpre to get lock on TS$
level 7: ALTER TABLESPACE...READ ONLY after kqrpup to update TS$
level 8: ALTER TABLESPACE...READ ONLY after ktucat to check other tx's
level 9: ALTER TABLESPACE...READ ONLY after ktccrb to commit
level 10: ALTER TABLESPACE...READ ONLY in kcfrdo, before checkpoint
10414, 00000, "simulated error from event %s level %s"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
*Comment:
10415, 00000, "parallel degree specified is too large, max value allowed %s"
*Cause: User specified parallel degree is greater than DEG_INST_MAXVAL
*Action:
*Comment:
10416, 00000, "disable fix for 2736734"
Disable the fix for bug 2736734
10417, 00000, "limit 1 file per sbtinfo2() validation call"
Prevent Oracle from passing multiple file handles to sbtinfo2(),
in case the Media Management Software cannot properly support
calls with multiple file names.
10418, 00000, "disable re-creating tempfile"
Prevent Oracle from automatically re-creating tempfile
10419, 00000, "create tempfile without create_scn and time"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
10420, 00000, "trace KSO OS-process operations"
Trace KSO operations.
10421, 00000, "enable dump from ksbwco if there is no reply"
creates an error stack dump if ksbwco does not hear back.
10422, 00000, "KSU debugging"
Helps debug KSU issues (see ksu.h).
10423, 00000, "dump the call stack if the specified error is cleared"
*Cause: If an unknown module is clearing an error that you expected to
be resignalled, you can use this event to aid your debugging.
Whenever that error is cleared the call stack will be dumped to the
trace file. This only works for non-OS Oracle errors.
Usage: event="10423 trace name context forever, level <your-err>"
Example:
event="10423 trace name context forever, level 28"
Each time ORA-28 is cleared the stack will be dumped.
*Action: Creates a stack dump each time the specified error is cleared.
10424, 00000, "KGE debugging"
Helps debug KGE issues (see kge.c).
Events 10425-10450 reserved for global enqueue service tracing and debugging
10425, 00000, "enable global enqueue operations event trace"
Dump trace for global enqueue operations.
10426, 00000, "enable gesgcs reconfiguration event trace"
Dump trace for gesgcs reconfiguration.
10427, 00000, "enable global enqueue service traffic controller event trace"
Dump trace for global enqueue service traffic controller.
10428, 00000, "enable tracing of global enqueue service cached resource"
Dump trace for global enqueue service cached resource activities.
10429, 00000, "enable tracing of global enqueue service IPC calls"
Dump trace for global enqueue service IPC calls.
10430, 00000, "enable gesgcs dynamic remastering event trace"
Dump trace for gesgcs dynamic remastering.
10431, 00000, "enable verification messages on pi consistency"
Send verification messages to check pi consistency
10432, 00000, "enable tracing of global cache service fusion calls"
Dump trace for global cache service fusion calls.
10433, 00000, "global enqueue service testing event"
Level: == 6 to return out-of-memory when getting message buffer
Level: == 7 to suspend lmd for a short period of time
Level: == 8 to suspend lms for a short period of time
Level: == 9 to inject out-of-order dlm messages
Level: == 10 to delay direct sends on send proxies and
to force indirect sends on half of the
direct send messages
10434, 00000, "enable tracing of global enqueue service multiple LMS"
Dump trace for global enqueue service muliple LMS.
10435, 00000, "enable tracing of global enqueue service deadlock detetction"
Dump trace for global enqueue service deadlock detetction.
10436, 00000, "enable global cache service duplicate ping checking"
Enable global cache service duplicate ping checking
10437, 00000, "enable trace of global enqueue service S optimized resources"
Dump global cache service S optimized resources
10438, 00000, "force lowest node to be master of all gcs resources"
enable affinity locks by forcing lowest node to be master
10439, 00000, "enable tracing of global cache service fusion calls - part 2"
enable tracing of global cache service fusion calls - part 2
10440, 00000, "enable global enqueue service inquire resource modes trace"
Dump trace for global enqueue service resource inquiry messages.
10441, 00000, "enable diagnosibility daemon (DIAG) trace"
Dump traces for DIAG.
10442, 00000, "enable trace of kst for ORA-01555 diagnostics"
Dump trace for ORA-01555 diagnostics
10443, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10444, 00000, "enable DLM timeout testing"
Simulate various scenarios for DLMCGS timeouts testing
10445, 00000, "enable tracing of LMS priority management"
Dump trace for LMS priority management
10446, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10447, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10448, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10449, 00000, "enable trace of kst for undo manageability features diagnostics"
Dump trace for undo manageability features diagnostics
10450, 00000, "signal ctrl-c in kdddca (drop column) after n rows"
set this event only under the supervision of Oracle development
*Comment: Set the level number to the number of rows before the error
is signalled. The error will be ORA-1013 (ctrl-c)
10451, 00000, "Force heap segment compression bypassing compatibility checks"
set this event only under the supervision of Oracle development
10452, 00000, "Cannot do block media recovery; media recovery session may be in progress"
*Cause: A media recovery, RMAN, or flashback database session may have
been in progress when an attempt was made to perform block media
recovery on the standby database.
*Action: Check for and cancel any conflicting recovery session and perform
block media recovery on the standby database.
10453, 00000, "Dump compression statistics to trace file"
set this event only under the supervision of Oracle development
10454, 00000, "Disable column reordering during compression"
set this event only under the supervision of Oracle development
10455, 00000, "Do Compression Block Checking"
set this event only under the supervision of Oracle development
10456, 00000, "cannot open standby database; media recovery session may be in progress"
*Cause: A media recovery, RMAN, or flashback database session may have
been in progress on a mounted instance of a standby database
when an attempt was made to open the standby database.
*Action: Check for and cancel any conflicting recovery session and open
the standby database.
10457, 00000, "cannot close standby database due to active media recovery"
*Cause: A media recovery session was in progress on a standby database
when an attempt was made to close the standby database.
*Action: Cancel the media recovery session and close the standby database.
10458, 00000, "standby database requires recovery"
*Cause: A standby database was in a state requiring media recovery
when an attempt was made to open the standby database.
*Action: Perform the necessary recovery and open the standby database.
10459, 00000, "cannot start media recovery on standby database; conflicting state detected"
*Cause: An attempt was made to perform media recovery on a standby
database while another instance was performing recovery on
the standby database, had the standby database open, or a data file
move operation was in progress.
*Action: Close the standby on all other instances, cancel any conflicting
recovery session or data file move operation, and perform manual
recovery.
10460, 00000, "Perform backward tablescans for consistent read reduction"
Events 10461 - 10489 reserved for recovery, incl debugging and tracing
10461, 00000, "Simulate control file corruption during write operation"
If set, will cause control file header verification to fail
10462, 00000, "enable recovery debug module"
Set this event to enable recovery debug module.
Recovery debug module does extra sanity checks on redo
generation and dumps interesting information to trace
if certain errors occur.
10463, 00000, "enable controlfile test"
Set this event to enable controlfile sequence number dump
at instance shutdown (level 1), future version controlfile
compatibility test (level 2), or cf backup creation (level 3)
10464, 00000, "enable incremental checkpoint debug for split brain check"
Set this event to enable checkpoint heartbeat tracing
10465, 00000, "force slave death during parallel crash recovery"
10466, 00000, "enable HARD check for block write"
Set this event to enable HARD check for every block write.
10467, 00000, "amplify control file record expansion for testing"
Set this event to amplify control file record expansion for testing
10468, 00000, "log writer debug module"
Set this event to the appropriate level for log writer debugging.
10469, 00000, "error creating control file backup, no checkpoint"
*Cause: The control file being backed up did not
contain a valid control file checkpoint.
Therefore the control file could not be backed up,
as such a backup would not be usable later for recovery.
A common cause for this situation is that you executed
CREATE CONTROLFILE, which mounts the database,
but not ALTER DATABASE OPEN, to open the database.
The latter operation generates a valid control file checkpoint.
*Action: Open the database with ALTER DATABASE OPEN ...,
which results in a valid control file checkpoint.
Run the backup operation again.
10470, 00000, "disable compatibility check for lost write detection"
Set this event to run database with lost write detection
enabled in compatibility mode below 11.0.
Level 1: equivalent of "typical" setting
Level 2: equivalent of "full" setting
for the parameter db_lost_write_protect
10471, 00000, "PQ slave allocation timeout test"
Set this event to enable the delay in PQ slave allocation.
If the delay is longer than the preset threshold (currently
1 minute), parallel recovery should switch to serial recovery.
10472, 00000, "dump reading log buffer hit ratio histogram to lgwr trace file"
Set this event to dump reading log buffer hit rate histogram
to lgwr trace file.
10473, 00000, "enable BRR tracing"
Set this event to enable tracing of Block Read Record generation.
10474, 00000, "controlfile time tracing"
Set this event to enable additional tracing of the time spent
in different controlfile operations.
10475, 00000, "readable standby debug event"
Set this event to enable additional tracing of readable standby.
10476, 00000, "control file corruption range testing"
Set this event to enable testing of control file
corruption ranges.
10477, 00000, "simulated rollback error"
Set this event to simulate a rollback failure.
10478, 00000, "DBW0 file identification trace event"
Set this event to enable DBW0 file identification tracing.
10479, 00000, "disk sector size test event"
Set this event to let OSD return a specified sector size
level 1: OSD returns 512 as the disk sector size
level 2: OSD returns 4096 (emulation) as the disk sector size
level 3: OSD returns 4096 (native) as the disk sector size
10480, 00000, "Soft asserts for fast detection of datafile storage problems"
Set this event to enable soft asserts to fire when a corrupt or
stale block is seen in some datafile mirrors. This event allows
for the proactive detection of datafile storage problems.
10481, 00000, "Backup data block for data file has an unlogged change"
*Cause: Flashback was enabled for the data file when the backup data block used
for block media recovery had an unlogged change.
*Action: Remove the data file from the flashback set or use a backup block that
does not contain an unlogged change to perform block media recovery.
10482, 00000, "Automatic block repair cannot repair an offline or read-only data file"
*Cause: Automatic block repair failed when trying to repair an offline or read-only
data file.
*Action: Bring the data file online in readwrite mode.
10483, 00000, "Simulate overly advanced incremental checkpoint"
Set this event to advance the incremental checkpoint so that dirty
buffers exist with low RBAs less than that of the checkpoint. This
scenario will be detected and the database will be crashed in a
recoverable state.
level 1: Generate error when linking buffer
level 2: Generate error when unlinking buffer
10484, 00000, "Enable test move operation"
Enable this event to test datafile move operation
10485, 00000, "Real-Time Query cannot be enabled while applying migration redo."
*Cause: The Real-Time Query feature was enabled when an attempt was made
to recover through migration redo generated during primary upgrades or
downgrades.
*Action: Close the standby database in order to recover through
migration redo. Reenable the Real-Time Query feature afterwards.
10486, 00000, "Verify data file-related SGA alignment"
*Cause:
*Action: Enable this event to verify data file-related SGA alignment.
10487, 00000, "Dump redo memory protection information."
Enable this event to dump the details about redo memory protection.
10488, 00000, "Dump block headers read for media recovery."
Enable this event to dump the block headers read during media
recovery before any redo application. If level is K_BTMAX+1, dump
all block types, otherwise dump only type equal to the event level.
10489, 00000, "Generate future redo for testing"
Internal testing only. Level of non-zero generates a future
informational redo change with opcode not known by this release.
Events 10490 - 10499 reserved for Oracle Storage Manager
10490, 00000, "Trace OSM misc. events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10491, 00000, "Trace OSM messaging (KFN) events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10492, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10493, 00000, "Return empty define buffers on 1422"
*cause
*action: On error 1422 instead of returning data in define buffers
this mimics action of version 7 and doesn't return data
valid level = 1
10494, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10495, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10496, 00000, "Turn off fix for bug 2554178"
*cause
*action: Instead of checking the current schema against the owner of the
db link revert to previous scheme
10497, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10498, 00000, "Trim blank characters including contol characters"
*Comment: Set this event to any non-zero level to trim blank characters
including control characters.
Default behaviour: No control characters are trimmed.
10499, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10500, 00000, "turn on traces for SMON"
Level: <=5 trace instance recovery
> 5 trace posting of SMON
10501, 00000, "periodically check selected heap"
Level: 0x01 PGA
0x02 SGA
0x04 UGA
0x08 current call
0x10 user call
0x20 large allocation pool
10502, 00000, "CBO disable the fix for bug 2098120"
10503, 00000, "enable user-specified graduated bind lengths"
10504, 00000, "CBO disable the fix for bug 2607029"
10505, 00000, "CBO enable dynamic sampling dump to table"
10506, 00000, "Disable fix for bug 2588217"
10507, 00000, "Trace bind equivalence logic"
10509, 00000, "Check kghu subheaps at call boundaries"
Level: 0x01 Call heap
0x02 Session heap
10510, 00000, "turn off SMON check to offline pending offline rollback segment"
10511, 00000, "turn off SMON check to cleanup undo dictionary"
10512, 00000, "turn off SMON check to shrink rollback segments"
10515, 00000, "turn on event to use physical cleanout"
10519, 00000, "enable ALTER TYPE RESET support"
10520, 00000, "recreate view only if definition has changed"
Set this event only under the supervision of Oracle development
*Comment: Changes behaviour of create or replace view,
comparing the new definition to the old prior to recreating the
object. Creation is skipped if old and new definitions match
(ie. object has not changed). No level number required.
10521, 00000, "CMON connection pool test event"
*Comment:
10522, 00000, "turn off wrap source compression"
Set this event if you do not want source of wrapped PLSQL
objects to be concatenated and stored multiple lines to a row.
*Comment: This event should be set if you want the source of wrapped
PLSQL objects to be stored one line per source row. The
default storage method is multiple lines per row, which
improves load and compile performance. No level number
required.
10523, 00000, "force recreate package even if definition is unchanged"
Set this event only under the supervision of Oracle development
*Comment: Changes behaviour of create or replace package, procedure,
function or type to force recreation of the object even if its new
definition exactly matches the old definition.
No level number required.
10524, 00000, "CMON connection pool trace event"
*Comment:
10525, 00000, "Disable automatic object validation for describe"
10543, 00000, "Standby Block Media Recovery (bmr) and split brain testing event"
Set this event in order to test the situation where standby bmr
does not have the necessary redo to recover a block or the situation
where a split brain occurs during instancecrash recovery.
10544, 00000, "Inject standby autobmr failures"
Set this event to inject block failures that will trigger standby autobmr.
10545, 00000, "Print standby autobmr messages in alert log"
Set this event to print standby autobmr messages in alert log.
10546, 00000, "Cannot perform block media recovery; standby database does not have requisite redo."
*Cause: An attempt was made to perform block media recovery on the standby
database when the necessary redo was not available.
*Action: Wait until the necessary redo is available and reattempt block
media recovery.
10547, 00000, "Cannot perform block media recovery; standby database is not caught up with primary."
*Cause: An attempt was made to perform block media recovery on the standby
database up to scn %s, which is greater than the highest scn of %s
yet applied at the standby.
*Action: Recover the standby up to scn %s and reattempt block media
recovery.
10548, 00000, "Cannot perform block media recovery on a read-only plugged-in datafile."
*Cause: An attempt was made to perform block media recovery on a read-only
plugged-in datafile.
*Action: Convert the plugged-in datafile to readwrite and reattempt block
media recovery.
10549, 00000, "Cannot perform block media recovery using a read-only plugged-in backup datafile."
*Cause: An attempt was made to perform block media recovery using a backup
of a read-only plugged-in datafile.
*Action: Reattempt block media recovery using a backup taken after the
plugged-in datafile has been converted to readwrite.
10550, 00000, "signal error during create as selectcreate index after n rows"
set this event only under the supervision of Oracle development
*Comment: Set the level number to the number of rows before the error
is signalled. The error will be ORA-1013 (ctrl-c)
10551, 00000, "Internal testing for ORA-1551 error handling"
10552 -10589 reserved for recoverable mediastandby recovery
10553, 00000, "Incompatible UNTIL CONSISTENT clause"
*Cause: RECOVER UNTIL CONSISTENT required database-level recovery with
a backup control file.
*Action: Omit the UNTIL CONSISTENT clause and retry recovery.
10554, 00000, "Media recovery failed to bring datafile %s to a consistent point"
*Cause: Media recovery couldn't recover database to a consistent point due
to the specified datafile.
*Action: Restore a backup of the datafile.
10555, 00000, "Disable redo dumping"
10558, 00000, "Disable unkeep marker handling for ADG"
Set this event on primary to disable generation of Exadata flash
cache unkeep marker. Set this event on ADG standby to ignore
such marker and always pass KCBF_DEF_CL_CACHE to cell.
10560, 00000, "block type '%s'"
*Cause: Report block type for details of another error.
*Action: See associated error message.
10561, 00000, "block type '%s', data object# %s"
*Cause: Report block type and data object number for details of
another error.
*Action: See associated error message.
10562, 00000, "Error occurred while applying redo to data block (file# %s, block# %s)"
*Cause: See other errors on error stack.
*Action: Investigate why the error occurred and how important is the data
block. Media and standby database recovery usually can continue
if user allows recovery to corrupt this data block.
10563, 00000, "Test recovery had to corrupt data block (file# %s, block# %s) in order to proceed"
*Cause: Test recovery completed.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary of the result
of the test recovery.
10564, 00000, "tablespace %s"
*Cause: Report tablespace name for details of another error.
*Action: See associated error message.
10565, 00000, "Another test recovery session is active"
*Cause: There can only be one test recovery session at any time.
Another test recovery session is active.
*Action: Wait till the other test recovery session completes.
10566, 00000, "Test recovery has used all the memory it can use"
*Cause: Test recovery tests redo in memory. It can no longer proceed
because it has consumed all the memory it can use.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary result
of the test recovery.
10567, 00000, "Redo is inconsistent with data block (file# %s, block# %s, file offset is %s bytes)"
*Cause: There are two possible causes of this error: (1) A write issued
by Oracle was lost by the underlying OS or storage system.
(2) an Oracle internal error.
*Action: Investigate why the error occurred and how important is the data
block. Media and standby database recovery usually can continue
if user allows recovery to corrupt this data block.
10568, 00000, "Failed to allocate recovery state object: out of SGA memory"
*Cause: out of SGA memory
*Action: Restart the instance. If problem persists, call Oracle support.
10570, 00000, "Test recovery complete"
*Cause: Test recovery completed.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary result
of the test recovery.
10571, 00000, "Test recovery canceled"
*Cause: User canceled test recovery.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary of the result
of the test recovery.
10572, 00000, "Test recovery canceled due to errors"
*Cause: See other errors on the error stack.
*Action: See other messages on error stack. It is possible that no
action is needed. See other messages on error stack for a
summary of the result of the test recovery so far.
10573, 00000, "Test recovery tested redo from change %s to %s"
*Cause: This message show the range of test recovery have tested.
*Action: No action is needed. See other messages on error stack.
10574, 00000, "Test recovery did not corrupt any data block"
*Cause: This message summarizes test recovery result.
*Action: No action is needed. See other messages on error stack.
10575, 00000, "Give up restoring recovered datafiles to consistent state: out of memory"
*Cause: There were not enough memory to restore recovered datafiles
to consistent state
*Action: This error is just a warning: You may not be able to open the
database with resetlogs immediately after this error. However,
you may continue mediastandby recovery, and that may make the
datafiles recovered consistent again.
10576, 00000, "Give up restoring recovered datafiles to consistent state: some error occurred"
*Cause: See alert file or other errors on the stack for a cause of the
problem.
*Action: This error is just a warning: You may not be able to open the
database with resetlogs immediately after this error. However,
you may continue mediastandby recovery, and that may make the
datafiles recovered consistent again.
10577, 00000, "Can not invoke test recovery for managed standby database recovery"
*Cause: Test recovery option is used for managed standby database recovery.
*Action: Either remove the test recovery option or invoke manual test
standby database recovery.
10578, 00000, "Can not allow corruption for managed standby database recovery"
*Cause: You used the allow corruption option for managed standby database
recovery.
*Action: Either remove the allow corruption option or invoke manual
standby database recovery.
10579, 00000, "Can not modify control file during test recovery"
*Cause: To proceed with recovery, test recovery needs to modify the
control file. But test recovery is not allowed to modify
control file.
*Action: No action is needed. Test recovery has ended successfully.
It can only go so far in the redo stream.
10580, 00000, "Can not modify datafile header during test recovery"
*Cause: To proceed with recovery, test recovery needs to modify a
datafile header. But test recovery is not allowed to modify
datafile headers.
*Action: No action is needed. Test recovery has ended successfully.
It can only go so far in the redo stream.
10581, 00000, "Can not modify redo log header during test recovery"
*Cause: To proceed with recovery, test recovery needs to modify a
redo log header. But test recovery is not allowed to modify
redo log headers.
*Action: No action is needed. Test recovery has ended successfully.
It can only go so far in the redo stream.
10582, 00000, "The control file is not a backup control file"
*Cause: User requested backup control file test recovery, but the
control file is not a backup control file.
*Action: Use a backup control file, or do not use USING BACKUP
CONTROLFILE option.
10583, 00000, "Can not recovery file %s renamed as missing during test recovery"
*Cause: One of the files to be recovered is renamed as missing.
*Action: Rename the file to the correct file or offline it.
10584, 00000, "Can not invoke parallel recovery for test recovery"
*Cause: Both test recovery and parallel recovery are requested.
*Action: Drop either one of the two recovery options.
10585, 00000, "Test recovery can not apply redo that may modify control file"
*Cause: Test recovery has encountered a special redo that may modify
control file.
*Action: No action is needed. Test recovery has proceeded successfully
as far as it could from its starting point.
10586, 00000, "Test recovery had to corrupt 1 data block in order to proceed"
*Cause: This message summarizes test recovery result: Oracle may have
to corrupt one block in order to apply the range of redo tested.
*Action: See alert log for details of the problem.
10587, 00000, "Invalid count for ALLOW n CORRUPTION option"
*Cause: The number specified in the ALLOW n CORRUPTION option is too big.
*Action: Use a smaller number.
10589, 00000, "Test recovery had to corrupt %s data blocks in order to proceed"
*Cause: This message summarizes test recovery result: Oracle may have
to corrupt a number of data blocks as specified in the message
in order to apply the range of redo tested.
*Action: See alert log for details of the problems.
10590, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10591, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10592, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10593, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10594, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10595, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10596, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10597, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10598, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10599, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10600, 00000, "check cursor frame allocation"
10601, 00000, "turn on debugging for cursor_sharing (literal replacement)"
10603, 00000, "cause an error to occur during truncate (for testing purposes)"
set this event only under the supervision of Oracle development
*Comment: this causes kdifrb to encounter an error during truncation of a
table with an index. it is for testing purposes only.
10604, 00000, "trace parallel create index"
set this event only under the supervision of Oracle development
*Comment: enables analysis of parallel create index
10605, 00000, "enable parallel create index by default"
set this event only under the supervision of Oracle development
*Comment: this causes all create index statement to by default
occur in parallel. it is for testing purposes only.
the level set in the event is the degree of parallelism.
*Comment: enables analysis of parallel create index - query coordinator
10606, 00000, "trace parallel create index"
set this event only under the supervision of Oracle development
*Comment: enables analysis of parallel create index - kkri slaves
10607, 00000, "trace index rowid partition scan"
set this event only under the supervision of Oracle development
*Comment: enables analysis of rowid index scan - rix row source,
and puts more trace on errors in range scans
10608, 00000, "trace create bitmap index"
set this event only under the supervision of Oracle development
*Comment: enables analysis of create bitmap index - kkrb row source
10609, 00000, "trace for array index insertion"
set this event to turn off the index array operation
*Comment: disable the index array operation
10610, 00000, "trace create index pseudo optimizer"
set this event only under the supervision of Oracle development
10611, 00000, "causes migration to fail - testing only"
set this event only under the supervision of Oracle development
10612, 00000, "prints debug information for auto-space managed segments"
10613, 00000, "prints debug information for auto-space managed segments"
10614, 00000, "Operation not allowed on this segment"
*Cause: This procedure can be used only on segments in
tablespaces with AUTO SEGMENT SPACE MANAGEMENT
*Action: Recheck the segment name and type and re-issue the statement
10615, 00000, "Invalid tablespace type for temporary tablespace"
*Cause: Tablespace with AUTO SEGMENT SPACE MANAGENEMT specified cannot be
used as a temporary tablespace
*Action: Recheck the tablespace name and re-issue the statement
10616, 00000, "Operation not allowed on this tablespace"
*Cause: Cannot perform the operation on tablespace with AUTO
SEGMENT SPACE MANAGEMENT
*Action: Recheck the tablespace name and re-issue the statement
10617, 00000, "Cannot create rollback segment in dictionary managed tablespace"
*Cause: Rollback segments cannot be created in dictionary managed
tablespaces when SYSTEM tablespace is locally managed
*Action: Recheck the tablespace name and re-issue the statement
10618, 00000, "Operation not allowed on this segment"
*Cause: This DBMS_SPACE operation is not permitted on segments in
tablespaces with AUTO SEGMENT SPACE MANAGEMENT
*Action: Recheck the segment name and type and re-issue the statement
10619, 00000, "Avoid assertions when possible"
*Cause: A bug (or upgrade) hits unicode assertions (csid, csform, bfc)
*Action: Event makes RDBMS skip assertions and patch up datastructures
10620, 00000, "Operation not allowed on this segment"
*Cause: Cannot alter freelist storage parameter for segments in tablespaces
with AUTO SEGMENT SPACE MANAGEMENT
*Action: Recheck the segment name and re-issue the statement
10621, 00000, "specify retry count for online index build cleanup DML lock get"
set this event only under the supervision of Oracle development
*Comment: Change the behaviour of online index build cleanup such that
a failed DML lock get will be reattempted. The number of retries
is dictated by the event level. Note that an event level of 1
means try forever. Any other event level specifies the number
of attempts, and is internally increased to some minimum default.
10622, 00000, "test or trace online index build or rebuild"
*Cause:
*Action: Set this event only under the supervision of Oracle development.
10623, 00000, "test synchronized flow of SORT rows into FOR UPDATE lock phase"
*Cause:
*Action: Set this event only under the supervision of Oracle development.
10624, 00000, "Disable UJV invalidation on drop index"
set this event only under the supervision of Oracle development
10625, 00000, "Turn off redo log dump for the index when OERI 12700"
set this event only under the supervision of Oracle development
10626, 00000, "specify timeout for online index rebuild to wait for DML"
set this event only under the supervision of Oracle development
*Comment: Change the behaviour of an online index rebuild such that it
will timeout, rather than wait indefinitely for existing DML
to complete.
The event level is the number of seconds the online index rebuild
should wait. Values outside the legal range of 2 to 300 seconds
will be adjusted automatically.
10627, 00000, "Dump the content of the index leaf block"
*Cause: Generate a complete index tree dump, not just an overview
during alter session set events immediate trace name treedump
*Action: This event is recommended only for small tableindex since it
dumps very detail information of every keys in the index
10628, 00000, "Turn on sanity check for kdiss index skip scan state"
*Cause: Will do sanity checking on the kdiss state.
*Action: set this event only under the supervision of Oracle development
10629, 00000, "force online index build to backoff and retry DML lock upgrade"
set this event only under the supervision of Oracle development
*Comment: Change the behaviour of an online index rebuild such that it
will backoff and retry a failed DML lock upgrade.
The event level is the number of retries the online index rebuild
should wait. Level 1 means backoff and retry indefinitely. Any
other value less than 32 will be adjusted automatically to be 32.
10630, 00000, "Illegal syntax specified with SHRINK clause"
*Cause: An illegal option was specified with the SHRINK clause
*Action: Verify the SQL Reference Manual and reissue the command
10631, 00000, "SHRINK clause should not be specified for this object"
*Cause: It is incorrect to issue shrink on the object
*Action: Verify the object name and type and reissue the command
10632, 00000, "Invalid rowid"
*Cause: Segment Highwatermark was overwritten due to shrink and space reused
*Action: Reissue this command.
10633, 00000, "No space found in the segment"
*Cause: Raised while trying to find space during segment shrink
*Action: This error should be trapped internally and treated. The user should
not be able to see the error.
10634, 00000, "Segment is already being shrunk"
*Cause: Only one invocation of shrink can be in progress on a segment at any time
*Action: Reissue the command after the first shrink is over
10635, 00000, "Invalid segment or tablespace type"
*Cause: Cannot shrink the segment because it is not in auto segment space
managed tablespace or it is not a data, index or lob segment.
*Action: Check the tablespace and segment type and reissue the statement
10636, 00000, "ROW MOVEMENT is not enabled"
*Cause: To shrink a data segment, row movement must be enabled.
*Action: Enable row movement and reissue this command.
10637, 00000, "The segment does not exist"
*Cause: Segment to be shrunk has been dropped
*Action:
10638, 00000, "Index status is invalid"
*Cause: Cannot shrink an index which is being rebuilt or disabled
is an unusable state.
*Action:
10639, 00000, "Dump library cache during reparse loops"
*Cause: During this error a library cache dump is necessary , so enable
librarycache dump if event is set.
*Action: Dump a library cache if this event is set when reparse error.
10640, 00000, "Operation not permitted during SYSTEM tablespace migration"
*Cause: SYSTEM tablespace is being migrated to locally managed format.
*Action: Reissue this command once SYSTEM tablespace migration is over.
10641, 00000, "Cannot find a rollback segment to bind to"
*Cause: SYSTEM tablespace migration requires rollback segment in locally
managed tablespace.
*Action: Drop rollback segments in dictionary managed tablespaces other than
SYSTEM and create rollback segments in locally managed tablespace
and retry migration.
10642, 00000, "Found rollback segments in dictionary managed tablespaces"
*Cause: When SYSTEM tablespace is migrated found rollback segments in
dictionary managed tablespaces.
*Action: Drop the rollback segments in dictionary managed tablespaces and
reissue the command
10643, 00000, "Database should be mounted in restricted mode and Exclusive mode"
*Cause: When SYSTEM tablespace is being migrated database should be mounted
in Exclusive mode and in Restricted mode.
*Action: Reissue this command after mounting the database in right mode.
10644, 00000, "SYSTEM tablespace cannot be default temporary tablespace"
*Cause: When SYSTEM tablespace is being migrated no user should have
SYSTEM as the default temporary tablespace.
*Action: Reissue this command after altering the default temporary
tablespace setting for all users.
10645, 00000, "Recursive Extension in SYSTEM tablespace during migration"
*Cause: When SYSTEM tablespace is being migrated, dictionary tables tried
to extend recursively. Must be caught and processed internally.
Should not be thrown to the user.
*Action: Report the error as a bug.
10646, 00000, "Too many recursive extensions during SYSTEM tablespace migration"
*Cause: When SYSTEM tablespace is being migrated, dictionary tables tried
to extend recursively more than 1000 times.
*Action: If SYSTEM tablespace is very large, then simply reissue the
tablespace migration command.
10647, 00000, "Tablespace other than SYSTEM, %s, %s not found in read only mode"
*Cause: When SYSTEM tablespace is being migrated, tablespaces other than
the three should be ALTERed to read only.
*Action: Alter the tablespace status to read only and retry migration.
10648, 00000, "Tablespace SYSAUX is not offline"
*Cause: The SYSAUX tablespace
was online while SYSTEM tablespace was being migrated.
*Action: Alter the SYSAUX tablespace status to offline and retry migration.
10649, 00000, "Turn offtrace lob index freelist coalesce"
*Cause: Will turn off or trace lob index freelist coalescing
*Action: set this event only under the supervision of Oracle development
10650, 00000, "disable cache-callback optimisation"
set this event only under the supervision of Oracle development
10651, 00000, "incorrect file number block number specified"
*Cause: The dba specified is not valid
*Action: Check if the dba specified belongs to the segment and is under the
segment HWM and reissue the statement
10652, 00000, "Object has on-commit materialized views"
*Cause: It is illegal to issue shrink on an object with on-commit
materialized views
*Action:
10653, 00000, "Table is in a cluster"
*Cause: It is illegal to shrink a table belonging to a cluster
*Action:
10654, 00000, "Table is of type temporary or external"
*Cause: It is illegal to shrink a temporary table or an external table
*Action:
10655, 00000, "Segment can be shrunk"
*Cause: Error message returned when called in probe mode by OEM
*Action:
10656, 00000, "Table is in unusable state due to incomplete operation"
*Cause: ALTER TABLE SHRINK operation was tried on the table which is in
unusable state because of previously failedincomplete operation.
*Action: If the previous operation was
- DROP COLUMN, resubmit DROP COLUMN CONTINUE
- DROP TABLE, resubmit DROP TABLE <table> PURGE
10657, 00000, "Lob column to be shrunk does not exist"
*Cause: Shrink was issued on a lob segment that did not exist
*Action:
10658, 00000, "Lob column to be shrunk is marked unused"
*Cause: Shrink was issued on a lob segment that is marked as unused
*Action:
10659, 00000, "Segment being shrunk is not a lob"
*Cause: Shrink was issued on a segment that should be a first class lob
or other data type stored in lob
*Action:
10660, 00000, "Segment is a shared lob segment"
*Cause: Shrink was issued on a segment that was being shared by multiple
lob columns
*Action:
10661, 00000, "Invalid option specified"
*Cause: Check option can be specified for one segment only
*Action:
10662, 00000, "Segment has long columns"
*Cause: Shrink was issued on a segment with long columns. This is not
supported.
*Action:
10663, 00000, "Object has rowid based materialized views"
*Cause: Shrink was issued on an object with rowid based materialized
views.
*Action: Drop the rowid based materialized views and issue shrink on the
object
10664, 00000, "Table has bitmap join indexes"
*Cause: SHRINK was issued on a table with bitmap join indexes.
*Action: Drop bitmap join indexes and reissue SHRINK on the object.
10665, 00000, "Inject Evil Literals"
*Cause: Event 10665 is set to some number > 0, causing 1(value-1) of all
literals to be replaced by 2000 letter 'A's. A value of 1 does
not corrupt anything.
*Action: never set this event
10666, 00000, "Do not get database enqueue name"
10667, 00000, "Cause sppst to check for valid process ids"
10668, 00000, "Inject Evil Identifiers"
*Cause: event 10668 is set to some number > 0, causing 1(value-1) of all
identifiers to be replaced by a maximum amount of x's. It is
common for an identifier to be parsed once with a max of 30 bytes,
then reparsed later with a max of 4000, so it may not be possible
to inject such an identifier without the aid of this event. A
value of 1 causes no identifiers to be corrupted.
*Action: never set this event
10690, 00000, "Set shadow process core file dump type (Unix only)"
*Cause: Control core file size for shadow processes
*Action: Level 1: Detach SGA before dumping core
Level 2: Do not produce any core
10691, 00000, "Set background process core file type (Unix only)"
*Cause: Control core file size file for background processes
*Action: Level 1: Detach SGA before dumping core
10700, 00000, "Alter access violation exception handler"
*Cause: Use this event to control what the VMS exception handler
does when it encounters an access violation.
*Action:
Level: >=10 Suspend current process on access violation
*** SET THIS EVENT ONLY UNDER THE SUPERVISION OF ORACLE DEVELOPMENT ***
10701, 00000, "Dump direct loader index keys"
*Cause: Dumps index keys at various points in a direct load based on the
value of this event.
*Action:
*Comment: This is bit mask, interpreted as follows:
0x01: dump all keys as they are being built (use judiciously,
as this generates a lot of data!)
0x02: dump index keys which cause OER(1), OER(1409), OER(1452)
errors.
10702, 00000, "Application continuity debugging was not enabled."
*Cause: Application continuity debugging was not enabled.
*Action: Enable application continuity debugging.
Level: 0x0001: Transaction intention debugging
10704, 00000, "Print out information about what enqueues are being obtained"
*Cause: When enabled, prints out arguments to calls to ksqcmi and
ksqlrl and the return values.
*Action: Level indicates details:
Level: 1-4: print out basic info for ksqlrl, ksqcmi
5-9: also print out stuff in callbacks: ksqlac, ksqlop
10+: also print out time for each line
10706, 00000, "Print out information about global enqueue manipulation"
*Cause: When enabled, prints out activity in ksi routines.
*Action: INternal system parameter (_ksi_trace) can be used in addition
to setting this event to limit output information on selected
set of global enqueue server enqueue type(s)
For example:
_ksi_trace = RTXA
output information only for RT and XA lock types.
*Action: Level indicates details:
0-4: show args for each main call
5-9: also indicate callbacks
10+: also printout time for each line
10707, 00000, "Simulate process death for instance registration"
*Cause: When enabled, process commits suicide to test instance
registration recovery code.
*Action: Level indicates where the process will die
10708, 00000, "print out trace information from the RAC buffer cache"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10709, 00000, "enable parallel instances in create index by default"
set this event only under the supervision of Oracle development
*Comment: this causes all create index statement to by default
use multiple instances. it is for testing purposes only.
the level set in the event is the number of instances.
*Comment: enables analysis of parallel create index - query coordinator
10710 - 10729 are Reserved for BITMAP row sources
10710, 00000, "trace bitmap index access"
set this event only under the supervision of Oracle development
*Comment: display the start-rowid, end-rowid of each bitmap segment - kkrbx
row source
10711, 00000, "trace bitmap index merge"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index merge - kkrbu row source
10712, 00000, "trace bitmap index or"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index or - kkrbo row source
10713, 00000, "trace bitmap index and"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index and - kkrba row source
10714, 00000, "trace bitmap index minus"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index minus - kkrbm row source
10715, 00000, "trace bitmap index conversion to rowids"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index merge - kkrbt row source
10716, 00000, "trace bitmap index compressdecompress"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index compressiondecompression -
modules kdibc, kdibci, kdibco, kdibc3
10717, 00000, "trace bitmap index compaction trace for index creation"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index creation -
modules kkrbc
10718, 00000, "event to disable automatic compaction after index creation"
set this event only under the supervision of Oracle development
*Comment: enables isolation of index creation problems. ie compaction
is an optional part of the index creation algorithem which
improves query performance and shrinks index size
modules kkrbc
10719, 00000, "trace bitmap index dml"
set this event only under the supervision of Oracle development
*Comment: enables analysis of inserts update and deletes into tables
with bitmap indexes
modules kkrbc
10720, 00000, "trace db scheduling"
set this event only under the supervision of Oracle development
*Comment: traces db scheduling
10721, 00000, "Internal testing - temp table transformation"
10722, 00000, "set parameters for CPU frequency calculation (debug)"
set this event only under the supervision of Oracle development
*Comment: changes parameters for CPU frequency calculation
10723, 00000, "Internal testing - release buffer for buffer cache shrink"
10724, 00000, "trace cross-instance broadcast"
set this event only under the supervision of Oracle development
*Comment: enables tracing of cross-instance broadcast (KSXR)
10725, 00000, "bitmap index version control"
Set this event only under the supervision of Oracle development.
The trace level is a bitfield, so use it as you would a flag.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 For bitmap indexes with version 0, DML on these bitmap
indexes will be same as with 9i releases (that is, it
simulates the bitmap index DML of previous releases).
10726, 00000, "frequent itemset counting"
set this event only under the supervision of Oracle development
*Comment: enables tracing of internal execution of frequent itemset
counting
10727, 00000, "introduce failure events in IPC"
Internal testing only.
*Comment:
10730 - 10800 general debugging events
10730, 00000, "trace row level security policy predicates"
*Comment:
10731, 00000, "dump SQL for CURSOR expressions"
set this event only under the supervision of Oracle development
*Comment: traces SQL statements generated to execute CURSOR expressions
10732, 00000, "honor pctfree during insert into AQ IOTs"
set this event only under the supervision of Oracle development
*Comment: If set, then we will honor pctfree, during SQL INSERTs and direct
kdiins0 calls from AQ, for IOTs that are used as AQ queue tables.
10733, 00000, "test transient-IOT metadata during PMO cleanup"
set this event only under the supervision of Oracle development
*Comment: causes an internal error to be raised if inconsistent metadata
is detected during cleanup of transient-IOTs which were left
behind by failed Partition Maintenance Operations. Enable this
event only during testing.
10734, 00000, "reroute external procedures"
set this event only under the supervision of Oracle development
*Comment: execute external procedures using plsql
10735, 00000, "debug ksws operations"
set this event only under the supervision of Oracle development
*Comment: Causes debug trace to be dumped for ksws routines
10736, 00000, "buffer cache pin history dump"
Set this event only under the supervision of Oracle development.
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Force redo dump during buffer pin history dump
0x0002 Disable redo dump during buffer pin history dump
0x0004 Print diagnostic text for the redo dump
10737, 00000, "test block checking"
Set this event only under the supervision of Oracle development.
*Comment: Internal testing event for block checking.
10738, 00000, "internal block testing"
Set this event only under the supervision of Oracle development.
10739, 00000, "debug WLM (kywm) operations"
set this event only under the supervision of Oracle development
*Comment: Causes debug trace to be dumped for kywm routines
10740, 00000, "disables fix for bug 598861"
set this event only under the supervision of Oracle development
*Comment: disables fix for bug 598861. The fix changes slightly the cost
estimations for set queries in views, and thereby
changes query plans from previous versions
modules vop
10741, 00000, "trace missing BRR generation"
Set this event only under the supervision of Oracle development.
Trace level is a bit field.
LEVEL ACTION
---------------------------------------------------------------------------
0x0000 Default of tracing missing BRR after 3 attempts
0x0001 Disable default of tracing missing BRR after 3 attempts
0x0002 Trace missing BRR due to Oracle RAC pings
0x0003 Disable default of tracing missing BRR after 3 attempts and
trace missing BRR due to Oracle RAC pings
10742, 00000, "dump process state on flush buffer_cache"
Set this event only under the supervision of Oracle development.
*Comment: Causes a process state to be dumped on ALTER SYSTEM FLUSH
BUFFER_CACHE.
10750, 00000, "test rollback segment blksize guessing for index array insert"
set this event only under the supervision of Oracle development
*Comment: causes internal error to be raised if a transaction
repeatedly (100 times) fails to bind to a rollback segment
because block size is too small. (Default behaviour is to
silently assume the minimum database block size possible after
that many failures). Enable this event only during testing.
10751, 00000, "override for remote row source maximum buffer size"
set this event only under the supervision of Oracle development
*Comment: To change the default value of 256000.
10752, 00000, "override for the Exponential Moving Average factor"
set this event only under the supervision of Oracle development
*Comment: To change the default value of 50%.
10753, 00000, "enforce deterministic behaviour for prefetching row source"
set this event only under the supervision of Oracle development
*Comment: prefetch will disregard buffer cache state and be deterministic
based on level set
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Always enable prefetching
0x0002 Always disable prefetching
0x0004 Print diagnostic text for each of the above levels, ie
use level 5 to trace enabling and level 6 to trace disabling.
10754, 00000, "disable fix for bug 14173995 for multi-table select for update"
set this event only under the supervision of Oracle development
10780 - 10785 Reserved for LogMiner
10780, 00000, "LogMiner API trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer internal api
10781, 00000, "LogMiner reader trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer reader process
10782, 00000, "LogMiner preparer trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer preparer process
10783, 00000, "LogMiner builder trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer builder process
10784, 00000, "LogMiner dictionary trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer dictionary
10785, 00000, "LogMiner trace event"
set this event only under the supervision of Oracle development
10786 - 10788 Reserved for ks*
10786, 00000, "call pushpop (KSU)"
set this event only under the supervision of Oracle development
*Comment: enables tracing of call pushpop operations
10787, 00000, "trace intra-instance broadcast"
set this event only under the supervision of Oracle development
*Comment: enables tracing of intra-instance broadcast (KSR)
10788, 00000, "trace call stacks"
set this event only under the supervision of Oracle development
*Comment: enables tracing of call stack info
10789 - 10790 Reserved for LogMiner
10789, 00000, "LogMiner test event"
set this event only under the supervision of Oracle development
*Comment: changes logminer behavior for testing
10790, 00000, "LogMiner trace event"
set this event only under the supervision of Oracle development
10791 - 10799 Reserved for Logical Standby
10791, 00000, "Logical Standby swithoverfailover trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst trancing of switchover and failover in logical
10792, 00000, "Logical Standby XDAT trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst trancing os XDAT usage
10793, 00000, "Logical Standby trace event"
set this event only under the supervision of Oracle development
10794, 00000, "Logical Standby trace event"
set this event only under the supervision of Oracle development
10795, 00000, "VKTM Process trace event"
Set this event only under the supervision of Oracle Support Services.
*Comment: enable ksdkst tracing for VKTM process
10796, 00000, "Elevate Scheduler Priority trace event"
Set this event only under the supervision of Oracle development
*Comment: enable ksd tracing for elevaterevert process scheduler priority
10797, 00000, "Logical Standby Test Event"
Set this event only under the supervision of Oracle development.
*Comment: changes logical standby behavior for testing
10800, 00000, "disable Smart Disk scan"
10804, 00000, "reserved for ksxb"
10806, 00000, "Switch to 7.3 mode when detaching sessions"
10807, 00000, "Disable user id check when switching to a global transaction"
10808, 00000, "Enable assert when waiting without a reason"
Set this event only under the supervision of Oracle development
*Comment: This event will catch clients that call kslwait without providing
any wait reason (see bug 1743159).
10809, 00000, "Trace state object allocate free history"
Set this event only under the supervision of Oracle development
*Comment: This event will trace the history of KSS allocations deletions.
level: 0 = disabled, 1 = cleanup only, 2 = always
10810 - 10825 Reserved for OLTP
10810, 00000, "Trace snapshot too old"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10811, 00000, "Trace block cleanouts"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10812, 00000, "Trace Consistent Reads"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10826 - 10829 Reserved for upgradedowngrade
10826, 00000, "enable upgradedowngrade error message trace"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10827, 00000, "enable upgradedowngrade diagnostics"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10828, 00000, "memory allocator error"
*Cause: Error in the memory allocator
*Action: Check the trace files and other relevant output
10830 - 10838 Reserved for sort and aggregation row sources
10830, 00000, "Trace group by sort row source"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace adaptive fetch usage
0x0002 trace exceptions during aggregation
0x0004 trace use of one comparison for all key columns
10831, 00000, "Trace group by rollup row source"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace use of one comparison for all key columns
10832, 00000, "Trace approximate NDV row source"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace
10839, 00000, "trace debug caching module (qesca.c)"
*Cause:
*Action: Set this event only under the supervision of Oracle Development.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace debug caching
0x0002 dump probe retrieve insert cache values
10840, 00000, "trace debug plsql caching module (kkxmInitCache)"
*Cause:
*Action: Set this event only under the supervision of Oracle Development.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace debug plsql caching
10841 - 10849 Reserved for OCI
10841, 00000, "Default un-inintialized charact set form to SQLCS_IMPLICIT"
*Cause: client side, such as JDBC-THIN 8i client sends 0 as charset form
*Action: This event sets charset form as SQLCS_IMPLICIT when it is 0
10842, 00000, "Event for OCI Tracing and Statistics Info"
*Cause: This event is meant for tracing OCI Calls and getting statistics
*Action: This event sets tracing OCI Calls and gets statistics info
10843, 00000, "Event for client result cache tracing"
*Cause: This is an internal event.
*Action: NA
10844, 00000, "turn on Native Net IPC debugging (skgxp)"
Enables debugging code for Native Net IPC (skgxp)
10845, 00000, "Enable Director tracing"
*Action: Enable tracing of directorworkload manager packages
10846, 00000, "Enable Director Single Node Testing"
*Action: Enable Single Node Testing
10847, 00000, "OCI dump action is being invoked for internal error ORA-%s"
*Cause: An internal error was encountered or EVENT_10842 was set to
level 8 or higher which dumped the OCI process state, current
state and the stack trace.
*Action: Disable EVENT_10842. If disabled, contact Oracle Support for the
internal error.
10848, 00000, "OCI Non Blocking not supported with %s"
*Cause: Attempt made to set connection as non-blocking with another
feature that does not support non-blocking.
*Action: Use blocking connection.
10849, 00000, "Internal OCI event number"
*Cause: NA
*Action: Set this event only under the supervision of Oracle Support
or Development. This event enable compatible behavior with
sending describe information when a cursor rebuilt.
10850 - 10869 Reserved for AQ
10850, 00000, "Enable time manager tracing"
10851, 00000, "Allow Drop command to drop queue tables"
*Cause: re-enable SQL Drop DDL for queue tables.
*Action: last resort to drop queue table if all other options fail. The
user have to manually cleanup AQ's metadata after this operation.
10852, 00000, "Enable tracing for Enqueue Dequeue Operations"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10854, 00000, "Sets poll count used for AQ listen code under RAC"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10856, 00000, "Disable AQ propagator from using streaming"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10857, 00000, "Force AQ propagator to use two-phase commit"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10858, 00000, "Crash the AQ propagator at different stages of commit"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10859, 00000, "Disable updates of message retry count"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DISABLING THE RETRY
FEATURE IN THE EVENT THAT IT CAUSES OTHER INTERNAL ERRORS.
10860, 00000, "event for AQ admin disable new name parser"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
THIS EVENT IS NOT TO BE TURNED ON BY ANY CUSTOMER. DOING SO,
MAY CAUSE AQ DICTIONARY CORRUPTION
10861, 000000, "disable storing extended message properties"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY TO DISABLE STORING
NEW MESSAGE PROPERTIES SUCH AS SENDER_ID AND ORIGINAL_MESSAGE_ID.
10862, 00000, "resolve default queue owner to current user in enqueuedequeue"
*Cause: resolve default queue owner to current user in enqueuedequeue.
*Action: turn on if client wish to resolve the default queue owner to the
current user. If not turned on, the default queue owner will be
resolved to the login user.
10863, 00000, "Control behavior of buffered background operations"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10864, 00000, "event to enable AQ dedicated propagation"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, ONE JOB QUEUE
PROCESS WILL PROPAGATE FOR ONLY ONE PROPAGATION SCHEDULE
10865, 00000, "Control tracing of notification operations"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10866, 00000, "event to order dequeue by condition"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, THE DEQUEUE
ORDER THE MESSAGES BASED ON CONDITION.
10867, 00000, "turn off authentication for emon to oci client and disable HA rstat"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, THERE IS NO
MUTUAL AUTHENTICATION BETWEEN EMON AND OCI CLIENTS IF SET AT LEVEL 1
AND LEVEL 2 IS USED FOR DISABLING THE UPDATION OF REGISTRATION
STATISTICS FOR HA NOTIFICATIONS
10868, 00000, "event to enable interop patch for AQ enqueue options"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, AQ DOES NOT
USE ENQUEUE OPTIONS FOR PROPAGATION.
10870 - 10879 Reserved for recovery layer
10870, 00000, "Disable multi-instance standby role transition"
For testing purposes
10871, 00000, "dump file openclose timestamp during media recovery"
For dumping purpose.
10872, 00000, "Flashback Database fault insertion event #%s."
*Cause: Causes faults to be inserted into Flashback Database code.
This should only be enabled for internal testing.
*Action: Level 1 - Die after restoring database, before shrinking
fuzziness.
Level 2 - Die after rstoring database and after shrinking
fuzziness.
Level 3 - Die after restoring control file.
Level 4 - Die after set cf checkpoint during an undo of a cf change
Level 5 - Die after restoring cf, before setting cf checkpoint
Level 6 - Force a block checksum error on a flashback log block
Level 7 - Force a file creation error during fb recovery
Level 8 - Force an error after fb recovery file recreation
Level 9 - Force and error during open resetlogs (after flashback)
10873, 00000, "file %s needs to be either taken out of backup mode or media recovered"
*Cause: An attempt was made to open a database after an instance failure or
SHUTDOWN ABORT interrupted an online backup.
*Action: If the indicated file is not a restored backup, then issue the
ALTER DATABASE END BACKUP command and open the database. If the
file is a restored online backup, then apply media recovery to
it and open the database.
10874, 00000, "Change max logfiles in hashtable in krfbVerifyRedoAvailable"
For testing purposes
10875, 00000, "Require instance bounce after switchover to primary"
For testing purposes
10876, 00000, "IDR Test event"
Level 1 - x$ir_working_repair_set returns manual options.
Should only be used when testing IR framework.
2 - force a failure revalidation timeout.
3 - force a failure in getAdviseID.
4-7 - simulate ADR timeout.
8 - simulate ADR lock busy error
9 - simulate OMF template name for logfile members
10877, 00000, "error signaled in parallel recovery slave %s"
*Cause: A parallel recovery logmerger reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
10878, 00000, "parallel recovery slave died unexpectedly"
*Cause: A parallel recovery slave died unexpectedly, PMON cleaning
up the process.
*Action: Check your system for anomalies and reissue the statement.
If this error persists, contact Oracle Support Services.
See trace file for more details.
10879, 00000, "error signaled in parallel recovery slave %s"
*Cause: A parallel recovery slave reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
10880 - 10882 Reserved for Java Virtual Machine
10880, 00000, "trace Java VM execution"
*Cause
*Action
10885, 00000, "Switchover test event"
10890, 00000, "ADG test event"
10891, 00000, "disable column pruning in ANSI join transformation"
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Do not attempt to automatically prune away unreferenced
columns during ANSI join transformation when compiling SQL
queries.
10898, 00000, "LGWR timing event"
10900 - 10924 Reserved for SPACE management
10900, 00000, "extent manager fault insertion event #%s"
*Cause: causes faults to be generated in instrumented extent code
*Action: this should only be enabled for internal testing
10901 - used in 7.3.4 for disabling extent trimming for merge
10901, 00000, "disable the fix for bug 1230798"
10902, 00000, "disable seghdr conversion for ro operation"
*Cause: causes seghdr conversion to be turned off for ro ops(#555856)
*Action: this should be enabled only if determined that bug 555856
has occured. Table needs to be exported subsequently
10903, 00000, "Force tablespaces to become locally managed"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10904, 00000, "Allow locally managed tablespaces to have user allocation"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY BY IMPORT CODE.
10905, 00000, "Do cache verification (kcbcxx) on extent allocation"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10906, 00000, "Unable to extend segment after insert direct load"
*Cause: This is a restriction with insert direct load transactions.
*Action: When a segment has been insert direct loaded, avoid DMLs that
could cause more space to be consumed.
10907, 00000, "Trace extent management events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10908, 00000, "Trace temp tablespace events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10909, 00000, "Trace free list events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10910, 00000, "inject corner case events into the RAC buffer cache"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10911, 00000, "Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle Support"
*Action:
10912, 00000, "Used to perform admin operations on locally managed SYSTEM tablespace"
*Action: The event should be used only under the supervision of
Oracle Support
10913, 00000, "Create locally managed database if compatible > 920 by default"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10914, 00000, "invalid TABLESPACE GROUP clause"
*Cause: An invalid option appears for TABLESPACE GROUP clause.
*Action: Specify a valid tablespace group name.
10915, 00000, "TABLESPACE GROUP cannot be specified for this type of tablespace"
*Cause: In CREATEALTER TABLESPACE, the TABLESPACE GROUP clause was used
while creatingaltering a tablespace that is not TEMPORARY.
*Action: Remove the TABLESPACE GROUP clause.
10916, 00000, "TABLESPACE GROUP already specified"
*Cause: In CREATEALTER TABLESPACE, the TABLESPACE GROUP option was
specified more than once.
*Action: Remove all but one of the TABLESPACE GROUP specifications.
10917, 00000, "TABLESPACE GROUP cannot be specified"
*Cause: The tablespace name specified in the command
is actually the name of a tablespace group.
*Action: Please specify an appropriate tablespace name.
10918, 00000, "TABLESPACE GROUP name cannot be the same as tablespace name"
*Cause: The tablespace group name specified in the command
is the same as the tablespace being CREATEdALTERed.
*Action: Please specify an appropriate tablespace group name.
10919, 00000, "Default temporary tablespace group must have at least one tablespace"
*Cause: An attempt was made to move the only tablespace in the default
database temporary tablespace group to another tablespace group.
*Action: Either change the database default temporary tablespace or
add another tablespace to the group that this tablespace belongs to.
10920, 00000, "Cannot offline tablespace belonging to default temporary tablespace group"
*Cause: An attempt was made to offline a tablespace in the default
database temporary tablespace group.
*Action: Either change the database default temporary tablespace or
change the tablespace group of this tablespace.
10921, 00000, "Cannot drop tablespace belonging to default temporary tablespace group"
*Cause: An attempt was made to drop a tablespace in the default
database temporary tablespace group.
*Action: Either change the database default temporary tablespace or
change the tablespace group of this tablespace.
10922, 00000, "Temporary tablespace group is empty"
*Cause: An attempt was made to allocate a temporary segment in a group,
which now no longer has any members.
*Action: Either add some temporary tablespaces or change the
temporary tablespace for this user.
10923, 00000, "prints debug information for object space server manageability"
10924, 00000, "import storage parse error ignore event"
*Cause: causes server to ignore specific error associated with freelists
and freelist groups when parsing
*Action: this should be enabled by import code only
10925 - 10959 Reserved for PLSQL
10925, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 237911
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10926, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 190119
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10927, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 235190
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10928, 00000, "trace name context forever"
* Cause:
* Action: Set this event only under the supervision of Oracle Development.
* Comment: This event causes PLSQL to dump out information to trace files.
10929, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 343966
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10930, 00000, "trace name context forever"
* Cause: When enabled, provides V7 behavior for fixed char binds
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10931, 00000, "trace name context forever"
* Cause: When enabled, allows normal packages to be compiled with standard
extensions like "<ADT_1>"
* Action: Set this event only for a short amount of time. Once the
packages are compiled, this event should be turned off.
Level 1 - Turn the event on
Level > 1 - Turn the event off
10932, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10933, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10934, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 11.x.
* Action: Set this event only if necessary - after reading the README for
this release or under supervision of Oracle Support Services.
10936, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available in versions 7.x and 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10937, 00000, "trace name context forever"
* Cause:
* Action: When set, this event enables tracing of PLSQL packages.
* Comment: Setting this event could result in some performance slowdown.
10938, 00000, "trace name context forever"
* Cause:
* Action: When set, this event enables tracing of PLSQL calls and exceptions.
* Comment: Setting this event could result in some performance slowdown.
10939, 00000, "trace name context forever"
* Cause:
* Action: When set, this event turns on coverage for PLSQL procedures and
functions.
* Comment: Setting this event could result in some performance slowdown.
10940, 00000, "trace name context forever"
* Cause: Size of the PLSQL tracing circular buffer, in kilobytes.
* Action: Set this event in concert with the 10938 event and the
_PLSQL_DUMP_BUFFER_EVENTS init.ora parameter, under supervision
of Oracle Support.
10941, 00000, "trace name context forever"
* Cause: When enabled, turns on PLSQL profiler
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10943, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10944, 00000, "trace name context forever"
* Cause: When enabled, allows or controls PLSQL OPT code gen project.
available only in version 8.2+.
* Action: set this event ONLY for development of the OPT project.
This is not for general use or deployment.
10945, 00000, "trace name context forever"
* Cause: When enabled, disables the behaviour change introduced by the fix
for bug 822764, which traps and handles invalidations of packages
whereas the previous behaviour was to use stale invalidated
instantiations of the stateful package body.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10946, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 10.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10947, 00000, "trace name context forever"
* Cause: When enabled, causes various PLSQL warnings related debugging
info to be written in a trace file. Useful for debugging varous
Oracle processes. available only in version 10.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10948, 00000, "trace name context forever"
* Cause: When enabled, inflate callout argument.
available only in version 10.x.
* Action: internal use only.
10949, 00000, "Disable autotune direct path read for full table scan"
Disable autotune direct path read for serial full table scan.
10960 - 10969 Reserved for Advanced Queuing
10960, 00000, "AQ tracing event"
*Document: NO
10970 - 10974 Reserved for Lob Access
10970, 00000, "backout event for bug 2133357"
*Cause: 2133357 dynamically sets the varying width flag and character width.
Lob data which is not migrated during migration from single byte to
multibyte charater set will be displayed as special characters.
*Action: To help migrate lob data which was not migrated during migration
by backing out 2133357, so lob data can be selected and moved to
multibyte character set.
10971, 00000, "prints debugging information for LOBs"
None
10972, 00000, "raise a 1551 exception in kdu_array_flush"
None
10973, 00000, "backout evet for 2619509"
*Cause: 2619509 catches offsets when not readingwriting on full character
boundary. To facilitate backward compatiblity event is being
introduced.
*Action: To help upgrademigrate issues which already have corrupt data
10974, 00000, "Turn on LOB integrity verification"
None
10975 - 10995 Reserved for Replication
10975, 00000, "trace execution of parallel propagation"
10976, 00000, "internal package related tracing"
LEVEL ACTION
---------------------------------------------------------------------------
> 0 trace the execution of sync procedural replication,
error execution, $RP$RL invocation.
> 1 trace the loading of meta-data into library cache for ip
10977, 00000, "trace event for RepAPI"
*Cause: NA.
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
10978, 00000, "general event for materialized view logs"
*Action: This internal event is used to enable various actions
associated with MV logs. The event level is interpreted
as a bitmap of actions to enable.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 use asynchronous purge
0x0002 use scheduled purge
0x0004 log commit scn when creating MV logs
10979, 00000, "trace flags for join index implementation"
*Cause: This is an informational message.
*Action: Values are as follows:
LEVEL ACTION
---------------------------------------------------------------------------
> 1 Dump refresh expressions (SQL) to trace file.
> 999 If a complete refresh is invoked, it will not be performed
but the system will assume that a complete refresh was done,
causing the view to be VALID and updating timestamps. This
should be used only under Oracle Support supervision.
10980, 00000, "prevent sharing of parsed query during Materialized View query generation"
*Cause: NA.
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
10981, 00000, "dscn computation-related event in replication"
.
*Action:
LEVEL ACTION
---------------------------------------------------------------------------
> 0 During replication enqueue for parallel propagation, make each
transaction in a session depend on the transaction that
precedes it in the same session.
10982, 00000, "event to turn off CDC-format MV Logs"
.
*Action:
LEVEL ACTION
---------------------------------------------------------------------------
= 999 Revert to pre-CDC original format MV Logs for all
new MV Logs created.
10983, 00000, "event to enable Create_Change_Table debugging"
.
*Action:
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Echo input parameter values to the trace log.
> 1 Display trigger debug info to the trace log also.
10984, 00000, "subquery materialized view-related event"
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 A REFRESH FAST subquery MATERIALIZED VIEW which
satisfies the pre 8.2 ORACLE server requirements will be
treated as a many-many subquery MATERIALIZED VIEW.
10985, 00000, "event for NULL refresh of materialized views"
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
10986, 00000, "donot use HASH_AJ in refresh"
*Action: Set this event while doing refresh if the delta snapshot is small
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Refresh uses NOT EXISTS sub-query instead of HASH_AJ
10987, 00000, "event for the support of caching table with object feature"
*Action: Set this event while caching tables with object features.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Turn off the checking of object features of a cached table
10988, 00000, "event to get exclusive lock during materialized view refresh in IAS"
*Action: Set this event if you want to get exclusive lock on the Updatable MV container table during refresh in IAS
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Get exclusive lock on the updatable MV container table during
refresh in IAS
10989, 00000, "event to internally create statistics MV"
*Action: The event is internally used to create statsMV
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0
10990, 00000, "dump spreadsheet info"
set this event only under the supervision of Oracle Development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump pruned rules during graph analysis
0x0002 dump level of the rules after ordering in graph analysis
0x0004 dump spreadsheet filter
10991, 00000, "event for optimizing the online redefinition instantiation"
*Document: NO
*Action: control the optimizations used during online redefinition.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Turn off the index optimization during online redefinition
instantiation.
0x0002 Turn off the ascending scn optimization during online redefinition
instantiation
0x0004 Turn on the index and optimistic ascending scn optimization
during online redefinition instantiation.
10992, 00000, "event to enable dbms_job instead of dbms_scheduler"
enables dbms_job instead of dbms_scheduler
*Comment: set this event only under the supervision of Oracle Development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 enable dbms_job instead of dbms_scheduler for MV refresh
10993, 00000, "Runtime enable IOQ batching"
*Comment: set this event only under the supervision of Oracle Development
10994, 00000, "Compiletime enable IOQ batching"
*Comment: set this event only under the supervision of Oracle Development
10995, 00000, "general event for materialized views"
*Action: This internal event is used to enable various actions
associated with MVs. The event level is interpreted
as a bitmap of actions to enable.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 enable callback-based refresh
0x0002 invalidate dependents for online redef
0x0004 allow PCT fast refresh after CONSIDER FRESH
0x0008 do not use an extended Merge statement during MAV fast refresh
10996 - 10998 Reserved for ks*
10997, 00000, "another startupshutdown operation of this instance inprogress"
*Cause: An Oracle Instance startup or shutdown operation failed to procure
the serialization primitive. Another foreground process may have
attempted startup or shutdown operation in parallel.
*Action: Check additional error messages in the alert log and the process
trace file.
10998, 00000, "event to enable short stack dumps in system state dumps"
*Action: enables short stack dumps for every active process in a system
state dump
*Comment: set this event only under the supervision of Oracle Support
10999, 00000, "do not get database enqueue name"
1.Dump diagnostic information on request立即转储诊断信息,可以是File headers (control file, redo log files, data files),System state dumps,Process state dumps.
它的event name是固定的immediate,trace name是具体转储内容<dump>.
立即转储一般使用alter session set events 'immediate trace name <dump> level <n>'或者oradebug dump <dump> <level>或者sys.dbms_system.set_ev(sid,serial#,65535,<level>,'<dump>').
2.Dump diagnostic information when an error occurs根据指定的错误号触发转储信息.
它的event name是错误号Error#,trace name是固定的errorstack.
错误触发转储一般使用参数文件event = "<error> trace name errorstack level <n>"或者alter session set events '<error> trace name errorstack level <level>'或者oradebug event <error> trace name errorstack level <level>
3.Change database behavior改变数据库运行行为.
它的event name是事件号Event#,trace name是固定的context.
改变数据库运行行为一般使用参数文件event = "<event> trace name context forever,level <level>"或者alter system set event ="<event> trace name context forever,level <level>" scope=spfile
4.Produce trace diagnostics as the database runs产生数据库运行的诊断信息.
它的event name是事件号Event#,trace name是固定的context.
产生数据库运行的诊断信息一般使用参数文件event = "<event> trace name context forever,level <level>"或者alter session/system set event ="<event> trace name context forever,level <level>"
设定诊断事件的方法也可分为四种:
1.The event initialization parameter在pfile初始化参数文件中设定诊断事件.
在参数文件中设定诊断事件,如果要设定多个事件,可以用多个event,event之间要连续(若不连续,只会最后一个event生效),例如:
event = "10015 trace name context forever"
event = "10046 trace name context forever, level 4"
也可以用一个event,用:隔开,例如:
event = "10015 trace name context forever:10046 trace name context forever, level 4"
2.The ALTER {SESSION|SYSTEM} SET EVENTS command通过alter session/system设定诊断事件.
alter system设定的诊断事件是会写到spfile上的.若要取消可以通过alter system reset event scope=spfile.
3.The sys.dbms_system.set_ev(…) procedure通过dbms_system包设定诊断事件.
sys.dbms_system.set_ev格式execute sys.dbms_system.set_ev(sid,serial#,event,level,action),例如:
execute sys.dbms_system.set_ev(8, 219, 10046, 12, '');
4.The ORADEBUG utility通过oradebug命令设定诊断事件.
oradebug命令功能强大,以下是命令help
SQL> oradebug help
HELP [command] Describe one or all commands
SETMYPID Debug current process
SETOSPID <ospid> Set OS pid of process to debug
SETORAPID <orapid> ['force'] Set Oracle pid of process to debug
SETORAPNAME <orapname> Set Oracle process name to debug
SHORT_STACK Get abridged OS stack
CURRENT_SQL Get current SQL
DUMP <dump_name> <lvl> [addr] Invoke named dump
PDUMP [interval=<interval>] Invoke named dump periodically
[ndumps=<count>] <dump_name> <lvl> [addr]
DUMPSGA [bytes] Dump fixed SGA
DUMPLIST Print a list of available dumps
EVENT <text> Set trace event in process
SESSION_EVENT <text> Set trace event in session
DUMPVAR <p|s|uga> <name> [level] Print/dump a fixed PGA/SGA/UGA variable
DUMPTYPE <address> <type> <count> Print/dump an address with type info
SETVAR <p|s|uga> <name> <value> Modify a fixed PGA/SGA/UGA variable
PEEK <addr> <len> [level] Print/Dump memory
POKE <addr> <len> <value> Modify memory
WAKEUP <orapid> Wake up Oracle process
SUSPEND Suspend execution
RESUME Resume execution
FLUSH Flush pending writes to trace file
CLOSE_TRACE Close trace file
TRACEFILE_NAME Get name of trace file
SETTRACEFILEID <identifier name> Set tracefile identifier
LKDEBUG Invoke global enqueue service debugger
NSDBX Invoke CGS name-service debugger
-G <Inst-List | def | all> Parallel oradebug command prefix
-R <Inst-List | def | all> Parallel oradebug prefix (return output
SETINST <instance# .. | all> Set instance list in double quotes
SGATOFILE <SGA dump dir> Dump SGA to file; dirname in double quotes
DMPCOWSGA <SGA dump dir> Dump & map SGA as COW; dirname in double quotes
MAPCOWSGA <SGA dump dir> Map SGA as COW; dirname in double quotes
HANGANALYZE [level] [syslevel] Analyze system hang
FFBEGIN Flash Freeze the Instance
FFDEREGISTER FF deregister instance from cluster
FFTERMINST Call exit and terminate instance
FFRESUMEINST Resume the flash frozen instance
FFSTATUS Flash freeze status of instance
SKDSTTPCS <ifname> <ofname> Helps translate PCs to names
WATCH <address> <len> <self|exist|all|target> Watch a region of memory
DELETE <local|global|target> watchpoint <id> Delete a watchpoint
SHOW <local|global|target> watchpoints Show watchpoints
DIRECT_ACCESS <set/enable/disable command | select query> Fixed table access
IPC Dump ipc information
UNLIMIT Unlimit the size of the trace file
CALL [-t count] <func> [arg1]...[argn] Invoke function with arguments
CORE Dump core without crashing process
PROCSTAT Dump process statistics
#可使用的dump项
SQL> oradebug dumplist
ADJUST_SCN
ALRT_TEST
ARCHIVE_ERROR
ASHDUMP
ASHDUMPSECONDS
ASM_EVENREAD
ASMDISK_ERR_OFF
ASMDISK_ERR_ON
ASMDISK_READ_ERR_ON
ATSK_TEST
AWR_FLUSH_TABLE_OFF
AWR_FLUSH_TABLE_ON
AWR_TEST
BC_SANITY_CHECK
BG_MESSAGES
BLK0_FMTCHG
BUFFER
BUFFERS
CALLSTACK
CGS
CHECK_ROREUSE_SANITY
CONTEXTAREA
CONTROLF
CROSSIC
CRS
CSS
CURSOR_STATS
CURSORDUMP
CURSORTRACE
DATA_ERR_OFF
DATA_ERR_ON
DATA_READ_ERR_ON
DBSCHEDULER
DEAD_CLEANUP_STATE
DROP_SEGMENTS
DUMP_ADV_SNAPSHOTS
DUMP_ALL_COMP_GRANULE_ADDRS
DUMP_ALL_COMP_GRANULES
DUMP_ALL_OBJSTATS
DUMP_ALL_REQS
DUMP_PINNED_BUFFER_HISTORY
DUMP_TEMP
DUMP_TRANSFER_OPS
DUMPGLOBALDATA
ENQUEUES
ERRORSTACK
EVENT_TSM_TEST
EXCEPTION_DUMP
FAILOVER
FBHDR
FBINC
FBTAIL
FILE_HDRS
FLASHBACK_GEN
FLUSH_CACHE
FLUSH_JAVA_POOL
FULL_DUMPS
GC_ELEMENTS
GES_STATE
GIPC
GLOBAL_AREA
GLOBAL_BUFFER_DUMP
HANGANALYZE
HANGANALYZE_GLOBAL
HANGANALYZE_PROC
HANGDIAG_HEADER
HEAPDUMP
HEAPDUMP_ADDR
HM_FDG_VERS
HM_FW_TRACE
HNGDET_MEM_USAGE_DUMP
INSTANTIATIONSTATE
IOERREMUL
IOERREMULRNG
IR_FW_TRACE
JAVAINFO
KCB_WORKING_SET_DUMP
KCBI_DUMP_FREELIST
KCBO_OBJ_CHECK_DUMP
KCBS_ADV_INT_DUMP
KDLIDMP
KRA_OPTIONS
KRA_TRACE
KRB_BSET_DAYS
KRB_CORRUPT_INTERVAL
KRB_CORRUPT_OFFSET
KRB_CORRUPT_REPEAT
KRB_CORRUPT_SIZE
KRB_CORRUPT_SPBAD_INTERVAL
KRB_CORRUPT_SPBAD_REPEAT
KRB_CORRUPT_SPBITMAP_INTERVAL
KRB_CORRUPT_SPBITMAP_REPEAT
KRB_CORRUPT_SPHEADER_INTERVAL
KRB_CORRUPT_SPHEADER_REPEAT
KRB_FAIL_INPUT_FILENO
KRB_OPTIONS
KRB_OVERWRITE_ACTION
KRB_PIECE_FAIL
KRB_SET_TIME_SWITCH
KRB_SIMULATE_NODE_AFFINITY
KRB_TRACE
KRB_UNUSED_OPTION
KRBABR_TRACE
KRBMROR_LIMIT
KRBMRSR_LIMIT
KRC_TRACE
KRDRSBF
KSDTRADV_TEST
KSFQP_LIMIT
KSKDUMPTRACE
KSTDUMPALLPROCS
KSTDUMPALLPROCS_CLUSTER
KSTDUMPCURPROC
KTPR_DEBUG
KUPPLATCHTEST
KXFPBLATCHTEST
KXFPCLEARSTATS
KXFPDUMPTRACE
KXFRHASHMAP
KXFXCURSORSTATE
KXFXSLAVESTATE
LATCHES
LDAP_KERNEL_DUMP
LDAP_USER_DUMP
LIBRARY_CACHE
LIBRARY_CACHE_OBJECT
LISTENER_REGISTRATION
LOCKS
LOGERROR
LOGHIST
LONGF_CREATE
MMAN_ALLOC_MEMORY
MMAN_CREATE_DEF_REQUEST
MMAN_CREATE_IMM_REQUEST
MMAN_IMM_REQUEST
MMON_TEST
MODIFIED_PARAMETERS
NEXT_SCN_WRAP
OBJECT_CACHE
OCR
OLAP_DUMP
OPEN_FILES
PGA_DETAIL_CANCEL
PGA_DETAIL_DUMP
PGA_DETAIL_GET
PGA_SUMMARY
PIN_BLOCKS
PIN_RANDOM_BLOCKS
POKE_ADDRESS
POKE_LENGTH
POKE_VALUE
POKE_VALUE0
POOL_SIMULATOR
PROCESSSTATE
REALFREEDUMP
RECORD_CALLSTACK
RECOVERY
REDOHDR
REDOLOGS
REFRESH_OS_STATS
ROW_CACHE
RULESETDUMP
RULESETDUMP_ADDR
SAVEPOINTS
SCN_AUTO_ROLLOVER_TS_OVERRIDE
SELFTESTASM
SET_NBLOCKS
SET_TSN_P1
SHARED_SERVER_STATE
SIMULATE_EOV
SQLNET_SERVER_TRACE
SYSTEMSTATE
SYSTEMSTATE_GLOBAL
TEST_DB_ROBUSTNESS
TEST_GET_CALLER
TEST_SPACEBG
TEST_STACK_DUMP
TR_CORRUPT_ONE_SIDE
TR_CRASH_AFTER_WRITE
TR_READ_ONE_SIDE
TR_RESET_NORMAL
TR_SET_ALL_BLOCKS
TR_SET_BLOCK
TR_SET_SIDE
TRACE_BUFFER_OFF
TRACE_BUFFER_ON
TREEDUMP
UPDATE_BLOCK0_FORMAT
WORKAREATAB_DUMP
XS_SESSION_STATE
oracle错误号的10000~10999是诊断事件号,可在$ORACLE_HOME/rdbms/mesg/oraus.msg中查看.
10000, 00000, "control file debug event, name 'control_file'"
10001, 00000, "control file crash event1"
10002, 00000, "control file crash event2"
10003, 00000, "control file crash event3"
10004, 00000, "block recovery testing - internal error"
10005, 00000, "trace latch operations for debugging"
Enable tracing for various latch operations
*Comment:
level 1 - trace latch gets and frees
level 2 - protectunprotect latch recovery areas
level 4 - trace multiple posts by processes when latch is freed
level 8 - signal error on bad latch waits
10006, 00000, "block recovery testing - external error"
10007, 00000, "log switch debug crash after new log select, thread %s"
level 1 - closed thread only
level 2 - open thread only
level 3 - open or closed thread
10008, 00000, "log switch debug crash after new log header write, thread %s"
level 1 - closed thread only
level 2 - open thread only
level 3 - open or closed thread
10009, 00000, "log switch debug crash after old log header write, thread %s"
level 1 - closed thread only
level 2 - open thread only
level 3 - open or closed thread
10010, 00000, "Begin Transaction"
10011, 00000, "End Transaction"
10012, 00000, "Abort Transaction"
10013, 00000, "Instance Recovery"
10014, 00000, "Roll Back to Save Point"
10015, 00000, "Undo Segment Recovery"
10016, 00000, "Undo Segment extend"
10017, 00000, "Undo Segment Wrap"
10018, 00000, "Data Segment Create"
10019, 00000, "Turn off dataspace search cache"
10020, 00000, "partial link restored to linked list (KSG)"
10021, 00000, "KST event to trace control file header writes and reads"
Not set by default.
10022, 00000, "trace ktsgsp"
10023, 00000, "Create Save Undo Segment"
10024, 00000, "Write to Save Undo"
10025, 00000, "Simulate block recovery errors"
*Cause:
*Action: The level is a bitmask that can be used as follows:
0x0001 -- Corruption on first attempt to get previous block version
10026, 00000, "Apply Save Undo"
10027, 00000, "Specify Deadlock Trace Information to be Dumped"
The level is a bitmask that can be used as follows:
0x01 - Do NOT produce a processstate (default is to dump this)
0x02 - Dump a systemstate
0x04 - Dump short stacks of all processes
10028, 00000, "Dump trace information during lock resource latch cleanup"
The level is a bitmask that can be used as follows:
0x01 - Dump information during resource cleanup
0x02 - Dump information during lock cleanup
10029, 00000, "session logon (KSU)"
10030, 00000, "session logoff (KSU)"
10031, 00000, "sort debug event (S*)"
*Cause:
*Action: Set this event only under the supervision of Oracle development.
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Trace sort auto memory management requirements
0x0002 Dump sort subheaps before freeing or resetting
0x0004 Trace use of new vs old sort
0x0008 Reserved for sort IO tracing
0x0010 Disable storing duplicates in linked list (also disables
part of top n rank optimization)
0x0020 Trace cluster-by-rowid (CBRID) sort
10032, 00000, "sort statistics (SOR*)"
Set this event only under the supervision of Oracle development.
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x01 Output sort statistics in the trace file at the end of sort.
0x02 Level 1 plus print more information as the sort progresses.
0x04 Level 2 plus dump extra information (track IOs).
10033, 00000, "sort run information (SRD*SRS*)"
10034, 00000, "access path analysis (APA*)"
10035, 00000, "Write parse failures to alert log file"
*Cause:
10036, 00000, "create remote row source (QKANET)"
10037, 00000, "allocate remote row source (QKARWS)"
10038, 00000, "dump row source tree (QBADRV)"
10039, 00000, "type checking (OPITCA)"
10040, 00000, "disable result-cache"
10041, 00000, "dump undo records skipped"
10042, 00000, "file header reads return youngest mirror"
10043, 00000, "check consistency of ownerwaiterconverter lists in KSQ"
10044, 00000, "free list undo operations"
10045, 00000, "free list update operations - ktsrsp, ktsunl"
10046, 00000, "enable SQL statement timing"
10047, 00000, "trace switching of sessions"
10048, 00000, "Undo segment shrink"
10049, 00000, "protect library cache memory heaps"
Use the OS memory protection (if available) to protect library
cache memory heaps that are pinned.
10050, 00000, "sniper trace"
10051, 00000, "trace OPI calls"
10052, 00000, "don't clean up obj$"
10053, 00000, "CBO Enable optimizer trace"
10054, 00000, "CBO Enable optimizer trace for recursive statement (RPI)"
10056, 00000, "dump analyze stats (kdg)"
10057, 00000, "suppress file names in error messages"
10058, 00000, "use table scan cost in tab$.spare1"
10059, 00000, "simulate error in logfile createclear"
10060, 00000, "CBO Enable predicate dump"
10061, 00000, "disable SMON from cleaning temp segment"
10062, 00000, "disable usage of OS Roles in osds"
10063, 00000, "disable usage of DBA and OPER privileges in osds"
10064, 00000, "thread enable debug crash level %s, thread %s"
level 1 - after new current log header written
level 2 - after current log committed
level 3 - after redo generation complete
10065, 00000, "limit library cache dump information for state object dump"
level 1 - minimal (only the address of state objects)
level 2 - little more (no object details)
level 3 - normal
10066, 00000, "simulate failure to verify file"
level is file number to fail verification
10067, 00000, "force redo log checksum errors - block number"
level is block number to corrupt
10068, 00000, "force redo log checksum errors - file number"
level is file number to corrupt
10070, 00000, "force datafile checksum errors - block number"
level is block number to corrupt
10071, 00000, "force datafile checksum errors - file number"
level is file number to corrupt
10072 is available.
10073, 00000, "latch cleanup tracing"
Enable latch cleanup tracing.
*Comment:
level 1 - PMON cleanup, in-flux latches only
level 2 - PMON cleanup, all latches
level 3 - all cleanup
10074, 00000, "default trace function mask for kst"
10075, 00000, "CBO Disable outer-join to regular join conversion"
10076, 00000, "CBO Enable cartesian product join costing"
10077, 00000, "CBO Disable view-merging optimization for outer-joins"
10078, 00000, "CBO Disable constant predicate elimination optimization"
10079, 00000, "trace data sentreceived via SQL*Net"
level 1 - trace network ops tofrom client
level 2 - in addition to level 1, dump data
level 4 - trace network ops tofrom dblink
level 8 - in addition to level 4, dump data
10080, 00000, "dump a block on a segment list which cannot be exchanged"
At level > 1, dump the block
At level > 5, dump the stack
At level > 10, unlink the block
10081, 00000, "segment High Water Mark has been advanced"
10082, 00000, "free list head block is the same as the last block"
At level > 1, dump the block
At level > 5, dump the stack
10084, 00000, "free list becomes empty"
10085, 00000, "free lists have been merged"
10086, 00000, "CBO Enable error if kko and qka disagree on oby sort"
10087, 00000, "disable repair of media corrupt data blocks"
10088, 00000, "CBO Disable new NOT IN optimization"
10089, 00000, "CBO Disable index sorting"
10090, 00000, "invoke other events before crash recovery"
10091, 00000, "CBO Disable constant predicate merging"
10092, 00000, "CBO Disable hash join"
10093, 00000, "CBO Enable force hash joins"
10094, 00000, "before resizing a data file"
10095, 00000, "dump debugger commands to trace file"
10096, 00000, "after the cross instance call when resizing a data file"
10097, 00000, "after generating redo when resizing a data file"
10098, 00000, "after the OS has increased the size of a data file"
10099, 00000, "after updating the file header with the new file size"
10100, 00000, "after the OS has decreased the size of a data file"
10101, 00000, "DBWR refresh fails on cross instance resize call"
10102, 00000, "switch off anti-joins"
10103, 00000, "CBO Disable hash join swapping"
10104, 00000, "dump hash join statistics to trace file"
10105, 00000, "CBO Enable constant pred trans and MPs w WHERE-clause"
10106, 00000, "CBO Disable evaluating correlation pred last for NOT IN"
10107, 00000, "CBO Always use bitmap index"
10108, 00000, "CBO Don't use bitmap index"
10109, 00000, "CBO Disable move of negated predicates"
10110, 00000, "CBO Try index rowid range scans"
10111, 00000, "Bitmap index creation switch"
10112, 00000, "Bitmap index creation switch"
10113, 00000, "Bitmap index creation switch"
10114, 00000, "Bitmap index creation switch"
10115, 00000, "CBO Bitmap optimization use maximal expression"
10116, 00000, "CBO Bitmap optimization switch"
10117, 00000, "CBO Disable new parallel cost model "
10118, 00000, "CBO Enable hash join costing "
10119, 00000, "QKA Disable GBY sort elimination"
10120, 00000, "generate relative file # different from absolute"
10121, 00000, "CBO Don't sort bitmap chains"
10122, 00000, "Disable transformation of count(col) to count(*)"
10124, 00000, "Force creation of segmented arrays by kscsAllocate"
10125, 00000, "Disable remote sort elimination"
10126, 00000, "Debug oracle java xa"
10127, 00000, "Disable remote query block operation"
10128, 00000, "Dump Partition Pruning Information"
set this event only under the supervision of Oracle development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump pruning decriptor for each partitioned object
0x0002 dump partition iterators
0x0004 dump optimizer decisions about partition-wise join
0x0008 dump rowid range scan pruning information
10129, 00000, "Alter histogram lookup for remote queries"
10130, 00000, "sort disable readaheads"
10131, 00000, "CONNECT BY debug event"
Set this event only under the supervision of Oracle development.
Trace level is a bit field.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Enable use of CONNECT BY cost-based transformation for
queries with subqueries in the START WITH clause
0x0002 Enable use of CONNECT BY cost-based transformation for
queries with subqueries in the CONNECT BY clause
0x0004 Do filtering only (print rows produced by filtering stage)
10132, 00000, "dump plan after compilation"
set this event only under the supervision of Oracle development
10133, 00000, "testing for SQL Memory Management"
never set this event
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 do not unregister work areas at instance level
10134, 00000, "tracing for SQL Memory Management for session"
never set this event
This event can be turned on globally by seting trace name sqlmem_tracing
with the same set of levels with bit one set to 1
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Not used (used for global setting)
0x0002 IMM level registerunregister
10135, 00000, "CBO do not count 0 rows partitions"
10136, 00000, "CBO turn off fix for bug 1089848"
10137, 00000, "CBO turn off fix for bug 1344111"
10138, 00000, "CBO turn off fix for bug 1577003"
10139, 00000, "CBO turn off fix for bug 1386119"
10140, 00000, "CBO turn off fix for bug 1332980"
10141, 00000, "CBO disable additional keys for inlist in bitmap optimization"
10142, 00000, "CBO turn off advanced OR-expansion checks"
10143, 00000, "CBO turn off hints"
10144, 00000, "CBO turn off cost based selection of bji over bsj subquery"
10145, 00000, "test auditing network errors"
10146, 00000, "enable Oracle TRACE collection"
*Comment: This event is obsoleted, and can be reused for some other purpose
although some customer applications which used to rely on
Oracle Trace may still have it enabled by mistake
10147, 00000, "enable join push through UNION view"
10149, 00000, "allow the creation of constraints with illegal date constants"
10150, 00000, "import exceptions"
This should never be set by users. It is used by import to
allow certain commands to succeed, when for normal users they
would fail. An example is to allow grants on invalid views.
10152, 00000, "CBO don't consider function costs in plans"
10153, 00000, "Switch to use public synonym if private one does not translate"
10154, 00000, "Switch to disallow synonyms in DDL statements"
10155, 00000, "CBO disable generation of transitive OR-chains"
10156, 00000, "CBO disable index fast full scan"
10157, 00000, "CBO disable index access path for in-list"
10158, 00000, "CBO preserve predicate order in post-filters"
10159, 00000, "CBO disable order-by sort pushdown into domain indexes"
10160, 00000, "CBO disable use of join index"
10161, 00000, "CBO recursive semi-join onoff-switch"
10162, 00000, "CBO join-back elimination onoff-switch"
10163, 00000, "CBO join-back elimination onoff-switch"
10164, 00000, "CBO disable subquery-adjusted cardinality fix"
10165, 00000, "mark session for special handling during instance administration"
Turn on this event in a session to mark the session as special
so that it can be either killed or ignored during instance
administration operations such as shutdown normal and standby
role transitions.
It is provided for the Oracle Enterprise Manager an other similar
tools.
The level is interpreted as follows
LEVEL ACTION
---------------------------------------------------------------------------
0 Treat this session as a normal session. This clears the
special bits which may have been set by other levels of this
event.
1 Kill this session during shutdown normal
2 Ignore this session during database close
3 Ignore this session during standby role transitions
>= 4 Reserved for future use
10166, 00000, "trace long operation statistics updates"
10167, 00000, "CBO use old index MINMAX optimization"
10168, 00000, "CBO disable single-table predicate predicate generation"
10169, 00000, "CBO disable histograms for multi partitions"
10170, 00000, "CBO use old bitmap costing"
10171, 00000, "CBO disable transitive join predicates"
10172, 00000, "CBO force hash join back"
10173, 00000, "Dynamic Sampling time-out error"
10174, 00000, "view join-back elimination switch"
10175, 00000, "CBO star transformation switch"
10176, 00000, "CBO colocated join switch"
10177, 00000, "CBO colocated join switch"
10178, 00000, "CBO turn off hash cluster filtering through memcmp"
10179, 00000, "CBO turn off transitive predicate replacement"
10180, 00000, "temp table transformation print error messages"
10181, 00000, "CBO disable multi-column in-list processing"
10182, 00000, "CBO disable generation of implied predicates"
10183, 00000, "CBO disable cost rounding"
10184, 00000, "CBO disable OR-exp if long inlist on bitmap column"
10185, 00000, "CBO force index joins"
10186, 00000, "CBO disable index join"
10187, 00000, "CBO additional index join switch"
10188, 00000, "CBO additional index join switch"
10189, 00000, "CBO turn off FFS null fix"
10190, 00000, "Analyze use old frequency histogram collection and density"
10191, 00000, "Avoid conversion of in-lists back to OR-expanded form"
10192, 00000, "nopushdown when number of groups exceed number of rows"
10193, 00000, "Force repeatable sampling with specified seed"
10194, 00000, "CBO disable new LIKE selectivity heuristic"
10195, 00000, "CBO don't use check constraints for transitive predicates"
10196, 00000, "CBO disable index skip scan"
10197, 00000, "CBO force index skip scan"
10199, 00000, "set parameter in session"
10200, 00000, "consistent read buffer status"
10201, 00000, "consistent read undo application"
10202, 00000, "consistent read block header"
10203, 00000, "block cleanout"
10204, 00000, "signal recursive extend"
10205, 00000, "row cache debugging"
At level 1, KQR will dump out latch clean-up debugging traces.
At level 2, KQR will dump out bootstrap debugging traces.
At level 3, KQR will invalidate, remove from the cache and put 0xff's
in row cache objects that are not currently locked.
10206, 00000, "transaction table consistent read"
10207, 00000, "consistent read transactions' status report"
10208, 00000, "consistent read loop check"
10209, 00000, "enable simulated error on control file"
Enables event 10214 to signal an error for a specific file. Level
is the number of the file to enable them for (file number order from
INIT.ORA file). A level greater than the maximum control file multiplexing
factor will signal error for all files.
10210, 00000, "check data block integrity"
10212, 00000, "check cluster integrity"
10213, 00000, "crash after control file write"
10214, 00000, "simulate write errors on control file"
A level of 1-9 simulates write errors on physical blocks 1-9.
If level >= 10 every control file write will force an error.
10215, 00000, "simulate read errors on control file"
For errors 10213,10214, and 10215
level 1 is for header
level 2 is for shared info
level >2 is any other block
No error 10214 will be simulated unless event 10209 is also set to enable
error simulation on that file
10216, 00000, "dump control file header"
10217, 00000, "debug sequence numbers"
10218, 00000, "dump uba of applied undo"
10219, 00000, "monitor multi-pass row locking"
10220, 00000, "show updates to the transaction table"
10221, 00000, "show changes done with undo"
10222, 00000, "row cache"
10223, 00000, "transaction layer - turn on verification codes"
10224, 00000, "index block splitdelete trace"
10225, 00000, "freeused extent row cache"
10226, 00000, "trace CR applications of undo for data operations"
*Cause:
*Action:
10227, 00000, "verify (multi-piece) row structure"
10228, 00000, "trace application of redo by kcocbk"
10229, 00000, "simulate IO error against datafiles"
10230, 00000, "KSFD block repair test event"
Each level is dedicated to a particular ksfd client. When this
event is set, clients corresponding to the level simulate block
verification failure.
10231, 00000, "skip corrupted blocks on _table_scans_"
such blocks are skipped in table scans, and listed in trace files
10232, 00000, "dump corrupted blocks symbolically when kcbgotten"
puts corrupted block in trace file
10233, 00000, "skip corrupted blocks on index operations"
skip corrupted data andor index blocks during index scans.
information is logged to a trace file.
10234, 00000, "trigger event after calling kcrapc to do redo N times"
creates a file named 'crash'
10235, 00000, "check memory manager internal structures"
10236, 00000, "dump redo on object no. or block type mismatch errors 14108103"
10237, 00000, "simulate ^C (for testing purposes)"
10238, 00000, "instantiation manager"
10239, 00000, "multi-instance library cache manager"
10240, 00000, "dump dba's of blocks that we wait for"
10241, 00000, "remote SQL execution tracingvalidation"
Level > 0 dump SQL generated for remote execution (OPIX)
Level > 1 validate RPCs in SELECT statements
10242, 00000, "suppress OER 2063 (for testing distrib wo different error log)"
10243, 00000, "simulated error for test %s of K2GTAB latch cleanup"
*Cause: levels 1..6 for insert, 7..11 for delete
*Action:
10244, 00000, "make tranids in error msgs print as 0.0.0 (for testing)"
*Cause: also makes "alter system enable distributed recovery" synchronous
*Action:
10245, 00000, "Testing event used by server IO ksfdksfq module"
10246, 00000, "print trace of PMON actions to trace file"
10247, 00000, "Turn on scgcmn tracing. (VMS ONLY)"
LEVEL ACTION
---------------------------------------------------------------------------
>= 1 Print lock name, action, mode, comp ast, bast, timeout, val?
>= 2 print Success code of request (NORMAL, SYNCH, or NOTQUEUED)
>= 3 print Value block
>= 5 Print delta CPU and elapsed times.
>= 100 stack dump at level 100-<given_level>.
10248, 00000, "turn on tracing for dispatchers"
10249, 00000, "turn on tracing for multi-stated servers"
10250, 00000, "Trace all allocate and free calls to the topmost SGA heap"
10251, 00000, "check consistency of transaction table and undo block"
MERGE: 10235 RENUMBERED TO 10251
10252, 00000, "shared IO pool error simulation"
level specifies number of IOs after which an error will be simulated
10253, 00000, "limit SQL text returned from X$KGLNA[1]"
level specifies the maximum SQL string length to be returned
10254, 00000, "trace cross-instance calls"
10255, 00000, "plsql parse checking"
sends all dml statements to plsql for parse and semantic check
10256, 00000, "shared server debug event"
10257, 00000, "trace shared server load balancing"
10258, 00000, "force shared servers to be chosen round-robin"
10259, 00000, "get error message text from remote using explicit call"
*Cause: for npigem coverage testing (normally called only for V5 remote)
*Action:
10260, 00000, "limit size (%s) of the PGA heap set by event 10261 exceeded"
*Cause: The PGA memory use exceeded the limit set by the event 10261.
*Action: Check event 10261 settings.
10261, 00000, "Limit the size of the PGA heap"
*Cause: the limit is one kilobyte times the level of the event. If the
pga grows bigger than this signal an internal error.
*Action:
10262, 00000, "Don't check for memory leaks"
*Cause: Setting this event to level one causes memory leak checking to
be disabled. Setting this event to any other non-zero number
allows that number to be used as a threshold value when checking
for memory leaks in the PGA, SGA, and UGA heaps.
*Action:
10263, 00000, "Don't free empty PGA heap extents"
*Cause: This is useful for debugging since watchpoints are lost on free
*Action:
10265, 00000, "Keep random system generated output out of error messages"
*Cause: so test system files don't diff
*Action:
10266, 00000, "Trace OSD stack usage"
*Cause: Porters should implement this to help them debug
their stack implementations. It should be used in at least
smcstk().
*Action:
10267, 00000, "Inhibit KSEDMP for testing"
*Cause: Some tests may generate internal or fatal errors on purpose.
This event can limit the size of tracefile produced for such
tests.
*Action: LEVEL used by KSEDMP is one less than level of this event.
10268, 00000, "Don't do forward coalesce when deleting extents"
*Cause: setting this event keeps kts from coalescing forward at each
extent when dropping a temp segment.
*Action:
10269, 00000, "Don't do coalesces of free space in SMON"
*Cause: setting this event prevents SMON from doing free space coalesces
10270, 00000, "Debug shared cursors"
*Cause: Enables debugging code in shared cursor management modules
*Action:
10271, 00000, "distributed transaction after COLLECT"
10272, 00000, "distributed transaction before PREPARE"
10273, 00000, "distributed transaction after PREPARE"
10274, 00000, "distributed transaction before COMMIT"
10275, 00000, "distributed transaction after COMMIT"
10276, 00000, "distributed transaction before FORGET"
10277, 00000, "Cursor sharing (or not) related event (used for testing)"
10278, 00000, "Internal testing"
10279, 00000, "Simulate block corruption in kdb4chk"
10280, 00000, "Internal testing - segmentation fault during crash recovery"
10281, 00000, "maximum time to wait for process creation"
*Cause: used to override the default SPMXWAIT, level = timeout in sec.
*Action:
10282, 00000, "Inhibit signalling of other backgrounds when one dies"
*Cause: Used in KSB
*Action:
10284, 00000, "simulate zeroinfinite asynch IO buffering"
*Cause: Used in KCF, level=1 out of space (red), level=2 infinite (green)
*Action:
10285, 00000, "Simulate control file header corruption"
If set, will cause control file header verification to fail
10286, 00000, "Simulate control file open error"
If set, will cause the next control file open to have an error
10287, 00000, "Simulate archiver error"
If set, next archive log will generate error
10288, 00000, "Do not check block type in ktrget"
If set, don't do type check in ktrget. This is a work-around
for databases that have 0 as block type in some data blocks.
10289, 00000, "Do block dumps to trace file in hex rather than fromatted"
If set, don't do formatted block dumps. This is a work-around
for block dump routines that accvio when given badly corrupted
blocks. It may also be useful for cases where the type is wrong.
10290, 00000, "Internal sequence tracing event"
Internal Event - Should not be set unless directed by RDBMS DEV
10291, 00000, "die in tbsdrv to test control file undo"
If this event is set, error OERI(10291) is signalled when
issueing tablespace commands. The control file undo should be
applied returning the control file to its previous state.
10292, 00000, "hang analysis trace event"
Enable validation of hang analysis callbacks
*Comment: The following levels may be combined:
0x1 - dump errors to trace file through ksdwrf
0x2 - dump errors to trace file as ORA-600 + 0x1
0x4 - check for involuntary events without callbacks
10293, 0000, "trace log switch media recovery checkpoints"
Print alert log timestamps for the start and end of each log
switch checkpoint during media recovery. This timing may prove
useful in debugging recovery performance problems.
10294, 00000, "ksrpc tracing"
If this event is set then ksrpc module generates tracing on each
remote transfer
10295, 00000, "die after file header update durning cf xact"
If this event is set then some file header updates will
be followed by an error 10295 to abort the command before
the control file xact commits.
10296, 00000, "disable ORA-379"
If this event is set then we will not signal ORA-379 for
buffer cache deadlocks when all buffers in the cache
are pinned.
10297, 00000, "shared IO pool tracing"
If this event is set, then kcbi tracing is enabled. Internal use.
10298, 00000, "ksfd io tracing"
If this event is set then ksfd module generates tracing
for each io request
10299, 00000, "Trace prefetch tracking decisions made by CKPT"
10300, 00000, "Distributed transaction tracing"
Set this event only under the supervision of Oracle development
*Comment: This event will trace the history of KTD actions
level: 0 = always
If this event is set then the prefetch tracking decisions
made by the CKPT process are traced. The trace output is
written to that process' trace file.
10301, 0000, "Enable LCK timeout table consistency check"
10302 - 10318 Reserved for internal triggers
10302, 00000, "trace create or drop internal trigger"
10303, 00000, "trace loading of library cache for internal triggers"
10304, 00000, "trace replication trigger"
10305, 00000, "trace updatable materialized view trigger"
10306, 00000, "trace materialized view log trigger"
10307, 00000, "trace RepCat execution"
10308, 00000, "replication testing event"
10309, 00000, "Trigger Debug event"
*Comment: This event replaces the earlier event number 10250
which had multiple definitions
10310, 00000, "trace synchronous change table trigger"
10311, 00000, "Disable Flashback Table Timestamp checking"
10312, 00000, "Allow disable to log rows into the mapping table"
10314, 00000, "Enable extra stats gathering for CR"
10316, 00000, "Events for extensible txn header, non zero ext header size"
10317, 00000, "Events for extensible txn header, zero ext header size"
10318, 00000, "Trace extensible txn header movements"
10319, 00000, "Trace PGA statistics maintenance"
set this event only under the supervision of Oracle development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump message in trace file when PGA stats are diverging
0x0002 trace top-level PGA allocation and deallocation
0x0004 always check if fullincremental stats are in sync
10320, 0000, "Enable data layer (kdtgrs) tracing of space management calls"
10321, 0000, "Datafile header verification debug failure."
For testing purposes only. Simulates a datafile header
verification error.
10322, 00000, "CBO don't simplify inlist predicates"
10323, 0000, "before committing an add datafile command"
10324, 0000, "Enable better checking of redo logs errors"
Raises internal errors when there are redo log errors
*Comment: Raises internal errors when there are redo log errors
10325 - 10335 reserved for recovery testing
10325, 0000, "Trace control file record section expand and shrink operations"
trace control file record section expand and shrink operations to
the alert file
10326, 00000, "clear logfile debug crash at %s, log %s"
level 1 - after prepare, before clearing the log members
level 2 - after clearing the log members, before final cf xaction
level 3 - just before clearing member 1
level 4 - just before clearing member 2
10327, 00000, "simulate ORA-00235 error for testing"
10328, 00000, "disable first-to-mount split-brain error, for testing"
for testing only.
10329, 00000, "simulate out-of-memory error during first pass of recovery"
for testing only.
10330, 00000, "clear MTTR statistics in checkpoint progress record"
clear MTTR statistics in this thread
10331, 00000, "simulate resilvering during recovery"
for testing only.
10332, 00000, "force ALTER SYSTEM QUIESCE RESTRICTED command to fail"
for testing only.
10333, 00000, "dump MTTR statistics each time it is updated"
dump MTTR statistics in this thread each time it is updated
10334, 00000, "force FG to wait to be killed during MTTR advisory simulation"
for testing only.
10335, 00000, "trace database open status"
for debugging purpose
10336, 00000, "Do remote object transfer using remote SQL"
10337, 00000, "enable padding owner name in slave sql"
*Document: NO
*Cause: owner name is not padded by default in slave sql
*Action: pad owner name during generation of slave sql
*Comment: applicable only for explain plan queries(for testing purposes)
10338, 00000, "CBO don't use inlist iterator with function-based indexes"
10339, 00000, "CBO disable DECODE simplification"
10340, 00000, "Buffer queues sanity check for corrupted buffers"
*Document: NO
*Cause:
*Action: Check all buffer queues for corrupted buffer every 5 minutes
reserve events 10341 - 10350 for checkpoints
10341, 00000, "Simulate out of PGA memory in DBWR during object reuse"
checks that DBWR can still perform invalidatino
*Comment: only used during testing
10342, 00000, "Raise unknown exception in ACQ_ADD when checkpointing"
should cause process to dump trace file and die
*Comment: This event is obsoleted, and can be reused for another test.
10343, 00000, "Raise an out of memory exception-OER 4031 in ACQ_ADD"
For Backgrounds, try to handle checkpoint using reserved entries
*Comment: Only enabled during testing
10344, 00000, "reserved for simulating object hash reorganization"
Set this to trigger obj hash table reorg to simulate large number
of objects per hash buckets. Done by DBWR interrupt action.
10345, 00000, "validate queue when linking or unlinking a buffer"
checks low RBA ordering of queue associated with latch
*Comment: Raises an error if low RBA ordering on queue is wrong
10346, 00000, "check that all buffers for checkpoint have been written"
Scans the cache to see that all candidate buffers are written
*Comment: Usually only enabled for TESTING since it involves a cache scan
10347, 00000, "dump active checkpoint entries and checkpoint buffers"
Prints the checkpoint queue and buffers to the trace file
*Comment: Usually only enabled for TESTING and code coverage
10348, 00000, "test abnormal termination of process initiating file checkpoint"
Causes abnormal termination of process starting a file checkpoint
*Comment: Only enabled for TESTING and code coverage
10349, 00000, "do not allow ckpt to complete"
disables checkpoint completion
*Comment: only enabled for TESTING
10350, 00000, "Simulate more than one object & tsn id in object reuse"
checks that DBWR can service multiple object id's in reuse"
*Comment: only used during testing
reserve events 10351-10359 for direct asynchronous read path
10351, 00000, "size of slots"
sets the size of slots to use
*Comment: a slot is a unit of IO and this factor controls the size
*Comment: of the IO.
10352, 00000, "report direct path statistics"
turns on direct path statistics
*Comment: reports statistics for direct path
10353, 00000, "number of slots"
sets a given number of slots to use
*Comment: a slot is a unit of IO and this factor controls the number
*Comment: of outstanding IOs.
10354, 00000, "turn on direct read path for parallel query"
enable direct read for parallel query
10355, 00000, "turn on direct read path for scans"
enable direct async read for scans
10356, 00000, "turn on hint usage for direct read"
enables using hint for direct async reads
10357, 00000, "turn on debug information for direct path"
turn on debug information for direct path
10358, 00000, "Simulate out of PGA memory in cache advisory reset"
checks that CKPT can set the simulation to OFF
*Comment: only used during testing
10359, 00000, "turn off updates to control file for direct writes"
Control files won't get updated for direct writes for LOBs
when NOCACHE NOLOGGING is set. The only bad impact that it
can have is that if you are using the recovery manager,
it may affect a warning that says that the user should
back everything up. Now the recovery manager won't know
to tell you that the files that were updated with
unrecoverable events should be backed up.
reserve events 10360-10362 for debugging DBWR
10360, 0000, "enable dbwr consistency checking"
*Cause: internal use only
*Action: enables consistency checking of buffers written by
dbwriter and consistency checking of LRU working sets
10361, 00000, "check buffer change vector count consistency"
*Cause: internal use only
*Action: invoke buffer change vector count consistency every 5 minutes
10362, 00000, "simulate a write error to take a file offline"
*Cause: internal use only
*Action: Enables testing of DBWR taking a file offline because of a
write error. The level is the absolute file number of the
file to be taken offline when DBWR attemts to write to it.
10363, 00000, "Simulate messaging error for fast object reusecheckpoint"
*Cause: internal use only
*Action: Enables testing of fast object reusecheckpoint fallback
mechanism due to ksr message publishing issues.
10364, 00000, "Do not clear GIMH_STC_SHUT_BEGIN state during shutdown"
*Cause: internal use only
*Action: Enables testing of shutdown begin event by not
clearing GIMH_STC_SHUT_BEGIN state before shutdown completes.
reserve events 10365-10367 for direct asynchronous read path
10365, 00000, "turn on debug information for adaptive direct reads"
turn on debug information for adaptive direct reads
reserve events 10366-10367 for KGNFSKGODM
10366, 00000, "kgnfs tracing"
If this event is set then kgnfs module generates debug tracing.
10367, 00000, "kgodm tracing"
If this event is set then kgodm module generates debug tracing.
reserve events 10368-10368 for KSE
10368, 00000, "maximum number of internal errors a process will tolerate"
determines the maximum number of ORA-600s after which a
process will commit suicide.
10369, 00000, "test SQL monitoring feature"
crash tests
reserve events for parallel query option. Available range 10370-10399
10370, 00000, "parallel query server kill event"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to commit suicide, codes line
10371, 00000, "disable TQ hint"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: Stops the generation of the TQ hint (for testing purposes)
10372, 00000, "parallel query server kill event proc"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to commit suicide, codes proc & weapon
10373, 00000, "parallel query server kill event"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to commit suicide, code count & context
10375, 00000, "turn on checks for statistics rollups"
enables checks for stat rollup in QC
*Comment: verify that the rollup is being done accurately
10376, 00000, "enable archive compression loads"
Enables archive compression
*Comment: Temporary event
10377, 00000, "force slave allocation"
Set this event only under the supervision of Oracle development.
*Comment: for testing only--force the allocation of slaves in certain nodes
10378, 00000, "force hard processrange affinity"
set this event only under the supervision of Oracle development
*Comment: for testing only
10380, 00000, "kxfp latch cleanup testing event"
set this event only under the supervision of Oracle development
*Comment: for testing only--indicates the server to which the latch
cleanup key applies (0 for QC)
10381, 00000, "kxfp latch cleanup testing event"
set this event only under the supervision of Oracle development
*Comment: for testing only--the latch cleanup key (the number of the
LCTEST() call on which to kill the process)
10382, 00000, "parallel query server interrupt (reset)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to clear its buffers and reset itself
10383, 00000, "auto parallelization testing event"
Set this event only under the supervision of Oracle development
*Comment: For testing only. Trace level bits can be used in combination:
1: parallelize every full table scan (kkfd.c)
2: create every tablecluster parallel (prsc.c)
4: create every tablecluster cache
8: create every tablecluster cache partitions (overrides 4)
10384, 00000, "parallel dataflow scheduler tracing"
set this event only under the supervision of Oracle development
*Comment: trace level is a bitfield (see kkrp.h)
10385, 00000, "parallel table scan range sampling method"
set this event only under the supervision of Oracle development
*Comment: level: 0: (default) sample by random rowid
1: sample by first rows of partition ranges
10386, 00000, "parallel SQL hash and range statistics"
set this event only under the supervision of Oracle development
*Comment: print kxfq hash and range statistics
10387, 00000, "parallel query server interrupt (normal)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to leave the server group normally
10388, 00000, "parallel query server interrupt (failure)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to leave the server group (query
failed)
10389, 00000, "parallel query server interrupt (cleanup)"
*Cause: internal use only
*Action: this event should never be set externally
*Comment: commands a slave to leave the server group (signaled
by PMON, coordinator died)
10390, 00000, "Trace parallel query slave execution"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 slave-side execution messages
0x0002 coordinator-side execution messages
0x0004 slave context state changes
0x0008 slave rowid range bind variables and xty
0x0010 slave fetched rows as enqueued to TQ
0x0020 coordinator wait reply handling
0x0040 coordinator wait message buffering
0x0080 slave dump timing
0x0100 coordinator dump timing
0x0200 slave dump allocation file numbers
0x0400 terse format for debug dumps
0x0800 Trace CRI random sampling
0x1000 Trace signals
0x2000 Trace PX granule operations
0x4000 Force compilation by slave 0
10391, 00000, "trace PX granule allocationassignment"
set this event only under the supervision of Oracle development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump summary of each object scanned in parallel
0x0002 full dump of each object except extent map
0x0004 full dump of each object including extent map
0x0010 dump summary of each granule generators
0x0020 full dump of granule generators except granule instances
0x0040 full dump of granule generators including granule instances
0x0080 dump system info
0x0100 dump reference object for the query
0x0200 gives timing in kxfralo
0x0400 trace affinity module
0x0800 trace granule allocation during query execution
0x1000 trace object flush
0x2000 internal
*Comment: print details of PQ parallel granule allocation
10392, 00000, "parallel query debugging bits"
set this event only under the supervision of Oracle development
*Comment: turn onoff various kxfp features (documentation in kxfp.c)
10393, 00000, "print parallel query statistics"
set this event only under the supervision of Oracle development
*Comment: print kxfp statistics after each parallel query
10394, 00000, "generate a fake load to test adaptive and load balancing"
set this event only under the supervision of Oracle development
*Comment: generates a fake load for testing purposes
10395, 00000, "adjust sample size for range table queues"
set this event only under the supervision of Oracle development
*Comment: use reduced sample size for testing only
10397, 00000, "suppress verbose parallel coordinator error reporting"
set this event only under the supervision of Oracle development
*Comment: disable the ORA-12801 message when a parallel query
server gets a SQL error, instead report the slave's
actual error as if signaled in the foreground (for
testing, to match sequential log files)
10398, 00000, "enable timeouts in parallel query threads"
set this event only under the supervision of Oracle development
*Comment: level of this event indicates the number of seconds
before timing out of a kxfpqdeq() call, after which
an internal error will be signaled...for testing so
that test suites don't wedge.
10399, 00000, "trace buffer allocation"
set this event only under the supervision of Oracle development
*Comment: level indicates verbosity of tracing
Level1: Buffer leak checking
Level2: trace buffer init, chunk alloc, free and recovery
Level3: trace buffer alloc & free
10400, 00000, "turn on system state dumps for shutdown debugging"
Enables debugging code for shutdown problems (e.g., hangs)
10401, 00000, "turn on IPC (ksxp) debugging"
Enables debugging code for IPC service layer (ksxp)
10402, 00000, "turn on IPC (skgxp) debugging"
Enables debugging code for IPC layer (skgxp)
10403, 00000, "fake CPU number for default degree of parallelism"
set this event only under the supervision of Oracle development
*Comment: level of this event indicates the number of CPUs you want to
set to
reserve events 10404 - 10405 for mirror resilvering testing
10404, 00000, "crash dbwr after write"
set this event only to test mirror resilvering osds
*Comment: This event causes dbwr to crash after doing a write to
a mirrored datafile. For use in tkbrmrt only.
10405, 00000, "emulate broken mirrors"
set this event to cause mirror resilvering on startup
*Comment: This event is set when starting up after a crash caused
by OER(10404). It is used to persuade the recovery layer
that a mirror was broken.
10406, 00000, "enable datetime TIMESTAMP, INTERVAL datatype creation"
set this event to enable datetime datatype creation
*Comment: This event is set when the user wants to create
a datetime datatype column. The compatible=8.1.0.0.0 parameter
must also be set.
10407, 00000, "enable datetime TIME datatype creation"
set this event to enable datetime datatype creation
*Comment: This event is set when the user wants to create
a datetime datatype column. The compatible=8.1.0.0.0 parameter
must also be set.
10408, 00000, "disable OLAP builtin window function usage"
set this event to disable new OLAP builtin window functions
*Comment: This event is set when the user has a name conflict
with one of the OLAP window function names. This setting
disables the builtin functions so that user functions work.
10409, 00000, "enable granule memset and block invalidation at startup"
set this event to enable the memset and invalidation
*Comment: This event is created to be the safe valve for
startup speedup transaction
Events 10410-10412 reserved for KSXPCGS error simulation
10410, 00000, "trigger simulated communications errors in KSXP"
set this event to simulate communications errors to clients
*Comment: This event is set as 0xCIXXNNNN where C is the client id the
the error will be generated to, I is the instance id the error
will be generated for and NNNN is the minimum message sequence
number for instance I. An initial event value of C=0 indicates
dynamic check of event
10412, 00000, "dump the call stack if an error is signaled"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
10413, 00000, "force simulated error for testing purposes"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
*Comment:
level 1: ALTER TABLESPACE...READ ONLY before kcftro
level 2: ALTER TABLESPACE...READ ONLY after kcftro
level 3: ALTER TABLESPACE...READ ONLY before kcfrdo, after waiting
level 4: ALTER TABLESPACE...READ ONLY after kcfrdo
level 5: ALTER TABLESPACE...READ ONLY after krcrtro
level 6: ALTER TABLESPACE...READ ONLY after kqrpre to get lock on TS$
level 7: ALTER TABLESPACE...READ ONLY after kqrpup to update TS$
level 8: ALTER TABLESPACE...READ ONLY after ktucat to check other tx's
level 9: ALTER TABLESPACE...READ ONLY after ktccrb to commit
level 10: ALTER TABLESPACE...READ ONLY in kcfrdo, before checkpoint
10414, 00000, "simulated error from event %s level %s"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
*Comment:
10415, 00000, "parallel degree specified is too large, max value allowed %s"
*Cause: User specified parallel degree is greater than DEG_INST_MAXVAL
*Action:
*Comment:
10416, 00000, "disable fix for 2736734"
Disable the fix for bug 2736734
10417, 00000, "limit 1 file per sbtinfo2() validation call"
Prevent Oracle from passing multiple file handles to sbtinfo2(),
in case the Media Management Software cannot properly support
calls with multiple file names.
10418, 00000, "disable re-creating tempfile"
Prevent Oracle from automatically re-creating tempfile
10419, 00000, "create tempfile without create_scn and time"
*Cause: For testing only.
*Action: None. For testing only. Should never be set by customers.
10420, 00000, "trace KSO OS-process operations"
Trace KSO operations.
10421, 00000, "enable dump from ksbwco if there is no reply"
creates an error stack dump if ksbwco does not hear back.
10422, 00000, "KSU debugging"
Helps debug KSU issues (see ksu.h).
10423, 00000, "dump the call stack if the specified error is cleared"
*Cause: If an unknown module is clearing an error that you expected to
be resignalled, you can use this event to aid your debugging.
Whenever that error is cleared the call stack will be dumped to the
trace file. This only works for non-OS Oracle errors.
Usage: event="10423 trace name context forever, level <your-err>"
Example:
event="10423 trace name context forever, level 28"
Each time ORA-28 is cleared the stack will be dumped.
*Action: Creates a stack dump each time the specified error is cleared.
10424, 00000, "KGE debugging"
Helps debug KGE issues (see kge.c).
Events 10425-10450 reserved for global enqueue service tracing and debugging
10425, 00000, "enable global enqueue operations event trace"
Dump trace for global enqueue operations.
10426, 00000, "enable gesgcs reconfiguration event trace"
Dump trace for gesgcs reconfiguration.
10427, 00000, "enable global enqueue service traffic controller event trace"
Dump trace for global enqueue service traffic controller.
10428, 00000, "enable tracing of global enqueue service cached resource"
Dump trace for global enqueue service cached resource activities.
10429, 00000, "enable tracing of global enqueue service IPC calls"
Dump trace for global enqueue service IPC calls.
10430, 00000, "enable gesgcs dynamic remastering event trace"
Dump trace for gesgcs dynamic remastering.
10431, 00000, "enable verification messages on pi consistency"
Send verification messages to check pi consistency
10432, 00000, "enable tracing of global cache service fusion calls"
Dump trace for global cache service fusion calls.
10433, 00000, "global enqueue service testing event"
Level: == 6 to return out-of-memory when getting message buffer
Level: == 7 to suspend lmd for a short period of time
Level: == 8 to suspend lms for a short period of time
Level: == 9 to inject out-of-order dlm messages
Level: == 10 to delay direct sends on send proxies and
to force indirect sends on half of the
direct send messages
10434, 00000, "enable tracing of global enqueue service multiple LMS"
Dump trace for global enqueue service muliple LMS.
10435, 00000, "enable tracing of global enqueue service deadlock detetction"
Dump trace for global enqueue service deadlock detetction.
10436, 00000, "enable global cache service duplicate ping checking"
Enable global cache service duplicate ping checking
10437, 00000, "enable trace of global enqueue service S optimized resources"
Dump global cache service S optimized resources
10438, 00000, "force lowest node to be master of all gcs resources"
enable affinity locks by forcing lowest node to be master
10439, 00000, "enable tracing of global cache service fusion calls - part 2"
enable tracing of global cache service fusion calls - part 2
10440, 00000, "enable global enqueue service inquire resource modes trace"
Dump trace for global enqueue service resource inquiry messages.
10441, 00000, "enable diagnosibility daemon (DIAG) trace"
Dump traces for DIAG.
10442, 00000, "enable trace of kst for ORA-01555 diagnostics"
Dump trace for ORA-01555 diagnostics
10443, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10444, 00000, "enable DLM timeout testing"
Simulate various scenarios for DLMCGS timeouts testing
10445, 00000, "enable tracing of LMS priority management"
Dump trace for LMS priority management
10446, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10447, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10448, 00000, "reserved for data layer diagnostics and debugging"
Set this event only under the supervision of Oracle development.
10449, 00000, "enable trace of kst for undo manageability features diagnostics"
Dump trace for undo manageability features diagnostics
10450, 00000, "signal ctrl-c in kdddca (drop column) after n rows"
set this event only under the supervision of Oracle development
*Comment: Set the level number to the number of rows before the error
is signalled. The error will be ORA-1013 (ctrl-c)
10451, 00000, "Force heap segment compression bypassing compatibility checks"
set this event only under the supervision of Oracle development
10452, 00000, "Cannot do block media recovery; media recovery session may be in progress"
*Cause: A media recovery, RMAN, or flashback database session may have
been in progress when an attempt was made to perform block media
recovery on the standby database.
*Action: Check for and cancel any conflicting recovery session and perform
block media recovery on the standby database.
10453, 00000, "Dump compression statistics to trace file"
set this event only under the supervision of Oracle development
10454, 00000, "Disable column reordering during compression"
set this event only under the supervision of Oracle development
10455, 00000, "Do Compression Block Checking"
set this event only under the supervision of Oracle development
10456, 00000, "cannot open standby database; media recovery session may be in progress"
*Cause: A media recovery, RMAN, or flashback database session may have
been in progress on a mounted instance of a standby database
when an attempt was made to open the standby database.
*Action: Check for and cancel any conflicting recovery session and open
the standby database.
10457, 00000, "cannot close standby database due to active media recovery"
*Cause: A media recovery session was in progress on a standby database
when an attempt was made to close the standby database.
*Action: Cancel the media recovery session and close the standby database.
10458, 00000, "standby database requires recovery"
*Cause: A standby database was in a state requiring media recovery
when an attempt was made to open the standby database.
*Action: Perform the necessary recovery and open the standby database.
10459, 00000, "cannot start media recovery on standby database; conflicting state detected"
*Cause: An attempt was made to perform media recovery on a standby
database while another instance was performing recovery on
the standby database, had the standby database open, or a data file
move operation was in progress.
*Action: Close the standby on all other instances, cancel any conflicting
recovery session or data file move operation, and perform manual
recovery.
10460, 00000, "Perform backward tablescans for consistent read reduction"
Events 10461 - 10489 reserved for recovery, incl debugging and tracing
10461, 00000, "Simulate control file corruption during write operation"
If set, will cause control file header verification to fail
10462, 00000, "enable recovery debug module"
Set this event to enable recovery debug module.
Recovery debug module does extra sanity checks on redo
generation and dumps interesting information to trace
if certain errors occur.
10463, 00000, "enable controlfile test"
Set this event to enable controlfile sequence number dump
at instance shutdown (level 1), future version controlfile
compatibility test (level 2), or cf backup creation (level 3)
10464, 00000, "enable incremental checkpoint debug for split brain check"
Set this event to enable checkpoint heartbeat tracing
10465, 00000, "force slave death during parallel crash recovery"
10466, 00000, "enable HARD check for block write"
Set this event to enable HARD check for every block write.
10467, 00000, "amplify control file record expansion for testing"
Set this event to amplify control file record expansion for testing
10468, 00000, "log writer debug module"
Set this event to the appropriate level for log writer debugging.
10469, 00000, "error creating control file backup, no checkpoint"
*Cause: The control file being backed up did not
contain a valid control file checkpoint.
Therefore the control file could not be backed up,
as such a backup would not be usable later for recovery.
A common cause for this situation is that you executed
CREATE CONTROLFILE, which mounts the database,
but not ALTER DATABASE OPEN, to open the database.
The latter operation generates a valid control file checkpoint.
*Action: Open the database with ALTER DATABASE OPEN ...,
which results in a valid control file checkpoint.
Run the backup operation again.
10470, 00000, "disable compatibility check for lost write detection"
Set this event to run database with lost write detection
enabled in compatibility mode below 11.0.
Level 1: equivalent of "typical" setting
Level 2: equivalent of "full" setting
for the parameter db_lost_write_protect
10471, 00000, "PQ slave allocation timeout test"
Set this event to enable the delay in PQ slave allocation.
If the delay is longer than the preset threshold (currently
1 minute), parallel recovery should switch to serial recovery.
10472, 00000, "dump reading log buffer hit ratio histogram to lgwr trace file"
Set this event to dump reading log buffer hit rate histogram
to lgwr trace file.
10473, 00000, "enable BRR tracing"
Set this event to enable tracing of Block Read Record generation.
10474, 00000, "controlfile time tracing"
Set this event to enable additional tracing of the time spent
in different controlfile operations.
10475, 00000, "readable standby debug event"
Set this event to enable additional tracing of readable standby.
10476, 00000, "control file corruption range testing"
Set this event to enable testing of control file
corruption ranges.
10477, 00000, "simulated rollback error"
Set this event to simulate a rollback failure.
10478, 00000, "DBW0 file identification trace event"
Set this event to enable DBW0 file identification tracing.
10479, 00000, "disk sector size test event"
Set this event to let OSD return a specified sector size
level 1: OSD returns 512 as the disk sector size
level 2: OSD returns 4096 (emulation) as the disk sector size
level 3: OSD returns 4096 (native) as the disk sector size
10480, 00000, "Soft asserts for fast detection of datafile storage problems"
Set this event to enable soft asserts to fire when a corrupt or
stale block is seen in some datafile mirrors. This event allows
for the proactive detection of datafile storage problems.
10481, 00000, "Backup data block for data file has an unlogged change"
*Cause: Flashback was enabled for the data file when the backup data block used
for block media recovery had an unlogged change.
*Action: Remove the data file from the flashback set or use a backup block that
does not contain an unlogged change to perform block media recovery.
10482, 00000, "Automatic block repair cannot repair an offline or read-only data file"
*Cause: Automatic block repair failed when trying to repair an offline or read-only
data file.
*Action: Bring the data file online in readwrite mode.
10483, 00000, "Simulate overly advanced incremental checkpoint"
Set this event to advance the incremental checkpoint so that dirty
buffers exist with low RBAs less than that of the checkpoint. This
scenario will be detected and the database will be crashed in a
recoverable state.
level 1: Generate error when linking buffer
level 2: Generate error when unlinking buffer
10484, 00000, "Enable test move operation"
Enable this event to test datafile move operation
10485, 00000, "Real-Time Query cannot be enabled while applying migration redo."
*Cause: The Real-Time Query feature was enabled when an attempt was made
to recover through migration redo generated during primary upgrades or
downgrades.
*Action: Close the standby database in order to recover through
migration redo. Reenable the Real-Time Query feature afterwards.
10486, 00000, "Verify data file-related SGA alignment"
*Cause:
*Action: Enable this event to verify data file-related SGA alignment.
10487, 00000, "Dump redo memory protection information."
Enable this event to dump the details about redo memory protection.
10488, 00000, "Dump block headers read for media recovery."
Enable this event to dump the block headers read during media
recovery before any redo application. If level is K_BTMAX+1, dump
all block types, otherwise dump only type equal to the event level.
10489, 00000, "Generate future redo for testing"
Internal testing only. Level of non-zero generates a future
informational redo change with opcode not known by this release.
Events 10490 - 10499 reserved for Oracle Storage Manager
10490, 00000, "Trace OSM misc. events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10491, 00000, "Trace OSM messaging (KFN) events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10492, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10493, 00000, "Return empty define buffers on 1422"
*cause
*action: On error 1422 instead of returning data in define buffers
this mimics action of version 7 and doesn't return data
valid level = 1
10494, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10495, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10496, 00000, "Turn off fix for bug 2554178"
*cause
*action: Instead of checking the current schema against the owner of the
db link revert to previous scheme
10497, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10498, 00000, "Trim blank characters including contol characters"
*Comment: Set this event to any non-zero level to trim blank characters
including control characters.
Default behaviour: No control characters are trimmed.
10499, 00000, "Trace OSM metadata events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10500, 00000, "turn on traces for SMON"
Level: <=5 trace instance recovery
> 5 trace posting of SMON
10501, 00000, "periodically check selected heap"
Level: 0x01 PGA
0x02 SGA
0x04 UGA
0x08 current call
0x10 user call
0x20 large allocation pool
10502, 00000, "CBO disable the fix for bug 2098120"
10503, 00000, "enable user-specified graduated bind lengths"
10504, 00000, "CBO disable the fix for bug 2607029"
10505, 00000, "CBO enable dynamic sampling dump to table"
10506, 00000, "Disable fix for bug 2588217"
10507, 00000, "Trace bind equivalence logic"
10509, 00000, "Check kghu subheaps at call boundaries"
Level: 0x01 Call heap
0x02 Session heap
10510, 00000, "turn off SMON check to offline pending offline rollback segment"
10511, 00000, "turn off SMON check to cleanup undo dictionary"
10512, 00000, "turn off SMON check to shrink rollback segments"
10515, 00000, "turn on event to use physical cleanout"
10519, 00000, "enable ALTER TYPE RESET support"
10520, 00000, "recreate view only if definition has changed"
Set this event only under the supervision of Oracle development
*Comment: Changes behaviour of create or replace view,
comparing the new definition to the old prior to recreating the
object. Creation is skipped if old and new definitions match
(ie. object has not changed). No level number required.
10521, 00000, "CMON connection pool test event"
*Comment:
10522, 00000, "turn off wrap source compression"
Set this event if you do not want source of wrapped PLSQL
objects to be concatenated and stored multiple lines to a row.
*Comment: This event should be set if you want the source of wrapped
PLSQL objects to be stored one line per source row. The
default storage method is multiple lines per row, which
improves load and compile performance. No level number
required.
10523, 00000, "force recreate package even if definition is unchanged"
Set this event only under the supervision of Oracle development
*Comment: Changes behaviour of create or replace package, procedure,
function or type to force recreation of the object even if its new
definition exactly matches the old definition.
No level number required.
10524, 00000, "CMON connection pool trace event"
*Comment:
10525, 00000, "Disable automatic object validation for describe"
10543, 00000, "Standby Block Media Recovery (bmr) and split brain testing event"
Set this event in order to test the situation where standby bmr
does not have the necessary redo to recover a block or the situation
where a split brain occurs during instancecrash recovery.
10544, 00000, "Inject standby autobmr failures"
Set this event to inject block failures that will trigger standby autobmr.
10545, 00000, "Print standby autobmr messages in alert log"
Set this event to print standby autobmr messages in alert log.
10546, 00000, "Cannot perform block media recovery; standby database does not have requisite redo."
*Cause: An attempt was made to perform block media recovery on the standby
database when the necessary redo was not available.
*Action: Wait until the necessary redo is available and reattempt block
media recovery.
10547, 00000, "Cannot perform block media recovery; standby database is not caught up with primary."
*Cause: An attempt was made to perform block media recovery on the standby
database up to scn %s, which is greater than the highest scn of %s
yet applied at the standby.
*Action: Recover the standby up to scn %s and reattempt block media
recovery.
10548, 00000, "Cannot perform block media recovery on a read-only plugged-in datafile."
*Cause: An attempt was made to perform block media recovery on a read-only
plugged-in datafile.
*Action: Convert the plugged-in datafile to readwrite and reattempt block
media recovery.
10549, 00000, "Cannot perform block media recovery using a read-only plugged-in backup datafile."
*Cause: An attempt was made to perform block media recovery using a backup
of a read-only plugged-in datafile.
*Action: Reattempt block media recovery using a backup taken after the
plugged-in datafile has been converted to readwrite.
10550, 00000, "signal error during create as selectcreate index after n rows"
set this event only under the supervision of Oracle development
*Comment: Set the level number to the number of rows before the error
is signalled. The error will be ORA-1013 (ctrl-c)
10551, 00000, "Internal testing for ORA-1551 error handling"
10552 -10589 reserved for recoverable mediastandby recovery
10553, 00000, "Incompatible UNTIL CONSISTENT clause"
*Cause: RECOVER UNTIL CONSISTENT required database-level recovery with
a backup control file.
*Action: Omit the UNTIL CONSISTENT clause and retry recovery.
10554, 00000, "Media recovery failed to bring datafile %s to a consistent point"
*Cause: Media recovery couldn't recover database to a consistent point due
to the specified datafile.
*Action: Restore a backup of the datafile.
10555, 00000, "Disable redo dumping"
10558, 00000, "Disable unkeep marker handling for ADG"
Set this event on primary to disable generation of Exadata flash
cache unkeep marker. Set this event on ADG standby to ignore
such marker and always pass KCBF_DEF_CL_CACHE to cell.
10560, 00000, "block type '%s'"
*Cause: Report block type for details of another error.
*Action: See associated error message.
10561, 00000, "block type '%s', data object# %s"
*Cause: Report block type and data object number for details of
another error.
*Action: See associated error message.
10562, 00000, "Error occurred while applying redo to data block (file# %s, block# %s)"
*Cause: See other errors on error stack.
*Action: Investigate why the error occurred and how important is the data
block. Media and standby database recovery usually can continue
if user allows recovery to corrupt this data block.
10563, 00000, "Test recovery had to corrupt data block (file# %s, block# %s) in order to proceed"
*Cause: Test recovery completed.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary of the result
of the test recovery.
10564, 00000, "tablespace %s"
*Cause: Report tablespace name for details of another error.
*Action: See associated error message.
10565, 00000, "Another test recovery session is active"
*Cause: There can only be one test recovery session at any time.
Another test recovery session is active.
*Action: Wait till the other test recovery session completes.
10566, 00000, "Test recovery has used all the memory it can use"
*Cause: Test recovery tests redo in memory. It can no longer proceed
because it has consumed all the memory it can use.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary result
of the test recovery.
10567, 00000, "Redo is inconsistent with data block (file# %s, block# %s, file offset is %s bytes)"
*Cause: There are two possible causes of this error: (1) A write issued
by Oracle was lost by the underlying OS or storage system.
(2) an Oracle internal error.
*Action: Investigate why the error occurred and how important is the data
block. Media and standby database recovery usually can continue
if user allows recovery to corrupt this data block.
10568, 00000, "Failed to allocate recovery state object: out of SGA memory"
*Cause: out of SGA memory
*Action: Restart the instance. If problem persists, call Oracle support.
10570, 00000, "Test recovery complete"
*Cause: Test recovery completed.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary result
of the test recovery.
10571, 00000, "Test recovery canceled"
*Cause: User canceled test recovery.
*Action: No action is needed. Test recovery has ended successfully.
See other messages on error stack for a summary of the result
of the test recovery.
10572, 00000, "Test recovery canceled due to errors"
*Cause: See other errors on the error stack.
*Action: See other messages on error stack. It is possible that no
action is needed. See other messages on error stack for a
summary of the result of the test recovery so far.
10573, 00000, "Test recovery tested redo from change %s to %s"
*Cause: This message show the range of test recovery have tested.
*Action: No action is needed. See other messages on error stack.
10574, 00000, "Test recovery did not corrupt any data block"
*Cause: This message summarizes test recovery result.
*Action: No action is needed. See other messages on error stack.
10575, 00000, "Give up restoring recovered datafiles to consistent state: out of memory"
*Cause: There were not enough memory to restore recovered datafiles
to consistent state
*Action: This error is just a warning: You may not be able to open the
database with resetlogs immediately after this error. However,
you may continue mediastandby recovery, and that may make the
datafiles recovered consistent again.
10576, 00000, "Give up restoring recovered datafiles to consistent state: some error occurred"
*Cause: See alert file or other errors on the stack for a cause of the
problem.
*Action: This error is just a warning: You may not be able to open the
database with resetlogs immediately after this error. However,
you may continue mediastandby recovery, and that may make the
datafiles recovered consistent again.
10577, 00000, "Can not invoke test recovery for managed standby database recovery"
*Cause: Test recovery option is used for managed standby database recovery.
*Action: Either remove the test recovery option or invoke manual test
standby database recovery.
10578, 00000, "Can not allow corruption for managed standby database recovery"
*Cause: You used the allow corruption option for managed standby database
recovery.
*Action: Either remove the allow corruption option or invoke manual
standby database recovery.
10579, 00000, "Can not modify control file during test recovery"
*Cause: To proceed with recovery, test recovery needs to modify the
control file. But test recovery is not allowed to modify
control file.
*Action: No action is needed. Test recovery has ended successfully.
It can only go so far in the redo stream.
10580, 00000, "Can not modify datafile header during test recovery"
*Cause: To proceed with recovery, test recovery needs to modify a
datafile header. But test recovery is not allowed to modify
datafile headers.
*Action: No action is needed. Test recovery has ended successfully.
It can only go so far in the redo stream.
10581, 00000, "Can not modify redo log header during test recovery"
*Cause: To proceed with recovery, test recovery needs to modify a
redo log header. But test recovery is not allowed to modify
redo log headers.
*Action: No action is needed. Test recovery has ended successfully.
It can only go so far in the redo stream.
10582, 00000, "The control file is not a backup control file"
*Cause: User requested backup control file test recovery, but the
control file is not a backup control file.
*Action: Use a backup control file, or do not use USING BACKUP
CONTROLFILE option.
10583, 00000, "Can not recovery file %s renamed as missing during test recovery"
*Cause: One of the files to be recovered is renamed as missing.
*Action: Rename the file to the correct file or offline it.
10584, 00000, "Can not invoke parallel recovery for test recovery"
*Cause: Both test recovery and parallel recovery are requested.
*Action: Drop either one of the two recovery options.
10585, 00000, "Test recovery can not apply redo that may modify control file"
*Cause: Test recovery has encountered a special redo that may modify
control file.
*Action: No action is needed. Test recovery has proceeded successfully
as far as it could from its starting point.
10586, 00000, "Test recovery had to corrupt 1 data block in order to proceed"
*Cause: This message summarizes test recovery result: Oracle may have
to corrupt one block in order to apply the range of redo tested.
*Action: See alert log for details of the problem.
10587, 00000, "Invalid count for ALLOW n CORRUPTION option"
*Cause: The number specified in the ALLOW n CORRUPTION option is too big.
*Action: Use a smaller number.
10589, 00000, "Test recovery had to corrupt %s data blocks in order to proceed"
*Cause: This message summarizes test recovery result: Oracle may have
to corrupt a number of data blocks as specified in the message
in order to apply the range of redo tested.
*Action: See alert log for details of the problems.
10590, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10591, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10592, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10593, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10594, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10595, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10596, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10597, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10598, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10599, 00000, "kga (argus debugger) test flags"
set this event only under the supervision of Oracle development
10600, 00000, "check cursor frame allocation"
10601, 00000, "turn on debugging for cursor_sharing (literal replacement)"
10603, 00000, "cause an error to occur during truncate (for testing purposes)"
set this event only under the supervision of Oracle development
*Comment: this causes kdifrb to encounter an error during truncation of a
table with an index. it is for testing purposes only.
10604, 00000, "trace parallel create index"
set this event only under the supervision of Oracle development
*Comment: enables analysis of parallel create index
10605, 00000, "enable parallel create index by default"
set this event only under the supervision of Oracle development
*Comment: this causes all create index statement to by default
occur in parallel. it is for testing purposes only.
the level set in the event is the degree of parallelism.
*Comment: enables analysis of parallel create index - query coordinator
10606, 00000, "trace parallel create index"
set this event only under the supervision of Oracle development
*Comment: enables analysis of parallel create index - kkri slaves
10607, 00000, "trace index rowid partition scan"
set this event only under the supervision of Oracle development
*Comment: enables analysis of rowid index scan - rix row source,
and puts more trace on errors in range scans
10608, 00000, "trace create bitmap index"
set this event only under the supervision of Oracle development
*Comment: enables analysis of create bitmap index - kkrb row source
10609, 00000, "trace for array index insertion"
set this event to turn off the index array operation
*Comment: disable the index array operation
10610, 00000, "trace create index pseudo optimizer"
set this event only under the supervision of Oracle development
10611, 00000, "causes migration to fail - testing only"
set this event only under the supervision of Oracle development
10612, 00000, "prints debug information for auto-space managed segments"
10613, 00000, "prints debug information for auto-space managed segments"
10614, 00000, "Operation not allowed on this segment"
*Cause: This procedure can be used only on segments in
tablespaces with AUTO SEGMENT SPACE MANAGEMENT
*Action: Recheck the segment name and type and re-issue the statement
10615, 00000, "Invalid tablespace type for temporary tablespace"
*Cause: Tablespace with AUTO SEGMENT SPACE MANAGENEMT specified cannot be
used as a temporary tablespace
*Action: Recheck the tablespace name and re-issue the statement
10616, 00000, "Operation not allowed on this tablespace"
*Cause: Cannot perform the operation on tablespace with AUTO
SEGMENT SPACE MANAGEMENT
*Action: Recheck the tablespace name and re-issue the statement
10617, 00000, "Cannot create rollback segment in dictionary managed tablespace"
*Cause: Rollback segments cannot be created in dictionary managed
tablespaces when SYSTEM tablespace is locally managed
*Action: Recheck the tablespace name and re-issue the statement
10618, 00000, "Operation not allowed on this segment"
*Cause: This DBMS_SPACE operation is not permitted on segments in
tablespaces with AUTO SEGMENT SPACE MANAGEMENT
*Action: Recheck the segment name and type and re-issue the statement
10619, 00000, "Avoid assertions when possible"
*Cause: A bug (or upgrade) hits unicode assertions (csid, csform, bfc)
*Action: Event makes RDBMS skip assertions and patch up datastructures
10620, 00000, "Operation not allowed on this segment"
*Cause: Cannot alter freelist storage parameter for segments in tablespaces
with AUTO SEGMENT SPACE MANAGEMENT
*Action: Recheck the segment name and re-issue the statement
10621, 00000, "specify retry count for online index build cleanup DML lock get"
set this event only under the supervision of Oracle development
*Comment: Change the behaviour of online index build cleanup such that
a failed DML lock get will be reattempted. The number of retries
is dictated by the event level. Note that an event level of 1
means try forever. Any other event level specifies the number
of attempts, and is internally increased to some minimum default.
10622, 00000, "test or trace online index build or rebuild"
*Cause:
*Action: Set this event only under the supervision of Oracle development.
10623, 00000, "test synchronized flow of SORT rows into FOR UPDATE lock phase"
*Cause:
*Action: Set this event only under the supervision of Oracle development.
10624, 00000, "Disable UJV invalidation on drop index"
set this event only under the supervision of Oracle development
10625, 00000, "Turn off redo log dump for the index when OERI 12700"
set this event only under the supervision of Oracle development
10626, 00000, "specify timeout for online index rebuild to wait for DML"
set this event only under the supervision of Oracle development
*Comment: Change the behaviour of an online index rebuild such that it
will timeout, rather than wait indefinitely for existing DML
to complete.
The event level is the number of seconds the online index rebuild
should wait. Values outside the legal range of 2 to 300 seconds
will be adjusted automatically.
10627, 00000, "Dump the content of the index leaf block"
*Cause: Generate a complete index tree dump, not just an overview
during alter session set events immediate trace name treedump
*Action: This event is recommended only for small tableindex since it
dumps very detail information of every keys in the index
10628, 00000, "Turn on sanity check for kdiss index skip scan state"
*Cause: Will do sanity checking on the kdiss state.
*Action: set this event only under the supervision of Oracle development
10629, 00000, "force online index build to backoff and retry DML lock upgrade"
set this event only under the supervision of Oracle development
*Comment: Change the behaviour of an online index rebuild such that it
will backoff and retry a failed DML lock upgrade.
The event level is the number of retries the online index rebuild
should wait. Level 1 means backoff and retry indefinitely. Any
other value less than 32 will be adjusted automatically to be 32.
10630, 00000, "Illegal syntax specified with SHRINK clause"
*Cause: An illegal option was specified with the SHRINK clause
*Action: Verify the SQL Reference Manual and reissue the command
10631, 00000, "SHRINK clause should not be specified for this object"
*Cause: It is incorrect to issue shrink on the object
*Action: Verify the object name and type and reissue the command
10632, 00000, "Invalid rowid"
*Cause: Segment Highwatermark was overwritten due to shrink and space reused
*Action: Reissue this command.
10633, 00000, "No space found in the segment"
*Cause: Raised while trying to find space during segment shrink
*Action: This error should be trapped internally and treated. The user should
not be able to see the error.
10634, 00000, "Segment is already being shrunk"
*Cause: Only one invocation of shrink can be in progress on a segment at any time
*Action: Reissue the command after the first shrink is over
10635, 00000, "Invalid segment or tablespace type"
*Cause: Cannot shrink the segment because it is not in auto segment space
managed tablespace or it is not a data, index or lob segment.
*Action: Check the tablespace and segment type and reissue the statement
10636, 00000, "ROW MOVEMENT is not enabled"
*Cause: To shrink a data segment, row movement must be enabled.
*Action: Enable row movement and reissue this command.
10637, 00000, "The segment does not exist"
*Cause: Segment to be shrunk has been dropped
*Action:
10638, 00000, "Index status is invalid"
*Cause: Cannot shrink an index which is being rebuilt or disabled
is an unusable state.
*Action:
10639, 00000, "Dump library cache during reparse loops"
*Cause: During this error a library cache dump is necessary , so enable
librarycache dump if event is set.
*Action: Dump a library cache if this event is set when reparse error.
10640, 00000, "Operation not permitted during SYSTEM tablespace migration"
*Cause: SYSTEM tablespace is being migrated to locally managed format.
*Action: Reissue this command once SYSTEM tablespace migration is over.
10641, 00000, "Cannot find a rollback segment to bind to"
*Cause: SYSTEM tablespace migration requires rollback segment in locally
managed tablespace.
*Action: Drop rollback segments in dictionary managed tablespaces other than
SYSTEM and create rollback segments in locally managed tablespace
and retry migration.
10642, 00000, "Found rollback segments in dictionary managed tablespaces"
*Cause: When SYSTEM tablespace is migrated found rollback segments in
dictionary managed tablespaces.
*Action: Drop the rollback segments in dictionary managed tablespaces and
reissue the command
10643, 00000, "Database should be mounted in restricted mode and Exclusive mode"
*Cause: When SYSTEM tablespace is being migrated database should be mounted
in Exclusive mode and in Restricted mode.
*Action: Reissue this command after mounting the database in right mode.
10644, 00000, "SYSTEM tablespace cannot be default temporary tablespace"
*Cause: When SYSTEM tablespace is being migrated no user should have
SYSTEM as the default temporary tablespace.
*Action: Reissue this command after altering the default temporary
tablespace setting for all users.
10645, 00000, "Recursive Extension in SYSTEM tablespace during migration"
*Cause: When SYSTEM tablespace is being migrated, dictionary tables tried
to extend recursively. Must be caught and processed internally.
Should not be thrown to the user.
*Action: Report the error as a bug.
10646, 00000, "Too many recursive extensions during SYSTEM tablespace migration"
*Cause: When SYSTEM tablespace is being migrated, dictionary tables tried
to extend recursively more than 1000 times.
*Action: If SYSTEM tablespace is very large, then simply reissue the
tablespace migration command.
10647, 00000, "Tablespace other than SYSTEM, %s, %s not found in read only mode"
*Cause: When SYSTEM tablespace is being migrated, tablespaces other than
the three should be ALTERed to read only.
*Action: Alter the tablespace status to read only and retry migration.
10648, 00000, "Tablespace SYSAUX is not offline"
*Cause: The SYSAUX tablespace
was online while SYSTEM tablespace was being migrated.
*Action: Alter the SYSAUX tablespace status to offline and retry migration.
10649, 00000, "Turn offtrace lob index freelist coalesce"
*Cause: Will turn off or trace lob index freelist coalescing
*Action: set this event only under the supervision of Oracle development
10650, 00000, "disable cache-callback optimisation"
set this event only under the supervision of Oracle development
10651, 00000, "incorrect file number block number specified"
*Cause: The dba specified is not valid
*Action: Check if the dba specified belongs to the segment and is under the
segment HWM and reissue the statement
10652, 00000, "Object has on-commit materialized views"
*Cause: It is illegal to issue shrink on an object with on-commit
materialized views
*Action:
10653, 00000, "Table is in a cluster"
*Cause: It is illegal to shrink a table belonging to a cluster
*Action:
10654, 00000, "Table is of type temporary or external"
*Cause: It is illegal to shrink a temporary table or an external table
*Action:
10655, 00000, "Segment can be shrunk"
*Cause: Error message returned when called in probe mode by OEM
*Action:
10656, 00000, "Table is in unusable state due to incomplete operation"
*Cause: ALTER TABLE SHRINK operation was tried on the table which is in
unusable state because of previously failedincomplete operation.
*Action: If the previous operation was
- DROP COLUMN, resubmit DROP COLUMN CONTINUE
- DROP TABLE, resubmit DROP TABLE <table> PURGE
10657, 00000, "Lob column to be shrunk does not exist"
*Cause: Shrink was issued on a lob segment that did not exist
*Action:
10658, 00000, "Lob column to be shrunk is marked unused"
*Cause: Shrink was issued on a lob segment that is marked as unused
*Action:
10659, 00000, "Segment being shrunk is not a lob"
*Cause: Shrink was issued on a segment that should be a first class lob
or other data type stored in lob
*Action:
10660, 00000, "Segment is a shared lob segment"
*Cause: Shrink was issued on a segment that was being shared by multiple
lob columns
*Action:
10661, 00000, "Invalid option specified"
*Cause: Check option can be specified for one segment only
*Action:
10662, 00000, "Segment has long columns"
*Cause: Shrink was issued on a segment with long columns. This is not
supported.
*Action:
10663, 00000, "Object has rowid based materialized views"
*Cause: Shrink was issued on an object with rowid based materialized
views.
*Action: Drop the rowid based materialized views and issue shrink on the
object
10664, 00000, "Table has bitmap join indexes"
*Cause: SHRINK was issued on a table with bitmap join indexes.
*Action: Drop bitmap join indexes and reissue SHRINK on the object.
10665, 00000, "Inject Evil Literals"
*Cause: Event 10665 is set to some number > 0, causing 1(value-1) of all
literals to be replaced by 2000 letter 'A's. A value of 1 does
not corrupt anything.
*Action: never set this event
10666, 00000, "Do not get database enqueue name"
10667, 00000, "Cause sppst to check for valid process ids"
10668, 00000, "Inject Evil Identifiers"
*Cause: event 10668 is set to some number > 0, causing 1(value-1) of all
identifiers to be replaced by a maximum amount of x's. It is
common for an identifier to be parsed once with a max of 30 bytes,
then reparsed later with a max of 4000, so it may not be possible
to inject such an identifier without the aid of this event. A
value of 1 causes no identifiers to be corrupted.
*Action: never set this event
10690, 00000, "Set shadow process core file dump type (Unix only)"
*Cause: Control core file size for shadow processes
*Action: Level 1: Detach SGA before dumping core
Level 2: Do not produce any core
10691, 00000, "Set background process core file type (Unix only)"
*Cause: Control core file size file for background processes
*Action: Level 1: Detach SGA before dumping core
10700, 00000, "Alter access violation exception handler"
*Cause: Use this event to control what the VMS exception handler
does when it encounters an access violation.
*Action:
Level: >=10 Suspend current process on access violation
*** SET THIS EVENT ONLY UNDER THE SUPERVISION OF ORACLE DEVELOPMENT ***
10701, 00000, "Dump direct loader index keys"
*Cause: Dumps index keys at various points in a direct load based on the
value of this event.
*Action:
*Comment: This is bit mask, interpreted as follows:
0x01: dump all keys as they are being built (use judiciously,
as this generates a lot of data!)
0x02: dump index keys which cause OER(1), OER(1409), OER(1452)
errors.
10702, 00000, "Application continuity debugging was not enabled."
*Cause: Application continuity debugging was not enabled.
*Action: Enable application continuity debugging.
Level: 0x0001: Transaction intention debugging
10704, 00000, "Print out information about what enqueues are being obtained"
*Cause: When enabled, prints out arguments to calls to ksqcmi and
ksqlrl and the return values.
*Action: Level indicates details:
Level: 1-4: print out basic info for ksqlrl, ksqcmi
5-9: also print out stuff in callbacks: ksqlac, ksqlop
10+: also print out time for each line
10706, 00000, "Print out information about global enqueue manipulation"
*Cause: When enabled, prints out activity in ksi routines.
*Action: INternal system parameter (_ksi_trace) can be used in addition
to setting this event to limit output information on selected
set of global enqueue server enqueue type(s)
For example:
_ksi_trace = RTXA
output information only for RT and XA lock types.
*Action: Level indicates details:
0-4: show args for each main call
5-9: also indicate callbacks
10+: also printout time for each line
10707, 00000, "Simulate process death for instance registration"
*Cause: When enabled, process commits suicide to test instance
registration recovery code.
*Action: Level indicates where the process will die
10708, 00000, "print out trace information from the RAC buffer cache"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10709, 00000, "enable parallel instances in create index by default"
set this event only under the supervision of Oracle development
*Comment: this causes all create index statement to by default
use multiple instances. it is for testing purposes only.
the level set in the event is the number of instances.
*Comment: enables analysis of parallel create index - query coordinator
10710 - 10729 are Reserved for BITMAP row sources
10710, 00000, "trace bitmap index access"
set this event only under the supervision of Oracle development
*Comment: display the start-rowid, end-rowid of each bitmap segment - kkrbx
row source
10711, 00000, "trace bitmap index merge"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index merge - kkrbu row source
10712, 00000, "trace bitmap index or"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index or - kkrbo row source
10713, 00000, "trace bitmap index and"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index and - kkrba row source
10714, 00000, "trace bitmap index minus"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index minus - kkrbm row source
10715, 00000, "trace bitmap index conversion to rowids"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index merge - kkrbt row source
10716, 00000, "trace bitmap index compressdecompress"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index compressiondecompression -
modules kdibc, kdibci, kdibco, kdibc3
10717, 00000, "trace bitmap index compaction trace for index creation"
set this event only under the supervision of Oracle development
*Comment: enables analysis of bitmap index creation -
modules kkrbc
10718, 00000, "event to disable automatic compaction after index creation"
set this event only under the supervision of Oracle development
*Comment: enables isolation of index creation problems. ie compaction
is an optional part of the index creation algorithem which
improves query performance and shrinks index size
modules kkrbc
10719, 00000, "trace bitmap index dml"
set this event only under the supervision of Oracle development
*Comment: enables analysis of inserts update and deletes into tables
with bitmap indexes
modules kkrbc
10720, 00000, "trace db scheduling"
set this event only under the supervision of Oracle development
*Comment: traces db scheduling
10721, 00000, "Internal testing - temp table transformation"
10722, 00000, "set parameters for CPU frequency calculation (debug)"
set this event only under the supervision of Oracle development
*Comment: changes parameters for CPU frequency calculation
10723, 00000, "Internal testing - release buffer for buffer cache shrink"
10724, 00000, "trace cross-instance broadcast"
set this event only under the supervision of Oracle development
*Comment: enables tracing of cross-instance broadcast (KSXR)
10725, 00000, "bitmap index version control"
Set this event only under the supervision of Oracle development.
The trace level is a bitfield, so use it as you would a flag.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 For bitmap indexes with version 0, DML on these bitmap
indexes will be same as with 9i releases (that is, it
simulates the bitmap index DML of previous releases).
10726, 00000, "frequent itemset counting"
set this event only under the supervision of Oracle development
*Comment: enables tracing of internal execution of frequent itemset
counting
10727, 00000, "introduce failure events in IPC"
Internal testing only.
*Comment:
10730 - 10800 general debugging events
10730, 00000, "trace row level security policy predicates"
*Comment:
10731, 00000, "dump SQL for CURSOR expressions"
set this event only under the supervision of Oracle development
*Comment: traces SQL statements generated to execute CURSOR expressions
10732, 00000, "honor pctfree during insert into AQ IOTs"
set this event only under the supervision of Oracle development
*Comment: If set, then we will honor pctfree, during SQL INSERTs and direct
kdiins0 calls from AQ, for IOTs that are used as AQ queue tables.
10733, 00000, "test transient-IOT metadata during PMO cleanup"
set this event only under the supervision of Oracle development
*Comment: causes an internal error to be raised if inconsistent metadata
is detected during cleanup of transient-IOTs which were left
behind by failed Partition Maintenance Operations. Enable this
event only during testing.
10734, 00000, "reroute external procedures"
set this event only under the supervision of Oracle development
*Comment: execute external procedures using plsql
10735, 00000, "debug ksws operations"
set this event only under the supervision of Oracle development
*Comment: Causes debug trace to be dumped for ksws routines
10736, 00000, "buffer cache pin history dump"
Set this event only under the supervision of Oracle development.
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Force redo dump during buffer pin history dump
0x0002 Disable redo dump during buffer pin history dump
0x0004 Print diagnostic text for the redo dump
10737, 00000, "test block checking"
Set this event only under the supervision of Oracle development.
*Comment: Internal testing event for block checking.
10738, 00000, "internal block testing"
Set this event only under the supervision of Oracle development.
10739, 00000, "debug WLM (kywm) operations"
set this event only under the supervision of Oracle development
*Comment: Causes debug trace to be dumped for kywm routines
10740, 00000, "disables fix for bug 598861"
set this event only under the supervision of Oracle development
*Comment: disables fix for bug 598861. The fix changes slightly the cost
estimations for set queries in views, and thereby
changes query plans from previous versions
modules vop
10741, 00000, "trace missing BRR generation"
Set this event only under the supervision of Oracle development.
Trace level is a bit field.
LEVEL ACTION
---------------------------------------------------------------------------
0x0000 Default of tracing missing BRR after 3 attempts
0x0001 Disable default of tracing missing BRR after 3 attempts
0x0002 Trace missing BRR due to Oracle RAC pings
0x0003 Disable default of tracing missing BRR after 3 attempts and
trace missing BRR due to Oracle RAC pings
10742, 00000, "dump process state on flush buffer_cache"
Set this event only under the supervision of Oracle development.
*Comment: Causes a process state to be dumped on ALTER SYSTEM FLUSH
BUFFER_CACHE.
10750, 00000, "test rollback segment blksize guessing for index array insert"
set this event only under the supervision of Oracle development
*Comment: causes internal error to be raised if a transaction
repeatedly (100 times) fails to bind to a rollback segment
because block size is too small. (Default behaviour is to
silently assume the minimum database block size possible after
that many failures). Enable this event only during testing.
10751, 00000, "override for remote row source maximum buffer size"
set this event only under the supervision of Oracle development
*Comment: To change the default value of 256000.
10752, 00000, "override for the Exponential Moving Average factor"
set this event only under the supervision of Oracle development
*Comment: To change the default value of 50%.
10753, 00000, "enforce deterministic behaviour for prefetching row source"
set this event only under the supervision of Oracle development
*Comment: prefetch will disregard buffer cache state and be deterministic
based on level set
Trace level is a bitfield.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Always enable prefetching
0x0002 Always disable prefetching
0x0004 Print diagnostic text for each of the above levels, ie
use level 5 to trace enabling and level 6 to trace disabling.
10754, 00000, "disable fix for bug 14173995 for multi-table select for update"
set this event only under the supervision of Oracle development
10780 - 10785 Reserved for LogMiner
10780, 00000, "LogMiner API trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer internal api
10781, 00000, "LogMiner reader trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer reader process
10782, 00000, "LogMiner preparer trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer preparer process
10783, 00000, "LogMiner builder trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer builder process
10784, 00000, "LogMiner dictionary trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst tracing of logminer dictionary
10785, 00000, "LogMiner trace event"
set this event only under the supervision of Oracle development
10786 - 10788 Reserved for ks*
10786, 00000, "call pushpop (KSU)"
set this event only under the supervision of Oracle development
*Comment: enables tracing of call pushpop operations
10787, 00000, "trace intra-instance broadcast"
set this event only under the supervision of Oracle development
*Comment: enables tracing of intra-instance broadcast (KSR)
10788, 00000, "trace call stacks"
set this event only under the supervision of Oracle development
*Comment: enables tracing of call stack info
10789 - 10790 Reserved for LogMiner
10789, 00000, "LogMiner test event"
set this event only under the supervision of Oracle development
*Comment: changes logminer behavior for testing
10790, 00000, "LogMiner trace event"
set this event only under the supervision of Oracle development
10791 - 10799 Reserved for Logical Standby
10791, 00000, "Logical Standby swithoverfailover trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst trancing of switchover and failover in logical
10792, 00000, "Logical Standby XDAT trace event"
set this event only under the supervision of Oracle development
*Comment: enables kst trancing os XDAT usage
10793, 00000, "Logical Standby trace event"
set this event only under the supervision of Oracle development
10794, 00000, "Logical Standby trace event"
set this event only under the supervision of Oracle development
10795, 00000, "VKTM Process trace event"
Set this event only under the supervision of Oracle Support Services.
*Comment: enable ksdkst tracing for VKTM process
10796, 00000, "Elevate Scheduler Priority trace event"
Set this event only under the supervision of Oracle development
*Comment: enable ksd tracing for elevaterevert process scheduler priority
10797, 00000, "Logical Standby Test Event"
Set this event only under the supervision of Oracle development.
*Comment: changes logical standby behavior for testing
10800, 00000, "disable Smart Disk scan"
10804, 00000, "reserved for ksxb"
10806, 00000, "Switch to 7.3 mode when detaching sessions"
10807, 00000, "Disable user id check when switching to a global transaction"
10808, 00000, "Enable assert when waiting without a reason"
Set this event only under the supervision of Oracle development
*Comment: This event will catch clients that call kslwait without providing
any wait reason (see bug 1743159).
10809, 00000, "Trace state object allocate free history"
Set this event only under the supervision of Oracle development
*Comment: This event will trace the history of KSS allocations deletions.
level: 0 = disabled, 1 = cleanup only, 2 = always
10810 - 10825 Reserved for OLTP
10810, 00000, "Trace snapshot too old"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10811, 00000, "Trace block cleanouts"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10812, 00000, "Trace Consistent Reads"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10826 - 10829 Reserved for upgradedowngrade
10826, 00000, "enable upgradedowngrade error message trace"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10827, 00000, "enable upgradedowngrade diagnostics"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10828, 00000, "memory allocator error"
*Cause: Error in the memory allocator
*Action: Check the trace files and other relevant output
10830 - 10838 Reserved for sort and aggregation row sources
10830, 00000, "Trace group by sort row source"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace adaptive fetch usage
0x0002 trace exceptions during aggregation
0x0004 trace use of one comparison for all key columns
10831, 00000, "Trace group by rollup row source"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace use of one comparison for all key columns
10832, 00000, "Trace approximate NDV row source"
set this event only under the supervision of Oracle development.
trace level is a bitfield
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace
10839, 00000, "trace debug caching module (qesca.c)"
*Cause:
*Action: Set this event only under the supervision of Oracle Development.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace debug caching
0x0002 dump probe retrieve insert cache values
10840, 00000, "trace debug plsql caching module (kkxmInitCache)"
*Cause:
*Action: Set this event only under the supervision of Oracle Development.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 trace debug plsql caching
10841 - 10849 Reserved for OCI
10841, 00000, "Default un-inintialized charact set form to SQLCS_IMPLICIT"
*Cause: client side, such as JDBC-THIN 8i client sends 0 as charset form
*Action: This event sets charset form as SQLCS_IMPLICIT when it is 0
10842, 00000, "Event for OCI Tracing and Statistics Info"
*Cause: This event is meant for tracing OCI Calls and getting statistics
*Action: This event sets tracing OCI Calls and gets statistics info
10843, 00000, "Event for client result cache tracing"
*Cause: This is an internal event.
*Action: NA
10844, 00000, "turn on Native Net IPC debugging (skgxp)"
Enables debugging code for Native Net IPC (skgxp)
10845, 00000, "Enable Director tracing"
*Action: Enable tracing of directorworkload manager packages
10846, 00000, "Enable Director Single Node Testing"
*Action: Enable Single Node Testing
10847, 00000, "OCI dump action is being invoked for internal error ORA-%s"
*Cause: An internal error was encountered or EVENT_10842 was set to
level 8 or higher which dumped the OCI process state, current
state and the stack trace.
*Action: Disable EVENT_10842. If disabled, contact Oracle Support for the
internal error.
10848, 00000, "OCI Non Blocking not supported with %s"
*Cause: Attempt made to set connection as non-blocking with another
feature that does not support non-blocking.
*Action: Use blocking connection.
10849, 00000, "Internal OCI event number"
*Cause: NA
*Action: Set this event only under the supervision of Oracle Support
or Development. This event enable compatible behavior with
sending describe information when a cursor rebuilt.
10850 - 10869 Reserved for AQ
10850, 00000, "Enable time manager tracing"
10851, 00000, "Allow Drop command to drop queue tables"
*Cause: re-enable SQL Drop DDL for queue tables.
*Action: last resort to drop queue table if all other options fail. The
user have to manually cleanup AQ's metadata after this operation.
10852, 00000, "Enable tracing for Enqueue Dequeue Operations"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10854, 00000, "Sets poll count used for AQ listen code under RAC"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10856, 00000, "Disable AQ propagator from using streaming"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10857, 00000, "Force AQ propagator to use two-phase commit"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10858, 00000, "Crash the AQ propagator at different stages of commit"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10859, 00000, "Disable updates of message retry count"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DISABLING THE RETRY
FEATURE IN THE EVENT THAT IT CAUSES OTHER INTERNAL ERRORS.
10860, 00000, "event for AQ admin disable new name parser"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
THIS EVENT IS NOT TO BE TURNED ON BY ANY CUSTOMER. DOING SO,
MAY CAUSE AQ DICTIONARY CORRUPTION
10861, 000000, "disable storing extended message properties"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY TO DISABLE STORING
NEW MESSAGE PROPERTIES SUCH AS SENDER_ID AND ORIGINAL_MESSAGE_ID.
10862, 00000, "resolve default queue owner to current user in enqueuedequeue"
*Cause: resolve default queue owner to current user in enqueuedequeue.
*Action: turn on if client wish to resolve the default queue owner to the
current user. If not turned on, the default queue owner will be
resolved to the login user.
10863, 00000, "Control behavior of buffered background operations"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10864, 00000, "event to enable AQ dedicated propagation"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, ONE JOB QUEUE
PROCESS WILL PROPAGATE FOR ONLY ONE PROPAGATION SCHEDULE
10865, 00000, "Control tracing of notification operations"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10866, 00000, "event to order dequeue by condition"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, THE DEQUEUE
ORDER THE MESSAGES BASED ON CONDITION.
10867, 00000, "turn off authentication for emon to oci client and disable HA rstat"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, THERE IS NO
MUTUAL AUTHENTICATION BETWEEN EMON AND OCI CLIENTS IF SET AT LEVEL 1
AND LEVEL 2 IS USED FOR DISABLING THE UPDATION OF REGISTRATION
STATISTICS FOR HA NOTIFICATIONS
10868, 00000, "event to enable interop patch for AQ enqueue options"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. WHEN THIS EVENT IS SET, AQ DOES NOT
USE ENQUEUE OPTIONS FOR PROPAGATION.
10870 - 10879 Reserved for recovery layer
10870, 00000, "Disable multi-instance standby role transition"
For testing purposes
10871, 00000, "dump file openclose timestamp during media recovery"
For dumping purpose.
10872, 00000, "Flashback Database fault insertion event #%s."
*Cause: Causes faults to be inserted into Flashback Database code.
This should only be enabled for internal testing.
*Action: Level 1 - Die after restoring database, before shrinking
fuzziness.
Level 2 - Die after rstoring database and after shrinking
fuzziness.
Level 3 - Die after restoring control file.
Level 4 - Die after set cf checkpoint during an undo of a cf change
Level 5 - Die after restoring cf, before setting cf checkpoint
Level 6 - Force a block checksum error on a flashback log block
Level 7 - Force a file creation error during fb recovery
Level 8 - Force an error after fb recovery file recreation
Level 9 - Force and error during open resetlogs (after flashback)
10873, 00000, "file %s needs to be either taken out of backup mode or media recovered"
*Cause: An attempt was made to open a database after an instance failure or
SHUTDOWN ABORT interrupted an online backup.
*Action: If the indicated file is not a restored backup, then issue the
ALTER DATABASE END BACKUP command and open the database. If the
file is a restored online backup, then apply media recovery to
it and open the database.
10874, 00000, "Change max logfiles in hashtable in krfbVerifyRedoAvailable"
For testing purposes
10875, 00000, "Require instance bounce after switchover to primary"
For testing purposes
10876, 00000, "IDR Test event"
Level 1 - x$ir_working_repair_set returns manual options.
Should only be used when testing IR framework.
2 - force a failure revalidation timeout.
3 - force a failure in getAdviseID.
4-7 - simulate ADR timeout.
8 - simulate ADR lock busy error
9 - simulate OMF template name for logfile members
10877, 00000, "error signaled in parallel recovery slave %s"
*Cause: A parallel recovery logmerger reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
10878, 00000, "parallel recovery slave died unexpectedly"
*Cause: A parallel recovery slave died unexpectedly, PMON cleaning
up the process.
*Action: Check your system for anomalies and reissue the statement.
If this error persists, contact Oracle Support Services.
See trace file for more details.
10879, 00000, "error signaled in parallel recovery slave %s"
*Cause: A parallel recovery slave reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
10880 - 10882 Reserved for Java Virtual Machine
10880, 00000, "trace Java VM execution"
*Cause
*Action
10885, 00000, "Switchover test event"
10890, 00000, "ADG test event"
10891, 00000, "disable column pruning in ANSI join transformation"
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Do not attempt to automatically prune away unreferenced
columns during ANSI join transformation when compiling SQL
queries.
10898, 00000, "LGWR timing event"
10900 - 10924 Reserved for SPACE management
10900, 00000, "extent manager fault insertion event #%s"
*Cause: causes faults to be generated in instrumented extent code
*Action: this should only be enabled for internal testing
10901 - used in 7.3.4 for disabling extent trimming for merge
10901, 00000, "disable the fix for bug 1230798"
10902, 00000, "disable seghdr conversion for ro operation"
*Cause: causes seghdr conversion to be turned off for ro ops(#555856)
*Action: this should be enabled only if determined that bug 555856
has occured. Table needs to be exported subsequently
10903, 00000, "Force tablespaces to become locally managed"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.
10904, 00000, "Allow locally managed tablespaces to have user allocation"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY BY IMPORT CODE.
10905, 00000, "Do cache verification (kcbcxx) on extent allocation"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10906, 00000, "Unable to extend segment after insert direct load"
*Cause: This is a restriction with insert direct load transactions.
*Action: When a segment has been insert direct loaded, avoid DMLs that
could cause more space to be consumed.
10907, 00000, "Trace extent management events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10908, 00000, "Trace temp tablespace events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10909, 00000, "Trace free list events"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10910, 00000, "inject corner case events into the RAC buffer cache"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10911, 00000, "Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle Support"
*Action:
10912, 00000, "Used to perform admin operations on locally managed SYSTEM tablespace"
*Action: The event should be used only under the supervision of
Oracle Support
10913, 00000, "Create locally managed database if compatible > 920 by default"
*Action: THIS IS NOT A USER ERROR NUMBERMESSAGE. THIS DOES NOT NEED TO BE
TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR DEBUGGING.
10914, 00000, "invalid TABLESPACE GROUP clause"
*Cause: An invalid option appears for TABLESPACE GROUP clause.
*Action: Specify a valid tablespace group name.
10915, 00000, "TABLESPACE GROUP cannot be specified for this type of tablespace"
*Cause: In CREATEALTER TABLESPACE, the TABLESPACE GROUP clause was used
while creatingaltering a tablespace that is not TEMPORARY.
*Action: Remove the TABLESPACE GROUP clause.
10916, 00000, "TABLESPACE GROUP already specified"
*Cause: In CREATEALTER TABLESPACE, the TABLESPACE GROUP option was
specified more than once.
*Action: Remove all but one of the TABLESPACE GROUP specifications.
10917, 00000, "TABLESPACE GROUP cannot be specified"
*Cause: The tablespace name specified in the command
is actually the name of a tablespace group.
*Action: Please specify an appropriate tablespace name.
10918, 00000, "TABLESPACE GROUP name cannot be the same as tablespace name"
*Cause: The tablespace group name specified in the command
is the same as the tablespace being CREATEdALTERed.
*Action: Please specify an appropriate tablespace group name.
10919, 00000, "Default temporary tablespace group must have at least one tablespace"
*Cause: An attempt was made to move the only tablespace in the default
database temporary tablespace group to another tablespace group.
*Action: Either change the database default temporary tablespace or
add another tablespace to the group that this tablespace belongs to.
10920, 00000, "Cannot offline tablespace belonging to default temporary tablespace group"
*Cause: An attempt was made to offline a tablespace in the default
database temporary tablespace group.
*Action: Either change the database default temporary tablespace or
change the tablespace group of this tablespace.
10921, 00000, "Cannot drop tablespace belonging to default temporary tablespace group"
*Cause: An attempt was made to drop a tablespace in the default
database temporary tablespace group.
*Action: Either change the database default temporary tablespace or
change the tablespace group of this tablespace.
10922, 00000, "Temporary tablespace group is empty"
*Cause: An attempt was made to allocate a temporary segment in a group,
which now no longer has any members.
*Action: Either add some temporary tablespaces or change the
temporary tablespace for this user.
10923, 00000, "prints debug information for object space server manageability"
10924, 00000, "import storage parse error ignore event"
*Cause: causes server to ignore specific error associated with freelists
and freelist groups when parsing
*Action: this should be enabled by import code only
10925 - 10959 Reserved for PLSQL
10925, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 237911
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10926, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 190119
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10927, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 235190
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10928, 00000, "trace name context forever"
* Cause:
* Action: Set this event only under the supervision of Oracle Development.
* Comment: This event causes PLSQL to dump out information to trace files.
10929, 00000, "trace name context forever"
* Cause: When enabled, turns off bugfix 343966
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10930, 00000, "trace name context forever"
* Cause: When enabled, provides V7 behavior for fixed char binds
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10931, 00000, "trace name context forever"
* Cause: When enabled, allows normal packages to be compiled with standard
extensions like "<ADT_1>"
* Action: Set this event only for a short amount of time. Once the
packages are compiled, this event should be turned off.
Level 1 - Turn the event on
Level > 1 - Turn the event off
10932, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10933, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10934, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 11.x.
* Action: Set this event only if necessary - after reading the README for
this release or under supervision of Oracle Support Services.
10936, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available in versions 7.x and 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10937, 00000, "trace name context forever"
* Cause:
* Action: When set, this event enables tracing of PLSQL packages.
* Comment: Setting this event could result in some performance slowdown.
10938, 00000, "trace name context forever"
* Cause:
* Action: When set, this event enables tracing of PLSQL calls and exceptions.
* Comment: Setting this event could result in some performance slowdown.
10939, 00000, "trace name context forever"
* Cause:
* Action: When set, this event turns on coverage for PLSQL procedures and
functions.
* Comment: Setting this event could result in some performance slowdown.
10940, 00000, "trace name context forever"
* Cause: Size of the PLSQL tracing circular buffer, in kilobytes.
* Action: Set this event in concert with the 10938 event and the
_PLSQL_DUMP_BUFFER_EVENTS init.ora parameter, under supervision
of Oracle Support.
10941, 00000, "trace name context forever"
* Cause: When enabled, turns on PLSQL profiler
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10943, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 8.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10944, 00000, "trace name context forever"
* Cause: When enabled, allows or controls PLSQL OPT code gen project.
available only in version 8.2+.
* Action: set this event ONLY for development of the OPT project.
This is not for general use or deployment.
10945, 00000, "trace name context forever"
* Cause: When enabled, disables the behaviour change introduced by the fix
for bug 822764, which traps and handles invalidations of packages
whereas the previous behaviour was to use stale invalidated
instantiations of the stateful package body.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10946, 00000, "trace name context forever"
* Cause: When enabled, disables one or more features or bug fixes
available only in version 10.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10947, 00000, "trace name context forever"
* Cause: When enabled, causes various PLSQL warnings related debugging
info to be written in a trace file. Useful for debugging varous
Oracle processes. available only in version 10.x.
* Action: set this event ONLY if necessary - after reading the README for
this release or under supervision of Oracle Support.
10948, 00000, "trace name context forever"
* Cause: When enabled, inflate callout argument.
available only in version 10.x.
* Action: internal use only.
10949, 00000, "Disable autotune direct path read for full table scan"
Disable autotune direct path read for serial full table scan.
10960 - 10969 Reserved for Advanced Queuing
10960, 00000, "AQ tracing event"
*Document: NO
10970 - 10974 Reserved for Lob Access
10970, 00000, "backout event for bug 2133357"
*Cause: 2133357 dynamically sets the varying width flag and character width.
Lob data which is not migrated during migration from single byte to
multibyte charater set will be displayed as special characters.
*Action: To help migrate lob data which was not migrated during migration
by backing out 2133357, so lob data can be selected and moved to
multibyte character set.
10971, 00000, "prints debugging information for LOBs"
None
10972, 00000, "raise a 1551 exception in kdu_array_flush"
None
10973, 00000, "backout evet for 2619509"
*Cause: 2619509 catches offsets when not readingwriting on full character
boundary. To facilitate backward compatiblity event is being
introduced.
*Action: To help upgrademigrate issues which already have corrupt data
10974, 00000, "Turn on LOB integrity verification"
None
10975 - 10995 Reserved for Replication
10975, 00000, "trace execution of parallel propagation"
10976, 00000, "internal package related tracing"
LEVEL ACTION
---------------------------------------------------------------------------
> 0 trace the execution of sync procedural replication,
error execution, $RP$RL invocation.
> 1 trace the loading of meta-data into library cache for ip
10977, 00000, "trace event for RepAPI"
*Cause: NA.
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
10978, 00000, "general event for materialized view logs"
*Action: This internal event is used to enable various actions
associated with MV logs. The event level is interpreted
as a bitmap of actions to enable.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 use asynchronous purge
0x0002 use scheduled purge
0x0004 log commit scn when creating MV logs
10979, 00000, "trace flags for join index implementation"
*Cause: This is an informational message.
*Action: Values are as follows:
LEVEL ACTION
---------------------------------------------------------------------------
> 1 Dump refresh expressions (SQL) to trace file.
> 999 If a complete refresh is invoked, it will not be performed
but the system will assume that a complete refresh was done,
causing the view to be VALID and updating timestamps. This
should be used only under Oracle Support supervision.
10980, 00000, "prevent sharing of parsed query during Materialized View query generation"
*Cause: NA.
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
10981, 00000, "dscn computation-related event in replication"
.
*Action:
LEVEL ACTION
---------------------------------------------------------------------------
> 0 During replication enqueue for parallel propagation, make each
transaction in a session depend on the transaction that
precedes it in the same session.
10982, 00000, "event to turn off CDC-format MV Logs"
.
*Action:
LEVEL ACTION
---------------------------------------------------------------------------
= 999 Revert to pre-CDC original format MV Logs for all
new MV Logs created.
10983, 00000, "event to enable Create_Change_Table debugging"
.
*Action:
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Echo input parameter values to the trace log.
> 1 Display trigger debug info to the trace log also.
10984, 00000, "subquery materialized view-related event"
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 A REFRESH FAST subquery MATERIALIZED VIEW which
satisfies the pre 8.2 ORACLE server requirements will be
treated as a many-many subquery MATERIALIZED VIEW.
10985, 00000, "event for NULL refresh of materialized views"
*Action: Set this event only under the supervision of Oracle development.
*Comment: Not for general purpose use.
10986, 00000, "donot use HASH_AJ in refresh"
*Action: Set this event while doing refresh if the delta snapshot is small
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Refresh uses NOT EXISTS sub-query instead of HASH_AJ
10987, 00000, "event for the support of caching table with object feature"
*Action: Set this event while caching tables with object features.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Turn off the checking of object features of a cached table
10988, 00000, "event to get exclusive lock during materialized view refresh in IAS"
*Action: Set this event if you want to get exclusive lock on the Updatable MV container table during refresh in IAS
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0 Get exclusive lock on the updatable MV container table during
refresh in IAS
10989, 00000, "event to internally create statistics MV"
*Action: The event is internally used to create statsMV
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
> 0
10990, 00000, "dump spreadsheet info"
set this event only under the supervision of Oracle Development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 dump pruned rules during graph analysis
0x0002 dump level of the rules after ordering in graph analysis
0x0004 dump spreadsheet filter
10991, 00000, "event for optimizing the online redefinition instantiation"
*Document: NO
*Action: control the optimizations used during online redefinition.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 Turn off the index optimization during online redefinition
instantiation.
0x0002 Turn off the ascending scn optimization during online redefinition
instantiation
0x0004 Turn on the index and optimistic ascending scn optimization
during online redefinition instantiation.
10992, 00000, "event to enable dbms_job instead of dbms_scheduler"
enables dbms_job instead of dbms_scheduler
*Comment: set this event only under the supervision of Oracle Development
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 enable dbms_job instead of dbms_scheduler for MV refresh
10993, 00000, "Runtime enable IOQ batching"
*Comment: set this event only under the supervision of Oracle Development
10994, 00000, "Compiletime enable IOQ batching"
*Comment: set this event only under the supervision of Oracle Development
10995, 00000, "general event for materialized views"
*Action: This internal event is used to enable various actions
associated with MVs. The event level is interpreted
as a bitmap of actions to enable.
*Comment: Not for general purpose use.
LEVEL ACTION
---------------------------------------------------------------------------
0x0001 enable callback-based refresh
0x0002 invalidate dependents for online redef
0x0004 allow PCT fast refresh after CONSIDER FRESH
0x0008 do not use an extended Merge statement during MAV fast refresh
10996 - 10998 Reserved for ks*
10997, 00000, "another startupshutdown operation of this instance inprogress"
*Cause: An Oracle Instance startup or shutdown operation failed to procure
the serialization primitive. Another foreground process may have
attempted startup or shutdown operation in parallel.
*Action: Check additional error messages in the alert log and the process
trace file.
10998, 00000, "event to enable short stack dumps in system state dumps"
*Action: enables short stack dumps for every active process in a system
state dump
*Comment: set this event only under the supervision of Oracle Support
10999, 00000, "do not get database enqueue name"
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28539951/viewspace-1983919/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/28539951/viewspace-1983919/
448
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
