您好，登录后才能下订单哦！
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
Oracle所有诊断事件列表events是怎样的，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。
通过如下的脚本可以获取所有的诊断事件列表：
在UNIX系统下message文件在底下目录$ORACLE_HOME/rdbms/mesg/oraus.msg
在NT系统下message文件在底下目录$ORACLE_HOME/rdbms/mesg/oraus.msg
oraus.msg文件属于文本文件，可以直接打开查看。
诊断事件可以像普通的ORA错误一样采用oerr命令来查询，如下所示：
event="10248 trace name context forever, level 10" |
另一种方法是在会话过程中使用alter session set events命令，只对当前会话有影响。设置格式如下：
alter session|system set events '[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : .......'
通过:符号，可以连续设置多个事件，也可以通过连续使用alter session set events 来设置多个事件。
SQL> show parameter event |
四. 示例
4.1 查看当前trc 文件
select
u_dump.value || '/' ||
db_name.value || '_ora_' ||
v$process.spid ||
nvl2(v$process.traceid, '_' || v$process.traceid, null )
|| '.trc' "Trace File"
from
v$parameter u_dump
cross join v$parameter db_name
cross join v$process
join v$session
on v$process.addr = v$session.paddr
where
u_dump.name = 'user_dump_dest' and
db_name.name = 'db_name' and
v$session.audsid=sys_context('userenv','sessionid');
eg：
/oracle/product/10.2.0/admin/dw/udump\dw_ora_389530.trc
4.2 执行event
alter session set events '10046 trace name context forever, level 1';
select count(1) from all_tables;
alter session set events '10046 trace name context off' ;
4.3 在查看dw_ora_389530.trc
$dw_ora_389530.trc
以下是所有的诊断事件列表：
| 返回 | |||
| 事件ID | 事件 | 说明 | 例子 |
| 10046 | enable SQL statement timing | level 0：禁用SQL_TRACE，等价于SQL_TRACE=FALSE level 1：启用标准的sql_trace功能跟踪SQL语句，包括解析、执行、提取、提交和回滚等，等价于SQL_TRACE=TRUE level 4：Level 1 +包括变量(bind values)的详细信息 level 8：Level 1 + 包括等待事件 level 12：包括绑定变量与等待事件，包含Level 1 + Level 4 + Level 8 1 Print SQL statements, execution plans and execution statistics 4 As level 1 plus bind variables 8 As level 1 plus wait statistics 12 As level 1 plus bind variables and wait statistics | ALTER SESSION SET EVENTS '10046 trace name context forever,level 12'; ALTER SESSION SET EVEVTS '10046 trace name context off'; |
| 10053 | CBO Enable optimizer trace | 转储优化策略，Dump Optimizer Decisions---在分析SQL语句时,Dump出优化器所做的选择,级别level 1最详细 Level Action 1 Print statistics and computations 2 Print computations only | ALTER SESSION SET EVENTS '10053 trace name context forever, level 1'; |
| 10704 | Print out information about what enqueues are being obtained | When enabled, prints out arguments to calls to ksqcmi and ksqlrl and the return values。跟踪enqueues，可以查看锁的信息。 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 | ALTER SESSION SET EVENTS '10704 trace name context forever,level 10'; |
| 10710 | Event 10710 - Trace Bitmap Index Access | 跟踪位图索引的访问情况 | ALTER SESSION SET EVENTS '10710 trace name context forever, level 1'; |
| 10711 | Event 10711 - Trace Bitmap Index Merge Operation | 跟踪位图索引合并操作 | ALTER SESSION SET EVENTS '10711 trace name context forever, level 1'; |
| 10712 | Event 10712 - Trace Bitmap Index OR Operation | 跟踪位图索引或操作情况 | ALTER SESSION SET EVENTS '10712 trace name context forever, level 1'; |
| 10713 | Event 10713 - Trace Bitmap Index AND Operation | 跟踪位图索引与操作 | ALTER SESSION SET EVENTS '10713 trace name context forever, level 1'; |
| 10714 | Event 10714 - Trace Bitmap Index MINUS Operation | 跟踪位图索引minus操作 | ALTER SESSION SET EVENTS '10714 trace name context forever, level 1'; |
| 10715 | Event 10715 - Trace Bitmap Index Conversion to ROWIDs Operation | 跟踪位图索引转换ROWID操作 | ALTER SESSION SET EVENTS '10715 trace name context forever, level 1'; |
| 10716 | Event 10716 - Trace Bitmap Index Compress/Decompress | 跟踪位图索引压缩和解压缩情况 | ALTER SESSION SET EVENTS '10716 trace name context forever, level 1'; |
| 10717 | Event 10717 - Trace Bitmap Index Compaction | ALTER SESSION SET EVENTS '10717 trace name context forever, level 1'; | |
| 10719 | Event 10719 - Trace Bitmap Index DML | 跟踪位图索引列的DML操作（引起位图索引改变的DML操作） | ALTER SESSION SET EVENTS '10719 trace name context forever, level 1'; |
| 10730 | Event 10730 - Trace Fine Grained Access Predicates | 跟踪细粒度审计的断语 | ALTER SESSION SET EVENTS '10730 trace name context forever, level 1'; |
| 10731 | Event 10731 - Trace CURSOR Statements | 跟踪CURSOR的语句情况，跟踪游标声明 | ALTER SESSION SET EVENTS '10731 trace name context forever, level level'; LEVEL定义 1 Print parent query and subquery 2 Print subquery only |
| 10928 | Event 10928 - Trace PL/SQL Execution | 跟踪PL/SQL执行情况 | ALTER SESSION SET EVENTS '10928 trace name context forever, level 1'; |
| 10938 | Event 10938 - Dump PL/SQL Execution Statistics | 转储PL/SQL执行统计信息，跟踪PL/SQL执行状态。使用前需要执行rdbms/admin下的tracetab.sql | ALTER SESSION SET EVENTS '10938 trace name context forever, level 1'; |
| Memory Dumps | |||
| flush_cache | 刷新BUFFER CACHE | ALTER SESSION SET EVENTS 'immediate trace name flush_cache'; | |
| DROP_SEGMENTS | 手工删除临时段。当这些临时段无法自动清除的时候可以手工清除 | alter session set events 'immediate trace name DROP_SEGMENTS level ts#+1'; --ts#是指要删除临时段的表空间的ts# | |
| global_area | 1 包含PGA 2 包含SGA 4 包含UGA 8 包含indrect memory | ALTER SESSION SET EVENTS 'immediate trace name global_area level n'; | |
| Library Cache | 1 library cache统计信息 2 包含hash table histogram 3 包含object handle 4 包含object结构（Heap 0） | ALTER SESSION SET EVENTS 'immediate trace name library_cache level 10'; | |
| Row Cache | dump数据字典缓冲区中的信息： 1 row cache统计信息 2 包含hash table histogram 8 包含object结构 | ALTER SESSION SET EVENTS 'immediate trace name row_cache level n'; | |
| buffers | 1 buffer header 2 level 1 + block header 3 level 2 + block contents 4 level 1 + hash chain 5 level 2 + hash chain 6 level 3 + hash chain 8 level 4 + users/waiters 9 level 5 + users/waiters 10 level 6 + users/waiters | ALTER SESSION SET EVENTS 'immediate trace name buffers level n'; | |
| Buffer | n为某个指定block的rdba，该命令可以转储某个block在buffer中的所有版本。 | ALTER SESSION SET EVENTS 'immediate trace name buffer level n'; | |
| Heap | dump PGA、SGA、UGA中的信息： 1 PGA摘要 2 SGA摘要 4 UGA摘要 8 Current call(CGA)摘要 16 User call(CGA)摘要 32 Large call(LGA)摘要 1025 PGA内容 2050 SGA内容 4100 UGA内容 8200 Current call内容 16400 User call内容 32800 Large call内容 | ALTER SESSION SET EVENTS 'immediate trace name heapdump level level'; | |
| Sub Heap | Oracle 9.0.1版本之前 ALTER SESSION SET EVENTS 'immediate trace name heapdump_addr level n'; 若n为subheap的地址，转储的是subheap的摘要信息 若n为subheap的地址+1，转储的则是subheap的内容 Oracle 9.2.0版本之后 ALTER SESSION SET EVENTS 'immediate trace name heapdump_addr level n, addr m'; 其中m为subheap的地址，n为1转储subheap的摘要，n为2转储subheap的内容 | ||
| Process State | 分析进程状态 | ALTER SESSION SET EVENTS 'immediate trace name processstate level 10'; | |
| systemstate | dump所有系统状态和进程状态，分析系统状态，最好每10分钟一次，做三次对比 alter session set events 'immediate trace name SYSTEMSTATE level 10'; | ALTER SESSION SET EVENTS 'immediate trace name systemstate level 10'; | |
| errorstack | dump错误栈信息，通常Oracle发生错误时前台进程将得到一条错误信息，但某些情况下得不到错误信息，可以采用这种方式得到Oracle错误 0 Error stack 1 level 0 + function call stack 2 level 1 + process state 3 level 2 + context area | ALTER SESSION SET EVENTS 'immediate trace name errorstack level n'; alter session set events '604 trace name errorstack forever'; --表示当出现604错误时，dump 错误栈和进程栈。 alter session set events '942 trace name errorstack level 3'; alter system set events='1438 trace name errorstack forever,level 3'; alter system set events='1438 trace name errorstack off'; | |
| hanganalyze | ALTER SESSION SET EVENTS 'immediate trace name hanganalyze level n'; | ||
| Work Area | 1 SGA信息 2 Workarea Table摘要信息 3 Workarea Table详细信息 | ALTER SESSION SET EVENTS 'immediate trace name workareatab_dump level n'; | |
| Latches | 1 latch信息 2 统计信息 | ALTER SESSION SET EVENTS 'immediate trace name latches level n'; | |
| events | 1 session 2 process 3 system | ALTER SESSION SET EVENTS 'immediate trace name events level n'; | |
| Locks | ALTER SESSION SET EVENTS 'immediate trace name locks level n'; | ||
| Shared Server Process | n取值为1~14 | ALTER SESSION SET EVENTS 'immediate trace name shared_server_state level n'; | |
| Background Messages | ALTER SESSION SET EVENTS 'immediate trace name bg_messages level (pid+1)'; | ||
| coalesec事件 | dump指定表空间中的自由区间 | levelnumber以十六进制表示时，两个高位字节表示自由区间数目，两个低位字节表示表空间号，如0x00050000表示dump系统表空间中的5个自由区间，转换成十进制就是327680，即： alter session set events 'immediate trace name coalesec level 327680'; | |
| File Dumps | |||
| blockdump事件 | dump数据文件、索引文件、回滚段文件结构，在Oracle 8以后该命令已改为： alter system dump datafile 11 block 9; --表示dump数据文件号为11中的第9个数据块。 | alter session set events 'immediate trace name blockdump level 66666'; --表示dump块地址为6666的数据块。 | |
| block | 分析数据文件块，转储数据文件n的块m: alter system dump datafile n block m; | ALTER SYSTEM DUMP DATAFILE file# BLOCK block#; ALTER SYSTEM DUMP DATAFILE file# BLOCK MIN min # BLOCK MAX max #; | |
| Tree Dump | ALTER SESSION SET EVENTS 'immediate trace name treedump level object_id'; | ||
| Undo Segment Header | ALTER SYSTEM DUMP UNDO_HEADER 'segment_name'; | ||
| Undo for a Transaction | ALTER SYSTEM DUMP UNDO BLOCK 'segment_name' XID xidusn xidslot xidsqn; | ||
| File Header | dump 所有数据文件的头部信息： 1 控制文件中的文件头信息 2 level 1 + 文件头信息 3 level 2 + 数据文件头信息 10 level 3 | alter session set events 'immediate trace name file_hdrs level 1'; --表示dump 所有数据文件头部的控制文件项。 alter session set events 'immediate trace name file_hdrs level 2'; --表示dump 所有数据文件的通用文件头。 alter session set events 'immediate trace name file_hdrs level 10'; --表示dump 所有数据文件的完整文件头。 | |
| Control file | 转储控制文件: 1 文件头信息 2 level 1 + 数据库信息 + 检查点信息 3 level 2 + 可重用节信息 10 level 3 12 | alter system set events 'immediate trace name controlf level 12'; | |
| Redo log Header | 分析日志文件头： 1 控制文件中的redo log信息 2 level 1 + 文件头信息 3 level 2 + 日志文件头信息 10 level 3 | alter session set events 'immediate trace name redohdr level 1'; --表示dump redo日志头部的控制文件项。 alter session set events 'immediate trace name redohdr level 2'; --表示dump redo日志的通用文件头。 alter session set events 'immediate trace name redohdr level 10'; --表示dump redo日志的完整文件头。 | |
| Redo log | 分析日志文件： ALTER SYSTEM DUMP LOGFILE 'FileName' SCN MIN MinSCN SCN MAX MaxSCN TIME MIN MinTime TIME MAX MaxTime LAYER Layer OPCODE Opcode DBA MIN File#.Block# DBA MAX File#.Block# RBA MIN LogFileSequence#.Block# RBA MAX LogFileSequence#.Block#; 其中time = ((((yyyy - 1988) * 12 + mm - 1) * 31 + dd - 1) * 24 + hh) * 60 + mi) * 60 + ss; | ALTER SYSTEM DUMP LOGFILE 'FileName'; | |
| Loghist | dump控制文件中的日志历史项： 1 dump控制文件中最早和最迟的日志历史项 >1 dump 2^n个日志历史项 | alter session set events 'immediate trace name loghist level 1'; --表示只dump最早和最迟的日志历史项。 levelnumber大于等于2时，表示2的levelnumber次方个日志历史项。 alter session set events 'immediate trace name loghist level 4'; --表示dump 16个日志历史项。 | |
| 内部事件 | |||
| 10000 | control file debug event, name 'control_file' | ||
| 10001 | control file crash event1 | ||
| 10002 | control file crash event2 | ||
| 10003 | control file crash event3 | ||
| 10004 | block recovery testing - internal error | ||
| 10005 | trace latch operations for debugging | ||
| 10006 | block recovery testing - external error | ||
| 10007 | log switch debug crash after new log select, thread | ||
| 10008 | log switch debug crash after new log header write, thread | ||
| 10009 | log switch debug crash after old log header write, thread | ||
| 10010 | Begin Transaction | ||
| 10011 | End Transaction | ||
| 10012 | Abort Transaction | ||
| 10013 | Instance Recovery | 用于监视事务恢复，在Startup时跟踪事务恢复 | ALTER SESSION SET EVENTS '10013 trace name context forever, level 1'; |
| 10014 | Roll Back to Save Point | ||
| 10015 | Undo Segment Recovery | 转储UNDO SEGMENT头部，Dump Undo Segment Headers，在事务恢复后做Dump回退段头信息 | ALTER SESSION SET EVENTS '10015 trace name context forever, level 1'; |
| 10016 | Undo Segment extend | ||
| 10017 | Undo Segment Wrap | ||
| 10018 | Data Segment Create | ||
| 10019 | Turn off data/space search cache | ||
| 10020 | partial link restored to linked list (KSG) | ||
| 10021 | KST event to trace control file header writes and reads | ||
| 10022 | trace ktsgsp | ||
| 10023 | Create Save Undo Segment | ||
| 10024 | Write to Save Undo | ||
| 10025 | Simulate block recovery errors | ||
| 10026 | Apply Save Undo | ||
| 10027 | Specify Deadlock Trace Information to be Dumped | ||
| 10028 | Dump trace information during lock / resource latch cleanup | ||
| 10029 | session logon (KSU) | 用于给出会话期间的登陆信息 | |
| 10030 | session logoff (KSU) | 用于给出会话期间的注销信息 | |
| 10031 | sort debug event (S*) | ||
| 10032 | sort statistics (SOR*) | 转储排序的统计信息，Dump Sort Statistics----Dump排序的统计信息,level 10是最详细的 | ALTER SESSION SET EVENTS '10032 trace name context forever, level 10'; |
| 10033 | sort run information (SRD*/SRS*) | 转储排序增长的统计信息 | ALTER SESSION SET EVENTS '10033 trace name context forever, level 10'; |
| 10034 | access path analysis (APA*) | ||
| 10035 | Write parse failures to alert log file | 解析失败写入告警日志 | alter system set events '10035 trace name context forever,leve 5'; alter system set events '10035 trace name context off'; |
| 10036 | create remote row source (QKANET) | ||
| 10037 | allocate remote row source (QKARWS) | ||
| 10038 | dump row source tree (QBADRV) | ||
| 10039 | type checking (OPITCA) | ||
| 10040 | disable result-cache | ||
| 10041 | dump undo records skipped | ||
| 10042 | file header reads return youngest mirror | ||
| 10043 | check consistency of owner/waiter/converter lists in KSQ | ||
| 10044 | free list undo operations | ||
| 10045 | free list update operations - ktsrsp, ktsunl | 跟踪Freelist管理操作，Trace Free List Management Operations—跟踪Freelist | ALTER SESSION SET EVENTS '10045 trace name context forever, level 1'; |
| 10047 | trace switching of sessions | ||
| 10048 | Undo segment shrink | ||
| 10049 | protect library cache memory heaps | ||
| 10050 | sniper trace | ||
| 10051 | trace OPI calls | ||
| 10052 | don't clean up obj$ | ||
| 10054 | CBO Enable optimizer trace for recursive statement (RPI) | ||
| 10055 | Rowsets: turn off rowsets for various operations | ||
| 10056 | dump analyze stats (kdg) | ||
| 10057 | suppress file names in error messages | ||
| 10058 | use table scan cost in tab$.spare1 | ||
| 10059 | simulate error in logfile create/clear | 模拟redo日志中的创建和清除错误 | |
| 10060 | CBO Enable predicate dump | ||
| 10061 | disable SMON from cleaning temp segment | 阻止SMON进程在启动时清除临时段 | |
| 10062 | disable usage of OS Roles in osds | ||
| 10063 | disable usage of DBA and OPER privileges in osds | ||
| 10064 | thread enable debug crash level , thread | ||
| 10065 | limit library cache dump information for state object dump | Restrict Library Cache Dump Output for State Object Dumps | |
| 10066 | simulate failure to verify file | ||
| 10067 | force redo log checksum errors - block number | ||
| 10068 | force redo log checksum errors - file number | ||
| 10069 | Flashback images for offline file are lost | ||
| 10070 | force datafile checksum errors - block number | ||
| 10071 | force datafile checksum errors - file number | ||
| 10072 | local tempspace tracing - recovery layer | ||
| 10073 | latch cleanup tracing | ||
| 10074 | default trace function mask for kst | ||
| 10075 | CBO Disable outer-join to regular join conversion | ||
| 10076 | CBO Enable cartesian product join costing | ||
| 10077 | CBO Disable view-merging optimization for outer-joins | ||
| 10078 | CBO Disable constant predicate elimination optimization | ||
| 10079 | trace data sent/received via SQL*Net | 转储SQL*NET统计信息，Dump SQL*Net Statistics---Dump SQL*NeT的统计信息 | ALTER SESSION SET EVENTS '10079 trace name context forever, level 2'; |
| 10080 | dump a block on a segment list which cannot be exchanged | ||
| 10081 | segment High Water Mark has been advanced | 转储高水标记变化，Trace High Water Mark Changes—跟踪HWM的改变 | ALTER SESSION SET EVENTS '10081 trace name context forever, level 1'; |
| 10082 | free list head block is the same as the last block | ||
| 10083 | Trace IMCDT in LIMITED mode | ||
| 10084 | free list becomes empty | ||
| 10085 | free lists have been merged | ||
| 10086 | CBO Enable error if kko and qka disagree on oby sort | ||
| 10087 | disable repair of media corrupt data blocks | ||
| 10088 | CBO Disable new NOT IN optimization | ||
| 10089 | CBO Disable index sorting | ||
| 10090 | invoke other events before crash recovery | ||
| 10091 | CBO Disable constant predicate merging | ||
| 10092 | CBO Disable hash join | ||
| 10093 | CBO Enable force hash joins | ||
| 10094 | before resizing a data file | ||
| 10095 | dump debugger commands to trace file | ||
| 10096 | after the cross instance call when resizing a data file | ||
| 10097 | after generating redo when resizing a data file | ||
| 10098 | after the OS has increased the size of a data file | ||
| 10099 | after updating the file header with the new file size | ||
| 10100 | after the OS has decreased the size of a data file | ||
| 10101 | DBWR refresh fails on cross instance resize call | ||
| 10102 | switch off anti-joins | ||
| 10103 | CBO Disable hash join swapping | ||
| 10104 | dump hash join statistics to trace file | 转储Hash连接统计信息，Dump Hash Join Statistics—Dump HASH JOIN的统计信息,用level 10 | ALTER SESSION SET EVENTS '10104 trace name context forever, level 10'; |
| 10105 | CBO Enable constant pred trans and MPs w WHERE-clause | ||
| 10106 | CBO Disable evaluating correlation pred last for NOT IN | ||
| 10107 | CBO Always use bitmap index | ||
| 10108 | CBO Don't use bitmap index | ||
| 10109 | CBO Disable move of negated predicates | ||
| 10110 | CBO Try index rowid range scans | ||
| 10111 | Bitmap index creation switch | ||
| 10112 | Bitmap index creation switch | ||
| 10113 | Bitmap index creation switch | ||
| 10114 | Bitmap index creation switch | ||
| 10115 | CBO Bitmap optimization use maximal expression | ||
| 10116 | CBO Bitmap optimization switch | ||
| 10117 | CBO Disable new parallel cost model | ||
| 10118 | CBO Enable hash join costing | ||
| 10119 | QKA Disable GBY sort elimination | ||
| 10120 | generate relative file # different from absolute | ||
| 10121 | CBO Don't sort bitmap chains | ||
| 10122 | Disable transformation of count(col) to count(*) | ||
| 10124 | Force creation of segmented arrays by kscsAllocate | ||
| 10125 | Disable remote sort elimination | ||
| 10126 | Debug oracle java xa | ||
| 10127 | Disable remote query block operation | ||
| 10128 | Dump Partition Pruning Information | 转储分区休整信息，Dump Partition Pruning Information—Dump分区表信息， Level Action 0x0001 Dump pruning descriptor for each partitioned object 0x0002 Dump partition iterators 0x0004 Dump optimizer decisions about partition-wise joins 0x0008 Dump ROWID range scan pruning information 在9.0.1或者后面的版本,在level 2后还需要建立如下的表: CREATE TABLE kkpap_pruning ( partition_count NUMBER, iterator VARCHAR2(32), partition_level VARCHAR2(32)); | ALTER SESSION SET EVENTS '10128 trace name context forever, level level'; |
| 10129 | Alter histogram lookup for remote queries | ||
| 10130 | sort disable readaheads | ||
| 10131 | CONNECT BY debug event | ||
| 10132 | dump plan after compilation | ||
| 10133 | testing for SQL Memory Management | ||
| 10134 | tracing for SQL Memory Management for session | ||
| 10135 | CBO do not count 0 rows partitions | ||
| 10136 | CBO turn off fix for bug 1089848 | ||
| 10137 | CBO turn off fix for bug 1344111 | ||
| 10138 | CBO turn off fix for bug 1577003 | ||
| 10139 | CBO turn off fix for bug 1386119 | ||
| 10140 | CBO turn off fix for bug 1332980 | ||
| 10141 | CBO disable additional keys for inlist in bitmap optimization | ||
| 10142 | CBO turn off advanced OR-expansion checks | ||
| 10143 | CBO turn off hints | ||
| 10144 | CBO turn off cost based selection of bji over bsj subquery | ||
| 10145 | test auditing network errors | ||
| 10146 | enable Oracle TRACE collection | ||
| 10147 | enable join push through UNION view | ||
| 10148 | Quarantine trace event | ||
| 10149 | allow the creation of constraints with illegal date constants | ||
| 10150 | import exceptions | ||
| 10152 | CBO don't consider function costs in plans | ||
| 10153 | Switch to use public synonym if private one does not translate | ||
| 10154 | Switch to disallow synonyms in DDL statements | ||
| 10155 | CBO disable generation of transitive OR-chains | ||
| 10156 | CBO disable index fast full scan | ||
| 10157 | CBO disable index access path for in-list | ||
| 10158 | CBO preserve predicate order in post-filters | ||
| 10159 | CBO disable order-by sort pushdown into domain indexes | ||
| 10160 | CBO disable use of join index | ||
| 10161 | CBO recursive semi-join on/off-switch | ||
| 10162 | CBO join-back elimination on/off-switch | ||
| 10163 | CBO join-back elimination on/off-switch | ||
| 10164 | CBO disable subquery-adjusted cardinality fix | ||
| 10165 | mark session for special handling during instance administration | ||
| 10166 | trace long operation statistics updates | ||
| 10167 | CBO use old index MIN/MAX optimization | ||
| 10168 | CBO disable single-table predicate predicate generation | ||
| 10169 | CBO disable histograms for multi partitions | ||
| 10170 | CBO use old bitmap costing | ||
| 10171 | CBO disable transitive join predicates | ||
| 10172 | CBO force hash join back | ||
| 10173 | Dynamic Sampling time-out error | ||
| 10174 | view join-back elimination switch | ||
| 10175 | CBO star transformation switch | ||
| 10176 | CBO colocated join switch | ||
| 10177 | CBO colocated join switch | ||
| 10178 | CBO turn off hash cluster filtering through memcmp | ||
| 10179 | CBO turn off transitive predicate replacement | ||
| 10180 | temp table transformation print error messages | ||
| 10181 | CBO disable multi-column in-list processing | ||
| 10182 | CBO disable generation of implied predicates | ||
| 10183 | CBO disable cost rounding | ||
| 10184 | CBO disable OR-exp if long inlist on bitmap column | ||
| 10185 | CBO force index joins | ||
| 10186 | CBO disable index join | ||
| 10187 | CBO additional index join switch | ||
| 10188 | CBO additional index join switch | ||
| 10189 | CBO turn off FFS null fix | ||
| 10190 | Analyze use old frequency histogram collection and density | ||
| 10191 | Avoid conversion of in-lists back to OR-expanded form | ||
| 10192 | nopushdown when number of groups exceed number of rows | ||
| 10193 | Force repeatable sampling with specified seed | ||
| 10194 | CBO disable new LIKE selectivity heuristic | ||
| 10195 | CBO don't use check constraints for transitive predicates | ||
| 10196 | CBO disable index skip scan | ||
| 10197 | CBO force index skip scan | ||
| 10199 | set parameter in session | ||
| 10200 | consistent read buffer status | 转储一致性读信息 | |
| 10201 | consistent read undo application | 转储一致性读中Undo应用 | |
| 10202 | consistent read block header | ||
| 10203 | block cleanout | ||
| 10204 | signal recursive extend | ||
| 10205 | row cache debugging | ||
| 10206 | transaction table consistent read | ||
| 10207 | consistent read transactions' status report | ||
| 10208 | consistent read loop check | ||
| 10209 | enable simulated error on control file | 允许在控制文件中模拟错误 | |
| 10210 | check data block integrity | 触发数据块检查事件 | event = "10210 trace name context forever, level 10" |
| 10211 | 触发索引检查事件，我并没有找到这个事件 | ||
| 10212 | check cluster integrity | ||
| 10213 | crash after control file write | 模拟在写控制文件后崩溃 | |
| 10214 | simulate write errors on control file | 模拟在控制文件中的写错误，levelnumber从1-9表示产生错误的块号，大于等于10则每个控制文件将出错 | |
| 10215 | simulate read errors on control file | 模拟在控制文件中的读错误 | |
| 10216 | dump control file header | ||
| 10217 | debug sequence numbers | ||
| 10218 | dump uba of applied undo | ||
| 10219 | monitor multi-pass row locking | ||
| 10220 | show updates to the transaction table | 转储Undo头部变化 | |
| 10221 | show changes done with undo | 转储Undo变化 | |
| 10222 | row cache | ||
| 10223 | transaction layer - turn on verification codes | ||
| 10224 | index block split/delete trace | 10224事件可以分析索引块分裂及删除 | alter session set events '10224 trace name context forever,level 10'; alter session set events '10224 trace name context off'; |
| 10225 | free/used extent row cache | 转储基于字典管理的区间的变化 | |
| 10226 | trace CR applications of undo for data operations | ||
| 10227 | verify (multi-piece) row structure | ||
| 10228 | trace application of redo by kcocbk | ||
| 10229 | simulate I/O error against datafiles | 模拟在数据文件上的I/O错误 | |
| 10230 | KSFD block repair test event | ||
| 10231 | skip corrupted blocks on _table_scans_ | 设置在全表扫描时忽略损坏的数据块 | alter session set events '10231 trace name context off'; -- 关闭会话期间的数据块检查 event = "10231 trace name context forever, level 10" -- 对任何进程读入SGA的数据块进行检查 |
| 10232 | dump corrupted blocks symbolically when kcbgotten | 将设置为软损坏（DBMS_REPAIR包设置或DB_BLOCK_CHECKING为TRUE时设置）的数据块dump到跟踪文件 | |
| 10233 | skip corrupted blocks on index operations | ||
| 10234 | trigger event after calling kcrapc to do redo N times | ||
| 10235 | check memory manager internal structures | 用于内存堆检查 | alter session set events '10235 trace name context forever, level 1'; |
| 10236 | dump redo on object no. or block type mismatch errors 1410/8103 | ||
| 10237 | simulate ^C (for testing purposes) | ||
| 10238 | instantiation manager | ||
| 10239 | multi-instance library cache manager | ||
| 10240 | dump dba's of blocks that we wait for | ||
| 10241 | remote SQL execution tracing/validation | 转储远程SQL执行 | |
| 10242 | suppress OER 2063 (for testing distrib w/o different error log) | ||
| 10243 | simulated error for test of K2GTAB latch cleanup | ||
| 10244 | make tranids in error msgs print as 0.0.0 (for testing) | ||
| 10245 | Testing event used by server I/O ksfd/ksfq module | ||
| 10246 | print trace of PMON actions to trace file | 跟踪PMON进程，将PMON的动作输出到trace文件中 | alter session set events '10246 trace name context forever,level 4'; alter session set events '10246 trace name context off'; |
| 10247 | Turn on scgcmn tracing. (VMS ONLY) | ||
| 10248 | turn on tracing for dispatchers | 跟踪dispatch进程 | |
| 10249 | turn on tracing for multi-stated servers | 跟踪MTS进程 | |
| 10250 | Trace all allocate and free calls to the topmost SGA heap | ||
| 10251 | check consistency of transaction table and undo block | ||
| 10252 | shared IO pool error simulation | 模拟写数据文件头部错误 | |
| 10253 | limit SQL text returned from X$KGLNA[1] | 模拟写redo日志文件错误 | |
| 10254 | trace cross-instance calls | ||
| 10255 | pl/sql parse checking | ||
| 10256 | shared server debug event | ||
| 10257 | trace shared server load balancing | ||
| 10258 | force shared servers to be chosen round-robin | ||
| 10259 | get error message text from remote using explicit call | ||
| 10260 | PGA limit ( MB) exceeded - process terminated | 10260, 00000, "PGA limit (%s MB) exceeded - process terminated" // *Cause: The Resource Manager SESSION_PGA_LIMIT directive was exceeded // because the process used too much program global area (PGA) // memory. // *Action: Reduce the complexity of the update or query, or contact your // database administrator for more information. | |
| 10261 | Limit the size of the PGA heap | ||
| 10262 | Don't check for memory leaks | 允许连接时存在内存泄漏 | alter session set events '10262 trace name context forever, level 300'; -- 允许存在300个字节的内存泄漏 |
| 10263 | Don't free empty PGA heap extents | ||
| 10265 | Keep random system generated output out of error messages | ||
| 10266 | Trace OSD stack usage | ||
| 10267 | Inhibit KSEDMP for testing | ||
| 10268 | Don't do forward coalesce when deleting extents | ||
| 10269 | Don't do coalesces of free space in SMON | ||
| 10270 | Debug shared cursors | 转储共享游标 | |
| 10271 | distributed transaction after COLLECT | ||
| 10272 | distributed transaction before PREPARE | ||
| 10273 | distributed transaction after PREPARE | ||
| 10274 | distributed transaction before COMMIT | ||
| 10275 | distributed transaction after COMMIT | ||
| 10276 | distributed transaction before FORGET | ||
| 10277 | Cursor sharing (or not) related event (used for testing) | ||
| 10278 | Internal testing | ||
| 10279 | Simulate block corruption in kdb4chk | ||
| 10280 | Internal testing - segmentation fault during crash recovery | ||
| 10281 | maximum time to wait for process creation | ||
| 10282 | Inhibit signalling of other backgrounds when one dies | ||
| 10284 | simulate zero/infinite asynch I/O buffering | ||
| 10285 | Simulate control file header corruption | 模拟控制文件头部损坏 | |
| 10286 | Simulate control file open error | 模拟控制文件打开错误 | |
| 10287 | Simulate archiver error | 模拟归档出错 | |
| 10288 | Do not check block type in ktrget | ||
| 10289 | Do block dumps to trace file in hex rather than fromatted | ||
| 10290 | Internal sequence tracing event | ||
| 10291 | die in tbsdrv to test control file undo | ||
| 10292 | hang analysis trace event | ||
| 10293 | trace log switch media recovery checkpoints | ||
| 10294 | ksrpc tracing | ||
| 10295 | die after file header update durning cf xact | ||
| 10296 | disable 379 | ||
| 10297 | shared I/O pool tracing | ||
| 10298 | ksfd i/o tracing | ||
| 10299 | Trace prefetch tracking decisions made by CKPT | ||
| 10300 | Distributed transaction tracing | ||
| 10301 | Enable LCK timeout table consistency check | ||
| 10302 | trace create or drop internal trigger | ||
| 10303 | trace loading of library cache for internal triggers | ||
| 10304 | trace replication trigger | ||
| 10305 | trace updatable materialized view trigger | ||
| 10306 | trace materialized view log trigger | ||
| 10307 | trace RepCat execution | ||
| 10308 | replication testing event | ||
| 10309 | Trigger Debug event | ||
| 10310 | trace synchronous change table trigger | ||
| 10311 | Disable Flashback Table Timestamp checking | ||
| 10312 | Allow disable to log rows into the mapping table | ||
| 10314 | Enable extra stats gathering for CR | ||
| 10316 | Events for extensible txn header, non zero ext header size | ||
| 10317 | Events for extensible txn header, zero ext header size | ||
| 10318 | Trace extensible txn header movements | ||
| 10319 | Trace PGA statistics maintenance | ||
| 10320 | Enable data layer (kdtgrs) tracing of space management calls | ||
| 10321 | Datafile header verification debug failure. | ||
| 10322 | CBO don't simplify inlist predicates | ||
| 10323 | before committing an add datafile command | ||
| 10324 | Enable better checking of redo logs errors | ||
| 10325 | Trace control file record section expand and shrink operations | ||
| 10326 | clear logfile debug crash at , log | ||
| 10327 | simulate 00235 error for testing | ||
| 10328 | disable first-to-mount split-brain error, for testing | ||
| 10329 | simulate out-of-memory error during first pass of recovery | ||
| 10330 | clear MTTR statistics in checkpoint progress record | ||
| 10331 | simulate resilvering during recovery | ||
| 10332 | force ALTER SYSTEM QUIESCE RESTRICTED command to fail | ||
| 10333 | dump MTTR statistics each time it is updated | ||
| 10334 | force FG to wait to be killed during MTTR advisory simulation | ||
| 10335 | trace database open status | ||
| 10336 | Do remote object transfer using remote SQL | ||
| 10337 | enable padding owner name in slave sql | ||
| 10338 | CBO don't use inlist iterator with function-based indexes | ||
| 10339 | CBO disable DECODE simplification | ||
| 10340 | Buffer queues sanity check for corrupted buffers | ||
| 10341 | Simulate out of PGA memory in DBWR during object reuse | ||
| 10342 | Raise unknown exception in ACQ_ADD when checkpointing | ||
| 10343 | Raise an out of memory exception-OER 4031 in ACQ_ADD | ||
| 10344 | reserved for simulating object hash reorganization | ||
| 10345 | validate queue when linking or unlinking a buffer | ||
| 10346 | check that all buffers for checkpoint have been written | ||
| 10347 | dump active checkpoint entries and checkpoint buffers | ||
| 10348 | test abnormal termination of process initiating file checkpoint | ||
| 10349 | do not allow ckpt to complete | ||
| 10350 | Simulate more than one object & tsn id in object reuse | ||
| 10351 | size of slots | ||
| 10352 | report direct path statistics | ||
| 10353 | number of slots | ||
| 10354 | turn on direct read path for parallel query | ||
| 10355 | turn on direct read path for scans | ||
| 10356 | turn on hint usage for direct read | ||
| 10357 | turn on debug information for direct path | 调试直接路径机制 | |
| 10358 | Simulate out of PGA memory in cache advisory reset | ||
| 10359 | turn off updates to control file for direct writes | ||
| 10360 | enable dbwr consistency checking | ||
| 10361 | check buffer change vector count consistency | ||
| 10362 | simulate a write error to take a file offline | ||
| 10363 | Simulate messaging error for fast object reuse/checkpoint | ||
| 10364 | Do not clear GIMH_STC_SHUT_BEGIN state during shutdown | ||
| 10365 | turn on debug information for adaptive direct reads | ||
| 10366 | kgnfs tracing | ||
| 10367 | kgodm tracing | ||
| 10368 | maximum number of internal errors a process will tolerate | ||
| 10369 | test SQL monitoring feature | ||
| 10370 | parallel query server kill event | ||
| 10371 | disable TQ hint | ||
| 10372 | parallel query server kill event proc | ||
| 10373 | parallel query server kill event | ||
| 10375 | turn on checks for statistics rollups | ||
| 10376 | enable archive compression loads | ||
| 10377 | force slave allocation | ||
| 10378 | force hard process/range affinity | ||
| 10380 | kxfp latch cleanup testing event | ||
| 10381 | kxfp latch cleanup testing event | ||
| 10382 | parallel query server interrupt (reset) | ||
| 10383 | auto parallelization testing event | ||
| 10384 | parallel dataflow scheduler tracing | ||
| 10385 | parallel table scan range sampling method | ||
| 10386 | parallel SQL hash and range statistics | ||
| 10387 | parallel query server interrupt (normal) | ||
| 10388 | parallel query server interrupt (failure) | ||
| 10389 | parallel query server interrupt (cleanup) | ||
| 10390 | Trace parallel query slave execution | ||
| 10391 | trace PX granule allocation/assignment | ||
| 10392 | parallel query debugging bits | ||
| 10393 | print parallel query statistics | ||
| 10394 | generate a fake load to test adaptive and load balancing | ||
| 10395 | adjust sample size for range table queues | ||
| 10397 | suppress verbose parallel coordinator error reporting | ||
| 10398 | enable timeouts in parallel query threads | ||
| 10399 | trace buffer allocation | ||
| 10400 | turn on system state dumps for shutdown debugging | ||
| 10401 | turn on IPC (ksxp) debugging | ||
| 10402 | turn on IPC (skgxp) debugging | ||
| 10403 | fake CPU number for default degree of parallelism | ||
| 10404 | crash dbwr after write | ||
| 10405 | emulate broken mirrors | ||
| 10406 | enable datetime TIMESTAMP, INTERVAL datatype creation | ||
| 10407 | enable datetime TIME datatype creation | ||
| 10408 | disable OLAP builtin window function usage | ||
| 10409 | enable granule memset and block invalidation at startup | ||
| 10410 | trigger simulated communications errors in KSXP | ||
| 10412 | dump the call stack if an error is signaled | ||
| 10413 | force simulated error for testing purposes | ||
| 10414 | simulated error from event level | ||
| 10415 | parallel degree specified is too large, max value allowed | ||
| 10416 | disable fix for 2736734 | ||
| 10417 | limit 1 file per sbtinfo2() validation call | ||
| 10418 | disable re-creating tempfile | ||
| 10419 | create tempfile without create_scn and time | ||
| 10420 | trace KSO OS-process operations | ||
| 10421 | enable dump from ksbwco if there is no reply | ||
| 10422 | KSU debugging | ||
| 10423 | dump the call stack if the specified error is cleared | ||
| 10424 | KGE debugging | ||
| 10425 | enable global enqueue operations event trace | ||
| 10426 | enable ges/gcs reconfiguration event trace | ||
| 10427 | enable global enqueue service traffic controller event trace | ||
| 10428 | enable tracing of global enqueue service cached resource | ||
| 10429 | enable tracing of global enqueue service IPC calls | ||
| 10430 | enable ges/gcs dynamic remastering event trace | ||
| 10431 | enable verification messages on pi consistency | ||
| 10432 | enable tracing of global cache service fusion calls | ||
| 10433 | global enqueue service testing event | ||
| 10434 | enable tracing of global enqueue service multiple LMS | ||
| 10435 | enable tracing of global enqueue service deadlock detetction | ||
| 10436 | enable global cache service duplicate ping checking | ||
| 10437 | enable trace of global enqueue service S optimized resources | ||
| 10438 | force lowest node to be master of all gcs resources | ||
| 10439 | enable tracing of global cache service fusion calls - part 2 | ||
| 10440 | enable global enqueue service inquire resource modes trace | ||
| 10441 | enable diagnosibility daemon (DIAG) trace | ||
| 10442 | enable trace of kst for 01555 diagnostics | ||
| 10443 | reserved for data layer diagnostics and debugging | ||
| 10444 | enable DLM timeout testing | ||
| 10445 | enable tracing of LMS priority management | ||
| 10446 | reserved for data layer diagnostics and debugging | ||
| 10447 | reserved for data layer diagnostics and debugging | ||
| 10448 | Dump trace for OLTP partial compression features diagnostics | ||
| 10449 | enable trace of kst for undo manageability features diagnostics | ||
| 10450 | signal ctrl-c in kdddca (drop column) after n rows | ||
| 10451 | Force heap segment compression bypassing compatibility checks | ||
| 10452 | Cannot do block media recovery; media recovery session may be in progress | ||
| 10453 | Dump compression statistics to trace file | ||
| 10454 | Disable column reordering during compression | ||
| 10455 | Do Compression Block Checking | ||
| 10456 | cannot open standby database; media recovery session may be in progress | ||
| 10457 | cannot close standby database due to active media recovery | ||
| 10458 | standby database requires recovery | ||
| 10459 | cannot start media recovery on standby database; conflicting state detected | ||
| 10460 | Perform backward tablescans for consistent read reduction | ||
| 10461 | Simulate control file corruption during write operation | ||
| 10462 | enable recovery debug module | ||
| 10463 | enable controlfile test | ||
| 10464 | enable incremental checkpoint debug for split brain check | ||
| 10465 | force slave death during parallel crash recovery | ||
| 10466 | enable HARD check for block write | ||
| 10467 | amplify control file record expansion for testing | ||
| 10468 | log writer debug module | ||
| 10469 | error creating control file backup, no checkpoint | ||
| 10470 | disable compatibility check for lost write detection | 10470, 00000, "disable compatibility check for lost write detection" // *Document: NO // *Cause: // *Action: 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 在12c中，Lost write detection related event 10470, 00000, "Lost write detection related event" // *Document: NO // *Cause: // *Action: Set this event to enable certain lost write detection related // functionalities. | |
| 10471 | PQ slave allocation timeout test | ||
| 10472 | dump reading log buffer hit ratio histogram to lgwr trace file | ||
| 10473 | enable BRR tracing | ||
| 10474 | controlfile time tracing | ||
| 10475 | readable standby debug event | ||
| 10476 | control file corruption range testing | ||
| 10477 | simulated rollback error | ||
| 10478 | DBW0 file identification trace event | ||
| 10479 | disk sector size test event | ||
| 10480 | Soft asserts for fast detection of datafile storage problems | ||
| 10481 | Backup data block for data file has an unlogged change | ||
| 10482 | Automatic block repair cannot repair an offline or read-only data file | ||
| 10483 | Simulate overly advanced incremental checkpoint | ||
| 10484 | Enable test move operation | 在12c中，Enable tracing for online data file move operation | |
| 10485 | Real-Time Query cannot be enabled while applying migration redo. | ||
| 10486 | Verify data file-related SGA alignment | ||
| 10487 | Dump redo memory protection information. | ||
| 10488 | Dump block headers read for media recovery. | ||
| 10489 | Generate future redo for testing | ||
| 10490 | Trace OSM misc. events | ||
| 10491 | Trace OSM messaging (KFN) events | ||
| 10492 | Trace OSM metadata events | ||
| 10493 | Return empty define buffers on 1422 | ||
| 10494 | Trace OSM metadata events | ||
| 10495 | Trace OSM metadata events | ||
| 10496 | Turn off fix for bug 2554178 | ||
| 10497 | Trace OSM metadata events | ||
| 10498 | Trim blank characters including contol characters | ||
| 10499 | Trace OSM metadata events | ||
| 10500 | turn on traces for SMON | 跟踪SMON进程 | |
| 10501 | periodically check selected heap | ||
| 10502 | CBO disable the fix for bug 2098120 | ||
| 10503 | enable user-specified graduated bind lengths | ||
| 10504 | CBO disable the fix for bug 2607029 | ||
| 10505 | CBO enable dynamic sampling dump to table | ||
| 10506 | Disable fix for bug 2588217 | ||
| 10507 | Trace bind equivalence logic | ||
| 10508 | Enable fix for bug 14772545 | ||
| 10509 | Check kghu subheaps at call boundaries | ||
| 10510 | turn off SMON check to offline pending offline rollback segment | ||
| 10511 | turn off SMON check to cleanup undo dictionary | ||
| 10512 | turn off SMON check to shrink rollback segments | ||
| 10513 | turn on IPC (ksmsq) debugging | ||
| 10515 | turn on event to use physical cleanout | ||
| 10519 | enable ALTER TYPE RESET support | ||
| 10520 | recreate view only if definition has changed | ||
| 10521 | CMON connection pool test event | ||
| 10522 | turn off wrap source compression | ||
| 10523 | force recreate package even if definition is unchanged | ||
| 10524 | CMON connection pool trace event | ||
| 10525 | Disable automatic object validation for describe | ||
| 10526 | enables lightweight thread tracing | ||
| 10527 | enables SGA allocation tracing | ||
| 10528 | enables ksmg tracing | ||
| 10530 | lightweight thread spawn failed, error stack: | ||
| 10531 | lightweight thread unit test failure error | ||
| 10532 | lightweight thread encountered internal error | ||
| 10542 | Enable tracing for block compare | ||
| 10543 | Standby Block Media Recovery (bmr) and split brain testing event | ||
| 10544 | Inject standby autobmr failures | ||
| 10545 | Print standby autobmr messages in alert log | ||
| 10546 | Cannot perform block media recovery; standby database does not have requisite redo. | ||
| 10547 | Cannot perform block media recovery; standby database is not caught up with primary. | ||
| 10548 | Cannot perform block media recovery on a read-only plugged-in datafile. | ||
| 10549 | Cannot perform block media recovery using a read-only plugged-in backup datafile. | ||
| 10550 | signal error during create as select/create index after n rows | ||
| 10551 | Internal testing for 1551 error handling | ||
| 10552 | allow unlimited corruption during recovery | ||
| 10553 | Incompatible UNTIL CONSISTENT clause | ||
| 10554 | Media recovery failed to bring datafile to a consistent point | ||
| 10555 | Disable redo dumping | ||
| 10556 | Enable tracing for multi instance Redo Apply | ||
| 10557 | NID clears database incarnation section in controlfile | ||
| 10558 | Disable unkeep marker handling for ADG | ||
| 10559 | LGWR code path debugging event for deferred log flush on ping | ||
| 10560 | block type '' | ||
| 10561 | block type '', data object# | ||
| 10562 | Error occurred while applying redo to data block (file# , block# ) | ||
| 10563 | Test recovery had to corrupt data block (file# , block# ) in order to proceed | ||
| 10564 | tablespace | ||
| 10565 | Another test recovery session is active | ||
| 10566 | Test recovery has used all the memory it can use | ||
| 10567 | Redo is inconsistent with data block (file# , block# , file offset is bytes) | ||
| 10568 | Failed to allocate recovery state object: out of SGA memory | ||
| 10569 | Trace datafile header writes | ||
| 10570 | Test recovery complete | ||
| 10571 | Test recovery canceled | ||
| 10572 | Test recovery canceled due to errors | ||
| 10573 | Test recovery tested redo from change to | ||
| 10574 | Test recovery did not corrupt any data block | ||
| 10575 | Give up restoring recovered datafiles to consistent state: out of memory | ||
| 10576 | Give up restoring recovered datafiles to consistent state: some error occurred | ||
| 10577 | Can not invoke test recovery for managed standby database recovery | ||
| 10578 | Can not allow corruption for managed standby database recovery | ||
| 10579 | Can not modify control file during test recovery | ||
| 10580 | Can not modify datafile header during test recovery | ||
| 10581 | Can not modify redo log header during test recovery | ||
| 10582 | The control file is not a backup control file | ||
| 10583 | Can not recovery file renamed as missing during test recovery | ||
| 10584 | Can not invoke parallel recovery for test recovery | ||
| 10585 | Test recovery can not apply redo that may modify control file | ||
| 10586 | Test recovery had to corrupt 1 data block in order to proceed | ||
| 10587 | Invalid count for ALLOW n CORRUPTION option | ||
| 10588 | media recovery file header validation | ||
| 10589 | Test recovery had to corrupt data blocks in order to proceed | ||
| 10590 | kga (argus debugger) test flags | ||
| 10591 | kga (argus debugger) test flags | ||
| 10592 | kga (argus debugger) test flags | ||
| 10593 | kga (argus debugger) test flags | ||
| 10594 | kga (argus debugger) test flags | ||
| 10595 | kga (argus debugger) test flags | ||
| 10596 | kga (argus debugger) test flags | ||
| 10597 | kga (argus debugger) test flags | ||
| 10598 | kga (argus debugger) test flags | ||
| 10599 | kga (argus debugger) test flags | ||
| 10600 | check cursor frame allocation | ||
| 10601 | turn on debugging for cursor_sharing (literal replacement) | ||
| 10603 | cause an error to occur during truncate (for testing purposes) | ||
| 10604 | trace parallel create index | ||
| 10605 | enable parallel create index by default | ||
| 10606 | trace parallel create index | ||
| 10607 | trace index rowid partition scan | ||
| 10608 | trace create bitmap index | 跟踪位图索引的创建 | |
| 10609 | trace for array index insertion | ||
| 10610 | trace create index pseudo optimizer | ||
| 10611 | causes migration to fail - testing only | ||
| 10612 | prints debug information for auto-space managed segments | ||
| 10613 | prints debug information for auto-space managed segments | ||
| 10614 | Operation not allowed on this segment | ||
| 10615 | Invalid tablespace type for temporary tablespace | ||
| 10616 | Operation not allowed on this tablespace | ||
| 10617 | Cannot create rollback segment in dictionary managed tablespace | ||
| 10618 | Operation not allowed on this segment | ||
| 10619 | Avoid assertions when possible | ||
| 10620 | Operation not allowed on this segment | ||
| 10621 | specify retry count for online index build cleanup DML lock get | ||
| 10622 | test/trace online index (re)build | test or trace online index build or rebuild | |
| 10623 | test synchronized flow of SORT rows into FOR UPDATE lock phase | ||
| 10624 | Disable UJV invalidation on drop index | ||
| 10625 | Turn off redo log dump for the index when OERI 12700 | ||
| 10626 | specify timeout for online index rebuild to wait for DML | ||
| 10627 | Dump the content of the index leaf block | ||
| 10628 | Turn on sanity check for kdiss index skip scan state | ||
| 10629 | force online index build to backoff and retry DML lock upgrade | ||
| 10630 | Illegal syntax specified with SHRINK clause | ||
| 10631 | SHRINK clause should not be specified for this object | ||
| 10632 | Invalid rowid | ||
| 10633 | No space found in the segment | ||
| 10634 | Segment is already being shrunk | ||
| 10635 | Invalid segment or tablespace type | ||
| 10636 | ROW MOVEMENT is not enabled | ||
| 10637 | The segment does not exist | ||
| 10638 | Index status is invalid | ||
| 10639 | Dump library cache during reparse loops | ||
| 10640 | Operation not permitted during SYSTEM tablespace migration | ||
| 10641 | Cannot find a rollback segment to bind to | ||
| 10642 | Found rollback segments in dictionary managed tablespaces | ||
| 10643 | Database should be mounted in restricted mode and Exclusive mode | ||
| 10644 | SYSTEM tablespace cannot be default temporary tablespace | ||
| 10645 | Recursive Extension in SYSTEM tablespace during migration | ||
| 10646 | Too many recursive extensions during SYSTEM tablespace migration | ||
| 10647 | Tablespace other than SYSTEM, , not found in read only mode | ||
| 10648 | Tablespace SYSAUX is not offline | ||
| 10649 | Turn off/trace lob index freelist coalesce | ||
| 10650 | disable cache-callback optimisation | ||
| 10651 | incorrect file number block number specified | ||
| 10652 | Object has on-commit materialized views | ||
| 10653 | Table is in a cluster | ||
| 10654 | Table is of type temporary or external | ||
| 10655 | Segment can be shrunk | ||
| 10656 | Table is in unusable state due to incomplete operation | ||
| 10657 | Lob column to be shrunk does not exist | ||
| 10658 | Lob column to be shrunk is marked unused | ||
| 10659 | Segment being shrunk is not a lob | ||
| 10660 | Segment is a shared lob segment | ||
| 10661 | Invalid option specified | ||
| 10662 | Segment has long columns | ||
| 10663 | Object has rowid based materialized views | ||
| 10664 | Table has bitmap join indexes | ||
| 10665 | Inject Evil Literals | ||
| 10666 | Do not get database enqueue name | ||
| 10667 | Cause sppst to check for valid process ids | ||
| 10668 | Inject Evil Identifiers | ||
| 10690 | Set shadow process core file dump type (Unix only) | ||
| 10691 | Set background process core file type (Unix only) | ||
| 10693 | Internal event | ||
| 10700 | Alter access violation exception handler | ||
| 10701 | Dump direct loader index keys | ||
| 10702 | Application continuity debugging was not enabled | ||
| 10706 | Print out information about global enqueue manipulation | 跟踪全局enqueues | |
| 10707 | Simulate process death for instance registration | ||
| 10708 | print out trace information from the RAC buffer cache | 跟踪RAC的buffer cache | |
| 10709 | enable parallel instances in create index by default | ||
| 10718 | event to disable automatic compaction after index creation | ||
| 10719 | trace bitmap index dml | ||
| 10720 | trace db scheduling | ||
| 10721 | Internal testing - temp table transformation | ||
| 10722 | set parameters for CPU frequency calculation (debug) | 在12c中，trace server level database scheduling | |
| 10723 | Internal testing - release buffer for buffer cache shrink | ||
| 10724 | trace cross-instance broadcast | ||
| 10725 | bitmap index version control | ||
| 10726 | frequent itemset counting | ||
| 10727 | introduce failure events in IPC | ||
| 10728 | set parameters for CPU frequency calculation (debug) | ||
| 10732 | honor pctfree during insert into AQ IOTs | ||
| 10733 | test transient-IOT metadata during PMO cleanup | ||
| 10734 | reroute external procedures | ||
| 10735 | debug ksws operations | ||
| 10736 | buffer cache pin history dump | ||
| 10737 | test block checking | ||
| 10738 | internal block testing | ||
| 10739 | debug WLM (kywm) operations | ||
| 10740 | disables fix for bug 598861 | ||
| 10741 | trace missing BRR generation | ||
| 10742 | dump process state on flush buffer_cache | ||
| 10743 | define the misbehaved vt dump thresholds | ||
| 10744 | disable LMD stale cvak traces and dumps | ||
| 10745 | enable LCK1 kqlmbivg-NULL-kglhdrac dump | ||
| 10746 | enable KGCE_DEBUG_MODE | ||
| 10750 | test rollback segment blksize guessing for index array insert | ||
| 10751 | override for remote row source maximum buffer size | ||
| 10752 | override for the Exponential Moving Average factor | ||
| 10753 | enforce deterministic behaviour for prefetching row source | ||
| 10754 | disable fix for bug 14173995 for multi-table select for update | ||
| 10755 | Event to store SIG_1551 stacks to KST | ||
| 10756 | Event to enable svpt/autotxn tracing | ||
| 10757 | Event to control tracing row source: rows to dump per rowset | ||
| 10758 | Event to control tracing row source: start row number | ||
| 10759 | Event to control tracing row source: end row number | ||
| 10760 | Event to control tracing row source: maximum encoded operands to check | ||
| 10761 | Event to control tracing row source: size of dictionary | ||
| 10780 | LogMiner API trace event | ||
| 10781 | LogMiner reader trace event | ||
| 10782 | LogMiner preparer trace event | ||
| 10783 | LogMiner builder trace event | ||
| 10784 | LogMiner dictionary trace event | ||
| 10785 | LogMiner trace event | ||
| 10786 | call push/pop (KSU) | ||
| 10787 | trace intra-instance broadcast | ||
| 10788 | trace call stacks | ||
| 10789 | LogMiner test event | ||
| 10790 | LogMiner trace event | ||
| 10791 | Logical Standby swithover/failover trace event | ||
| 10792 | Logical Standby XDAT trace event | ||
| 10793 | Logical Standby trace event | ||
| 10794 | Logical Standby trace event | ||
| 10795 | VKTM Process trace event | ||
| 10796 | Elevate Scheduler Priority trace event | ||
| 10797 | Logical Standby Test Event | ||
| 10798 | debug GSM operations | ||
| 10800 | disable Smart Disk scan | ||
| 10804 | reserved for ksxb | ||
| 10806 | Switch to 7.3 mode when detaching sessions | ||
| 10807 | Disable user id check when switching to a global transaction | ||
| 10808 | Enable assert when waiting without a reason | ||
| 10809 | Trace state object allocate / free history | ||
| 10810 | Trace snapshot too old | ||
| 10811 | Trace block cleanouts | ||
| 10812 | Trace Consistent Reads | ||
| 10826 | enable upgrade/downgrade error message trace | ||
| 10827 | enable upgrade/downgrade diagnostics | ||
| 10828 | memory allocator error | ||
| 10830 | Trace group by sort row source | ||
| 10831 | Trace group by rollup row source | ||
| 10832 | Trace approximate NDV row source | ||
| 10833 | Runtime distribution keys for adaptive partial rollup | ||
| 10834 | Runtime behavior control for adaptive partial rollup | ||
| 10835 | exclude SYS_OP_CYCLED_SEQ from TQ keys for scalable percentile | ||
| 10839 | trace / debug caching module (qesca.c) | ||
| 10840 | trace / debug pl/sql caching module (kkxmInitCache) | ||
| 10841 | Default un-inintialized charact set form to SQLCS_IMPLICIT | ||
| 10842 | Event for OCI Tracing and Statistics Info | ||
| 10843 | Event for client result cache tracing | ||
| 10844 | turn on Native Net IPC debugging (skgxp) | ||
| 10845 | Enable Director tracing | ||
| 10846 | Enable Director Single Node Testing | 在12c中，Event for non-blocking testing | |
| 10847 | OCI dump action is being invoked for internal error | ||
| 10848 | OCI Non Blocking not supported with | ||
| 10849 | Internal OCI event number | ||
| 10850 | Enable time manager tracing | ||
| 10851 | Allow Drop command to drop queue tables | ||
| 10852 | Enable tracing for Enqueue Dequeue Operations | ||
| 10853 | Enable tracing for Replicating AQ Operations | ||
| 10854 | Sets poll count used for AQ listen code under RAC | ||
| 10856 | Disable AQ propagator from using streaming | ||
| 10857 | Force AQ propagator to use two-phase commit | ||
| 10858 | Crash the AQ propagator at different stages of commit | ||
| 10859 | Disable updates of message retry count | ||
| 10860 | event for AQ admin disable new name parser | ||
| 10861 | disable storing extended message properties | ||
| 10862 | resolve default queue owner to current user in enqueue/dequeue | ||
| 10863 | Control behavior of buffered background operations | ||
| 10864 | event to enable AQ dedicated propagation | ||
| 10865 | Control tracing of notification operations | ||
| 10866 | event to order dequeue by condition | ||
| 10867 | event to turn off authentication for emon to oci client connections | 在12c中，turn off authentication for emon to oci client and disable HA rstat | |
| 10868 | event to enable interop patch for AQ enqueue options | ||
| 10870 | Disable multi-instance standby role transition | ||
| 10871 | dump file open/close timestamp during media recovery | ||
| 10872 | Flashback Database fault insertion event #. | ||
| 10873 | file needs to be either taken out of backup mode or media recovered | ||
| 10874 | Change max logfiles in hashtable in krfbVerifyRedoAvailable | ||
| 10875 | Require instance bounce after switchover to primary | ||
| 10876 | IDR Test event | ||
| 10877 | error signaled in parallel recovery slave | ||
| 10878 | parallel recovery slave died unexpectedly | ||
| 10879 | error signaled in parallel recovery slave | ||
| 10880 | trace Java VM execution | ||
| 10883 | Event for Fast Application Notification tracing | ||
| 10884 | TTC event | ||
| 10885 | Switchover test event | ||
| 10886 | Recovery test event | ||
| 10887 | An Oracle Active Data Guard license is required to open a pluggable database while standby recovery is applying changes. | ||
| 10888 | TTC event for optimized fetch | ||
| 10889 | minimum number of instances needed for redo apply unavailable | ||
| 10890 | ADG test event | ||
| 10891 | disable column pruning in ANSI join transformation | ||
| 10892 | multi-instance redo apply encountered nonlogged operation | ||
| 10893 | TTC trace event | ||
| 10898 | LGWR timing event | ||
| 10900 | extent manager fault insertion event # | ||
| 10901 | disable the fix for bug 1230798 | ||
| 10902 | disable seghdr conversion for ro operation | ||
| 10903 | Force tablespaces to become locally managed | ||
| 10904 | Allow locally managed tablespaces to have user allocation | ||
| 10905 | Do cache verification (kcbcxx) on extent allocation | ||
| 10906 | Unable to extend segment after insert direct load | ||
| 10907 | Trace extent management events | ||
| 10908 | Trace temp tablespace events | ||
| 10909 | Trace free list events | ||
| 10910 | inject corner case events into the RAC buffer cache | ||
| 10911 | Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle Support | ||
| 10912 | Used to perform admin operations on locally managed SYSTEM tablespace | ||
| 10913 | Create locally managed database if compatible > 920 by default | ||
| 10914 | invalid TABLESPACE GROUP clause | ||
| 10915 | TABLESPACE GROUP cannot be specified for this type of tablespace | ||
| 10916 | TABLESPACE GROUP already specified | ||
| 10917 | TABLESPACE GROUP cannot be specified | ||
| 10918 | TABLESPACE GROUP name cannot be the same as tablespace name | ||
| 10919 | Default temporary tablespace group must have at least one tablespace | ||
| 10920 | Cannot offline tablespace belonging to default temporary tablespace group | ||
| 10921 | Cannot drop tablespace belonging to default temporary tablespace group | ||
| 10922 | Temporary tablespace group is empty | ||
| 10923 | prints debug information for object space server manageability | ||
| 10924 | import storage parse error ignore event | ||
| 10925 | trace name context forever | ||
| 10926 | trace name context forever | ||
| 10927 | trace name context forever | ||
| 10929 | trace name context forever | ||
| 10930 | trace name context forever | ||
| 10931 | trace name context forever | ||
| 10932 | trace name context forever | ||
| 10933 | trace name context forever | ||
| 10934 | trace name context forever | ||
| 10936 | trace name context forever | ||
| 10937 | trace name context forever | ||
| 10939 | trace name context forever | ||
| 10940 | trace name context forever | ||
| 10941 | trace name context forever | ||
| 10943 | trace name context forever | ||
| 10944 | trace name context forever | ||
| 10945 | trace name context forever | ||
| 10946 | trace name context forever | ||
| 10947 | trace name context forever | ||
| 10948 | trace name context forever | ||
| 10949 | Disable autotune direct path read for full table scan | ||
| 10960 | AQ tracing event | ||
| 10961 | Enable tracing for Scheduler subscriber cleanup | ||
| 10970 | backout event for bug 2133357 | ||
| 10971 | prints debugging information for LOBs | ||
| 10972 | raise a 1551 exception in kdu_array_flush | ||
| 10973 | backout evet for 2619509 | ||
| 10974 | Turn on LOB integrity verification | ||
| 10975 | trace execution of parallel propagation | ||
| 10976 | internal package related tracing | ||
| 10977 | trace event for RepAPI | ||
| 10978 | general event for materialized view logs | ||
| 10979 | trace flags for join index implementation | ||
| 10980 | prevent sharing of parsed query during Materialized View query generation | ||
| 10981 | dscn computation-related event in replication | ||
| 10982 | event to turn off CDC-format MV Logs | ||
| 10983 | event to enable Create_Change_Table debugging | ||
| 10984 | subquery materialized view-related event | ||
| 10985 | event for NULL refresh of materialized views | ||
| 10986 | donot use HASH_AJ in refresh | ||
| 10987 | event for the support of caching table with object feature | ||
| 10988 | event to get exclusive lock during materialized view refresh in IAS | ||
| 10989 | event to internally create statistics MV | ||
| 10990 | dump spreadsheet info | ||
| 10991 | event for optimizing the online redefinition instantiation | ||
| 10992 | event to enable dbms_job instead of dbms_scheduler | ||
| 10993 | Runtime enable IOQ batching | ||
| 10994 | Compiletime enable IOQ batching | ||
| 10995 | general event for materialized views | ||
| 10997 | another startup/shutdown operation of this instance inprogress | ||
| 10998 | event to enable short stack dumps in system state dumps | ||
| 10999 | do not get database enqueue name | ||
| 28401 | 屏蔽密码延迟验证， 28401, 00000, "Event to disable delay after three failed login attempts" // *Document: NO // *Cause: N/A // *Action: Set this event in your environment to disable the login delay // which will otherwise take place after three failed login attempts. // *Note: THIS IS NOT A USER ERROR NUMBER/MESSAGE. THIS DOES NOT NEED TO BE // TRANSLATED OR DOCUMENTED. | ALTER SYSTEM SET EVENTS '28401 TRACE NAME CONTEXT FOREVER, LEVEL 1';--屏蔽密码延迟验证 ALTER SYSTEM SET EVENTS '28401 TRACE NAME CONTEXT OFF'; --关闭28401事件 | |
| 5614566 | 如果数据库版本为Oracle 10g以前，那么只能清空整个Shared Pool，命令为：“ALTER SYSTEM FLUSH SHARED_POOL;”。在Oracle 10g中提供了一个包DBMS_SHARED_POOL，该包可以实现该功能。若该包没有安装，则可以通过$ORACLE_HOME/rdbms/admin/dbmspool.sql进行安装。在Oracle 10.2.0.4中有BUG（MOS为：751876.1），需要通过设置事件来规避该问题，命令为：“ ALTER SESSION SET EVENTS '5614566 TRACE NAME CONTEXT FOREVER';” 使用这种方法，就可以精确的将一个SQL从共享池中删除，从而使得Oracle为这个SQL重新生成执行计划。这种方法只针对单个SQL语句，使得解决问题的同时不会造成任何的误伤。 SYS@lhrdb> SELECT ADDRESS,HASH_VALUE FROM V$SQLAREA WHERE ROWNUM<=1; ADDRESS HASH_VALUE ---------------- ---------- 0000000092D263D0 3231842444 SYS@lhrdb> EXEC DBMS_SHARED_POOL.PURGE('0000000092D263D0,3231842444','C'); PL/SQL procedure successfull | ALTER SESSION SET EVENTS '5614566 TRACE NAME CONTEXT FOREVER'; |
看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注亿速云行业资讯频道，感谢您对亿速云的支持。
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。