oracle如何查看执行计划

上一篇 / 下一篇 2011-06-02 18:32:24 / 个人分类：Oracle

1、直接使用sqlplus系统参数：

    SQL> set autotrace on explain
    SQL> select * from dual;
    D
    -
    X
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 272002086
    --------------------------------------------------------------------------
    | Id | Operation                         | Name | Rows | Bytes | Cost (%CPU)| Time     |
    --------------------------------------------------------------------------
    |   0 | SELECT STATEMENT |              |     1     |     2      |     2   (0)         | 00:00:01 |
    |   1 | TABLE ACCESS FULL | DUAL |     1     |     2      |     2   (0)          | 00:00:01 |
    --------------------------------------------------------------------------
    SQL> set autotrace off

    但是这样操作的结果是先执行SQL，再出执行计划，如果SQL耗时巨大，则不现实；

2、使用explain plan for语句：

    SQL> explain plan for select * from dual;
    Explained.
    SQL> select * from table(DBMS_XPLAN.display);
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 2137789089
    ---------------------------------------------------------------------------------------------
    | Id | Operation                                                              | Name        | Rows | Bytes | Cost (%CPU)| Time     |
    ---------------------------------------------------------------------------------------------
    |   0 | SELECT STATEMENT                                       |                   | 8168   | 16336 |    21   (0)| 00:00:01 |
    |   1 | COLLECTION ITERATOR PICKLER FETCH| DISPLAY |             |       |
    |     |
    ---------------------------------------------------------------------------------------------

    这样就可以在执行SQL之前查看执行计划了

3、启用SQL_TRACE跟踪所有后台进程活动：

    全局参数设置：
    ..OracleHome/admin/SID/pfile中指定: SQL_TRACE = true (10g)

    当前session中设置：
    SQL> alter session set SQL_TRACE=true;
    SQL> select * from dual;
    SQL> alter session set SQL_TRACE=false;

    对其他用户进行跟踪设置：
    SQL> select sid,serial#,username from v$session where username='XXX';
       SID    SERIAL# USERNAME
    ------ ---------- ------------------
       127      31923 A
       128      54521 B
       129      48940 B
    SQL> exec dbms_system.set_SQL_TRACE_in_session(127,31923,true);
    SQL> select * from dual;
    SQL> exec dbms_system.set_SQL_TRACE_in_session(127,31923,false);

    然后使用oracle自带的tkprof命令行工具格式化跟踪文件。

4、使用10046事件进行查询：

    10046事件级别：
    Lv1 - 启用标准的SQL_TRACE功能,等价于SQL_TRACE
    Lv4 - Level 1 + 绑定值(bind values)
    Lv8 - Level 1 + 等待事件跟踪
    Lv12 - Level 1 + Level 4 + Level 8

    全局设定：
    ..OracleHome/admin/SID/pfile中指定: EVENT="10046 trace name context forever,level 12"

    当前session设定：
    SQL> alter session set events '10046 trace name context forever, level 8';
    SQL> select * from dual;
    SQL> alter session set events '10046 trace name context off';

    对其他用户进行设置：
    SQL> select sid,serial#,username from v$session where username='XXX';
       SID    SERIAL# USERNAME
    ------ ---------- ------------------
       127      31923 A
       128      54521 B
       129      48940 B
    SQL> exec dbms_system.set_ev(127,31923,10046,8,'A');
    SQL> select * from dual;
    SQL> exec dbms_system.set_ev(127,31923,10046,0,'A');

  5、使用tkprof格式化跟踪文件：

    使用一下SQL找到当前session的跟踪文件：

    ---- 当前 session

SELECT d.value|| '/' ||lower(rtrim(i.instance, chr( 0 )))|| '_ora_' ||p.spid|| '.trc' trace_file_name

from

( select p.spid from v$mystat m,v$session s, v$process p

where m.statistic# = 1 and s.sid = m.sid and p.addr = s.paddr) p,

\I/]5t({ Wx$q`6M0 ( select t.instance from v$thread t,v$parameter v

where v.name = 'thread' and (v.value = 0 or t.thread# = to_number(v.value))) i,

( select value from v$parameter where name = 'user_dump_dest' ) d;

'l$Ta P3ZaU*[m0 ---- 其他用户 session

y [+bN3T2b0 SELECT d.value|| '/' ||lower(rtrim(i.instance, chr( 0 )))|| '_ora_' ||p.spid|| '.trc' trace_file_name

O+h6Xr3}f/ik*v0 from51Testing软件测试网^pe Z,f"vv

( select p.spid from v$session s, v$process p

f3n/Zi]0 where s.sid= '127' and s. SERIAL#= '31923' and p.addr = s.paddr) p,

( select t.instance from v$thread t,v$parameter v

where v.name = 'thread' and (v.value = 0 or t.thread# = to_number(v.value))) i,51Testing软件测试网"S+DVDH'~

/`^zM I@I0 ( select value from v$parameter where name = 'user_dump_dest' ) d;

查找后使用tkprof命令：51Testing软件测试网1h H|Y6MS
SQL> $tkprof D:\......\SID_ora_5352.trc D:\......\SID_ora_5352.txt
5Q3`Zf!n1t9l*VYu0
"n#}i6Rx(MsZ0注：无法使用autotrace的解决办法（9i）：51Testing软件测试网:j!}yphU
SQL>start $ORACLE_HOME/rdbms/admin/utlxplan.sql;

P3?)n#u-@8{ s0SQL>create public synonym plan_table for plan_table;

4q? [ R8zq0SQL>grant ALL on plan_table to public;

/]$I;cb;EJF0-The End-
V#U e%G.tz"u_k0
/X'n%|2@w"m/XuU0 =====================================================================

az@9GZ O8aj0附：ORACLE诊断事件 51Testing软件测试网%x;xTv4g.m
51Testing软件测试网6o%n7Bl7|3I:Oy
Oracle为RDBMS提供了多种的诊断工具，诊断事件(Event)是其中一种常用、好用的方法，它使DBA可以方便的转储数据库各种结构及跟踪特定事件的发生.
(nQ1G~4{dLi0一、Event的通常格式及分类

8gfN(\n({+cs01、通常格式如下：
nt!K+xxp0EVENT="<事件名称><动作><跟踪项目><范围限定>"

8o*qM'I6O!x%k3mI-@Bd_02、 Event分类51Testing软件测试网*w0B;E!X,O|4f
诊断事件大体上可以分为四类：
.L0UC? ET*]0a．转储类事件：它们主要用于转储Oracle的一些结构，例如转储一下控制文件、数据文件头等内容。
0JVY-iIF9p+S3Nb0b．捕捉类事件：它们用于捕捉一些Error事件的发生，例如捕捉一下ORA-04031发生时一些Rdbms信息，以判断是Bug还是其它原因引起的这方面的问题。
v_8p5C2mg0c．改变执行途径类事件：它们用于改主一些Oracle内部代码的执行途径，例如设置10269将会使Smon进程不去合并那些Free的空间。
d．跟踪类事件：这们用于获取一些跟踪信息以用于Sql调优等方面，最典型的便是10046了，将会对Sql进行跟踪。
\%?[6yJ&M#c_t03、说明:
a．如果immediate放在第一个说明是无条件事件，即命令发出即转储到跟踪文件。
(X,~;BKQg0b． trace name位于第二、三项，除它们外的其它限定词是供Oracle内部开发组用的。
w O e6w1TA(t0c． level通常位于1-10之间(10046有时用到12)，10意味着转储事件所有的信息。例如当转储控制文件时，level1表示转储控制文件头，而level 10表明转储控制文件全部内容。
'^'N{U9C0d．转储所生成的trace文件在user_dump_dest初始化参数指定的位置。
jh!Y2K"Z \&g0二、说一说设置的问题了51Testing软件测试网` [!\3tk$p

可以在init.ora中设置所需的事件，这将对所有会话期打开的会话进行跟踪，也可以用alter session set event 等方法设置事件跟踪，这将打开正在进行会话的事件跟踪。51Testing软件测试网jq0bX1Ot

Dy$DLC$aZ01、在init.ora中设置跟踪事件的方法51Testing软件测试网P6R h(~#ef
a．语法51Testing软件测试网cyBgpC
EVENT=”event 语法|,level n|：event 语法|,level n|…”
-t-CN N9U7c,rz[&b0b．举例
O3zV$e/_@hk0event=”10231 trace name context forever,level 10’
M&w]A cp0c．可以这样设置多个事件：
a{S$Gu0EVENT="\51Testing软件测试网n~4x1ed,{2k
10231 trace name context forever, level 10:\
9R'D\!t~vS1V010232 trace name context forever, level 10"

2、通过Alter session/system set events这种方法
-_#Awh3Z0M Sb;l0举个例子大家就明白了
+EC@)XV0Example:
5~7}&]|sp1|h et0 Alter session set events ‘immediate trace name controlf level 10’;
4Qn7o3C#W0r9vQQ0 Alter session set events ‘immediate trace name blockdump level 112511416’; (*)
Px&w5xl$K1v:} dF0在oracle8x及之上的版本也有这样的语句：
,T O6y+rc0 Alter system dump datafile 13 block 15;实现的功能与(*)是类似的。

s5{]]+FAdAig03、使用DBMS_SYSTEM.SET_EV的方法
g\`[.~V,Us0a．过和定义如下
Pjgb9cV9h0DBMS_SYSTEM.SET_EV(51Testing软件测试网oh.|\xR
SI Binary_integer,
SE Binary_integer,
Z1s'Ul[m aA0EV Binary_integer,
LE Binary_integer,
}3{B_@}nA0NM Binary_integer);

SI: 即v$session中的sid
y@J_w']0SE:即v$session中的serial#
EV:要设置的事件
4a3Gcc:S k$C0LE:要设置事件的级别51Testing软件测试网U^0eb.Zs1}
NM:名称51Testing软件测试网j1E!i}Ji(M
b．举个例子，以10046为例
r$CVtQ#e*fL0SQL> EXECUTE SYS.DBMS_SYSTEM.SET_EV(sid,serial#,10046,12,'')；

4、使用Oradebug来设置诊断事件的方法
同样举个例子大家就明白了：
a．找到spid
+u,P|/J)DEM0SQL>select username, sid, serial#, paddr from v$session where username='qiuyb';

![6n9l^AgL@V#K0

/Sn&FQ-YH5g0USERNAME SID SERIAL# PADDR
o%P5WM0g[H Q0--------------------------------------------------------
HRB3 265 910 C000000084435AD8

SQL>SELECT ADDR,PID,SPID FROM V$PROCESS WHERE ADDR= C000000084435AD8';
ADDR PID SPID51Testing软件测试网FrA*quHL
------------------------------------------
)EnvG/d.?8h0C000000084435AD8 91 4835

b．设置事件，以10046为例
.@9u{M&Pm0sqlplus /nolog
!zmd(d[~0SQL>connect / as sysdba;51Testing软件测试网Q0\yEw6UOF
SQL>oradebug setospid 4835
0Hos-{:I_0BY0SQL>oradebug unlimit　　　--不限制转储文件的大小51Testing软件测试网:OdPH} x
SQL> oradebug event 10046 trace name context forever,level 12 --设置事件进行sql跟踪51Testing软件测试网!Q'l)LbU,^

e1Yx:V Y0a5x$m0SQL> oradebug event 10046 trace name context off --关闭跟踪

Or*@B5zueQ0注意不要用oradug去跟踪oracle的smon,pmon等几个进程，操作不当可能会杀掉这几个后台进和引起宕库。

)`;?cv3^~ E]?O0三、你可能的问题

1、我如何知道在系统中设置了哪些event?51Testing软件测试网:M4@1JIT7W9G6_
回答：
a．如果你的事件是在init.ora中设置的可以用
#n'S6QK~L2O0SQL>show parameter event;
来查看
:I-Xs s'dMb0b． Michael R.Ault给的SQL
serveroutput on size 1000000
"RS)NQi@0declare
c2JY"N4B i.I0event_level number;
-O^4x]\c[0begin51Testing软件测试网9K%]J PgR
for i in 10000..10999 loop
8CD&K5u1wl^W0sys.dbms_system.read_ev(i,event_level);
s*[g-tuR!TdqX0if (event_level > 0) then51Testing软件测试网1EMi/|Y6]
dbms_output.put_line('Event '||to_char(i)||' set at level '||
6],ds_[ `0to_char(event_level));51Testing软件测试网ICm7iCs
end if;51Testing软件测试网l9@(EH:s zW
end loop;
Y{%^1\7c r}r0end;51Testing软件测试网.SZm5K2v3Y2C
/51Testing软件测试网:um$]cT b

x*l-T&kT$Klduv$~A02、在oracle9i中使用spfile的那种如何设置诊断事件呢？
!ERTU3RO-KTd7dP E'@0回答：51Testing软件测试网:js%TOU
简单，Alter system命令就可以完成
g e/q;N4GSF;lX0alter system set event='10046 trace name context forever, level 12' scope=spfile;
5Za,Qq-gkQO0重启一下就生效了。51Testing软件测试网R BP3{4l9gr

Kz9~|:O!XW Y03、坏了，我的9i设置完诊断事件，起不来了，报ORA-02194错怎么办?
回答：
` w4E1XpTg9W0那你一定是在使用Alter system时把某一项写错了，比如把context写成了conetxt了，可以做如下的解决：
Q7Z\2ZdU,]q*[S0a．由spfile生成pfile51Testing软件测试网q2kg(`!U*EL
SQL>create pfile from spfile;51Testing软件测试网)JE0}Q2^+q
File created.

W5KRW'uGm:A0b．编辑pfile以修正错误51Testing软件测试网6em7Q,gJ
   Change... *.event='10046 trace name conetxt forever, level 12'
   -to-       *.event='10046 trace name context forever, level 12'51Testing软件测试网7P`.I|]1`OY
c．用pfile启动
uHp2hG9RA0z0   SQL>startup pfile=/.....51Testing软件测试网$Ib.}?B`,~
d.重新生成 SPFILE.
   SQL>create spfile from pfile;
   File created.
Oracle诊断事件列表
ORA-10000: controlfile debug event, name 'control_file'51Testing软件测试网 }[GPCTP
ORA-10001: controlfile crash event1
ORA-10002: controlfile crash event251Testing软件测试网@5Necv1l
ORA-10003: controlfile crash event351Testing软件测试网 Mm9[Y%C
ORA-10004: controlfile crash event4
2}@-h%f+~3x0ORA-10005: trace latch operations for debugging
2k/fe9MT7s Y(yf;M@b0ORA-10006: testing - block recovery forced
d~5H*e9~*A{A[;o0ORA-10007: log switch debug crash after new log select, thread
M n+g7v+W4X6tJ8y0ORA-10008: log switch debug crash after new log header write, thread51Testing软件测试网.U`1pHiL
ORA-10009: log switch debug crash after old log header write, thread51Testing软件测试网r#` O7ms/}{
ORA-10010: Begin Transaction
.}'Ol;~Wu1PY3T0ORA-10011: End   Transaction
ORA-10012: Abort Transaction
K$T6X[ G0A1|.c0ORA-10013: Instance Recovery51Testing软件测试网 YOz/nT;T
ORA-10014: Roll Back to Save Point51Testing软件测试网/R,D8j#^+ZQ:z
ORA-10015: Undo Segment Recovery
7_4|q'U&o0ORA-10016: Undo Segment extend
2w(E`$Aa|0ORA-10017: Undo Segment Wrap
'X"E3~E!UC0ORA-10018: Data Segment Create51Testing软件测试网-{f _/k!@(L4m
ORA-10019: Data Segment Recovery51Testing软件测试网+Sz'x-N)r@S*_
ORA-10020: partial link restored to linked list (KSG)
8`,b9P@+P a0ORA-10021: latch cleanup for state objects (KSS)
Z+B"Um8SW"j'C0ORA-10022: trace ktsgsp
Gg8P/p"Z4c L0ORA-10023: Create Save Undo Segment
6f||$W;D,]%qJ)I0ORA-10024: Write to Save Undo
Bcq`&E I&C'LQ%PQ0ORA-10025: Extend Save Undo Segment
ORA-10026: Apply Save Undo
}?gX\0ORA-10027: Specify Deadlock Trace Information to be Dumped51Testing软件测试网2UA|;h??2k a
ORA-10028: Dump trace information during lock / resource latch cleanup
(a$O@ iR%C%I B JA0ORA-10029: session logon (KSU)
ORA-10030: session logoff (KSU)
:xL3`5U{._P0ORA-10031: sort debug event (S*)
"Y?&A2E4s0ORA-10032: sort statistics (SOR*)51Testing软件测试网p8kv&hNv
ORA-10033: sort run information (SRD*/SRS*)
d@/X6KwOP8tKu0ORA-10035: parse SQL statement (OPIPRS)51Testing软件测试网2{%iw LiV
ORA-10036: create remote row source (QKANET)
!E1a5c^pU@`2?c0ORA-10037: allocate remote row source (QKARWS)51Testing软件测试网P)qv'Cq|^A
ORA-10038: dump row source tree (QBADRV)
ORA-10039: type checking (OPITCA)51Testing软件测试网h2s?8T'O/K6k
ORA-10040: dirty cache list51Testing软件测试网 Dta0YR;}'LM
ORA-10041: dump undo records skipped
\O~E [i!@7i D0ORA-10042: trap error during undo application
D jm XM^$d0A0ORA-10043: check consistency of owner/waiter/converter lists in KSQ
k-CyEHH(h|S#O0ORA-10044: free list undo operations
Ax]b/Pd9z0ORA-10045: free list update operations - ktsrsp, ktsunl51Testing软件测试网N_ r'Gt1b
ORA-10046: enable SQL statement timing
H;k~P/o0ORA-10047: trace switching of sessions
#S[#GiZ0g0ORA-10048: Undo segment shrink
s+qj!Zj"^8PZ[0ORA-10049: protect library cache memory heaps51Testing软件测试网6`)T-LjF6kQ,U
ORA-10050: sniper trace
ORA-10051: trace OPI calls51Testing软件测试网qi v\{_%]
ORA-10052: don't clean up obj$
ORA-10053: CBO Enable optimizer trace51Testing软件测试网,qsO"gA)X
ORA-10054: trace UNDO handling in MLS51Testing软件测试网f0Wq3X.U.cz
ORA-10055: trace UNDO handing
HQ.J@&I.j3c0ORA-10056: dump analyze stats (kdg)
ORA-10057: suppress file names in error messages51Testing软件测试网I1Z:{1~e8?YA
ORA-10058: use table scan cost in tab$.spare151Testing软件测试网'a3z/g(AH_x
ORA-10059: simulate error in logfile create/clear
!rM-~9R4n?+B2gK0ORA-10060: CBO Enable predicate dump
9` x F#t`/Y[/Ksv.I0ORA-10061: disable SMON from cleaning temp segment
Rf\!u8`;f0ORA-10062: disable usage of OS Roles in osds
X7Y1m7mu~0ORA-10063: disable usage of DBA and OPER privileges in osds
)l]6s}Y8E0ORA-10064: thread enable debug crash level , thread
:La1O#X4U1rRW/d0ORA-10065: limit library cache dump information for state object dump51Testing软件测试网F6\o_~)i/k^
ORA-10066: simulate failure to verify file
ORA-10067: force redo log checksum errors - block number
o:[7egw1FP"h0ORA-10068: force redo log checksum errors - file number51Testing软件测试网:a9lvdy}
ORA-10069: Trusted Oracle test event
&jJzx+N/Mm?]5l0ORA-10070: force datafile checksum errors - block number
D ky7L*C0ORA-10071: force datafile checksum errors - file number
L.kA5b)zXHF7l;}Z0ORA-10072: protect latch recovery memory51Testing软件测试网e&wG]N?
ORA-10073: have PMON dump info before latch cleanup51Testing软件测试网7e0h:?N8lgF
ORA-10074: default trace function mask for kst51Testing软件测试网jP5RV'yb Ku
ORA-10075: CBO Disable outer-join to regular join conversion
9^p ?dQMG0ORA-10076: CBO Enable cartesian product join costing
ORA-10077: CBO Disable view-merging optimization for outer-joins51Testing软件测试网\ `%m\(~
ORA-10078: CBO Disable constant predicate elimination optimization
Pv#zV9ex/H Nhj0ORA-10079: trace data sent/received via SQL*Net
)pFoQEi4xQ0ORA-10080: dump a block on a segment list which cannot be exchanged
ORA-10081: segment High Water Mark has been advanced
ORA-10082: free list head block is the same as the last block
DX6p6hx0ORA-10083: a brand new block has been requested from space management
"J:?4^#Pw0kQ3GhMt0ORA-10084: free list becomes empty
9`%Muh,[k*z`f2c-H0ORA-10085: free lists have been merged
)vBp9Idl~4s,X0ORA-10086: CBO Enable error if kko and qka disagree on oby sort51Testing软件测试网kV0B y\h/l
ORA-10087: disable repair of media corrupt data blocks
ORA-10088: CBO Disable new NOT IN optimization51Testing软件测试网C3S-[7y{~
ORA-10089: CBO Disable index sorting51Testing软件测试网9L)|aW Q_ N
ORA-10090: invoke other events before crash recovery
ORA-10091: CBO Disable constant predicate merging51Testing软件测试网mFH'u%ji
ORA-10092: CBO Disable hash join
U1qvISg(N'h(I(MG0ORA-10093: CBO Enable force hash joins
$^cH7uG1K0ORA-10094: before resizing a data file51Testing软件测试网 _j[2d%fmE
ORA-10095: dump debugger commands to trace file
xz`Bz2j0C4D/A(^4D0ORA-10096: after the cross instance call when resizing a data file
-P~4d`q0ORA-10097: after generating redo when resizing a data file
u1Li R4WYfkP$_4v0ORA-10098: after the OS has increased the size of a data file51Testing软件测试网3o6_4@JG8t(g:O
ORA-10099: after updating the file header with the new file size51Testing软件测试网|fw6\;i3?,``
ORA-10100: after the OS has decreased the size of a data file
]@g2FlLB#Z-r0ORA-10101: atomic redo write recovery
|*? Ye:wy0ORA-10102: switch off anti-joins51Testing软件测试网{0]\LG
ORA-10103: CBO Disable hash join swapping
8W8E-dlT0ORA-10104: dump hash join statistics to trace file
ORA-10105: CBO Enable constant pred trans and MPs w WHERE-clause
Z8H@"a.G.s*h:hz0ORA-10106: CBO Disable evaluating correlation pred last for NOT IN51Testing软件测试网(A~)acRhF
ORA-10107: CBO Always use bitmap index
)}[1k+qRt0ORA-10108: CBO Don't use bitmap index
ORA-10109: CBO Disable move of negated predicates
,TJN d^ Q!c0ORA-10110: CBO Try index rowid range scans51Testing软件测试网GC*v~Em
ORA-10111: Bitmap index creation switch
l b0_ ] x&u0ORA-10112: Bitmap index creation switch
.yIc;s*R"\0ORA-10113: Bitmap index creation switch
N6R9S&_^B;X%sC0ORA-10114: Bitmap index creation switch
ORA-10115: CBO Bitmap optimization use maximal expression51Testing软件测试网rdPH$r S
ORA-10116: CBO Bitmap optimization switch
(NB0iNFe0ORA-10117: CBO Disable new parallel cost model
8\6N-A)]G7k0ORA-10118: CBO Enable hash join costing
R j` j?%]~#T0ORA-10119: QKA Disable GBY sort elimination51Testing软件测试网Z5{ KiT1PG
ORA-10120: generate relative file # different from absolute
ORA-10121: CBO Don't sort bitmap chains
ORA-10122: Disable transformation of count(col) to count(*)
wh3jocs+tm%_0ORA-10123: QKA Disable Bitmap And-EQuals51Testing软件测试网i5URs;h7X
ORA-10124: Force creation of segmented arrays by kscsAllocate
B!~0T |;@3Rf0ORA-10125: Disable remote sort elimination
[ TH+y G]0ORA-10126: Debug oracle java xa
'WMG W$X&s5HmB0ORA-10127: Disable remote query block operation51Testing软件测试网3pm#B Od
ORA-10128: Dump Partition Pruning Information
O4L1Rb:Ecm4DE0ORA-10129: Alter histogram lookup for remote queries51Testing软件测试网3m$Y~us e8r1D
ORA-10130: sort disable readaheads
ORA-10131: use v$sql_plan code path for explain plan
y[6^LK]O0X0ORA-10132: dump plan after compilation
IJ C$fqf8v!P*C&gp0ORA-10133: testing for SQL Memory Management
ORA-10134: tracing for SQL Memory Management for session
;xwd#J+EB%k*x0ORA-10135: CBO do not count 0 rows partitions
/]y^IXpW0ORA-10136: CBO turn off fix for bug 108984851Testing软件测试网~p,XL%kn
ORA-10137: CBO turn off fix for bug 1344111
ORA-10138: CBO turn off fix for bug 1577003
K{){I5u\0ORA-10139: CBO turn off fix for bug 138611951Testing软件测试网wN:^H0N(b1{(~
ORA-10140: CBO turn off fix for bug 133298051Testing软件测试网i9I3aGv%c's
ORA-10141: CBO disable additional keys for inlist in bitmap optimization
ORA-10142: CBO turn off advanced OR-expansion checks
F N F%qt#ksi"]0ORA-10143: CBO turn off hints
"|n7|]i"|0h7A0ORA-10144: CBO turn off cost based selection of bji over bsj subquery
!l!H3Fi#nR.C,nt0ORA-10145: test auditing network errors
L,NNk!kh |gv0ORA-10146: enable Oracle TRACE collection
ORA-10147: enable join push through UNION view
ORA-10148: Use pre-7.3.3 random generator51Testing软件测试网4e Jqm#]:ju
ORA-10149: allow the creation of constraints with illegal date constants51Testing软件测试网d-~A(GN~
ORA-10150: import exceptions
o R)Qxd-o*f[HT P{0ORA-10151: Force duplicate dependency removal51Testing软件测试网%eI)t)D{I|
ORA-10152: CBO don't consider function costs in plans51Testing软件测试网8k3HwSa8I
ORA-10153: Switch to use public synonym if private one does not translate
ORA-10154: Switch to disallow synonyms in DDL statements51Testing软件测试网L\XM] C5}#k
ORA-10155: CBO disable generation of transitive OR-chains51Testing软件测试网"{#|oX2A%PB
ORA-10156: CBO disable index fast full scan
ORA-10157: CBO disable index access path for in-list
s'Lc}%nZ0ORA-10158: CBO preserve predicate order in post-filters
G]}4A/AT#Gz0ORA-10159: CBO disable order-by sort pushdown into domain indexes
Y&q'G+c@2k}\1oP;q0ORA-10160: CBO disable use of join index
0~L3G1y6{2T\0ORA-10161: CBO recursive semi-join on/off-switch
IN4wCFL.{0ORA-10162: CBO join-back elimination on/off-switch
'r"C2RJ)~;|/~L0ORA-10163: CBO join-back elimination on/off-switch
ORA-10164: CBO disable subquery-adjusted cardinality fix51Testing软件测试网!_8@eF cP
ORA-10165: mark session to be aborted during shutdown normal
&NcF.o hvF,C0ORA-10166: trace long operation statistics updates
ORA-10167: CBO use old index MIN/MAX optimization
ORA-10168: CBO disable single-table predicate predicate generation
3P!^J9`J*N4?0ORA-10169: CBO disable histograms for multi partitions
9N0tPr@ej%p/yw0Y0P1{0ORA-10170: CBO use old bitmap costing51Testing软件测试网5R1Od ZF%f
ORA-10171: CBO disable transitive join predicates51Testing软件测试网3e)j0T(\bVZ
ORA-10172: CBO force hash join back
;eLc g6X&d#MC0ORA-10173: CBO no constraint-based join-back elimination
ORA-10174: view join-back elimination switch
;ui:I pm0^b;]*C4`0ORA-10175: CBO star transformation switch
P M9q%kQ9M0ORA-10176: CBO colocated join switch
ORA-10177: CBO colocated join switch51Testing软件测试网YU{;p UX
ORA-10178: CBO turn off hash cluster filtering through memcmp
0j+{c'N%m#o0ORA-10179: CBO turn off transitive predicate replacement
z P,Mn$Dm'X(E9i0ORA-10180: temp table transformation print error messages51Testing软件测试网g&G@.}9U
ORA-10181: CBO disable multi-column in-list processing
ORA-10182: CBO disable generation of implied predicates51Testing软件测试网&CL)AD5zC{
ORA-10183: CBO disable cost rounding
{m%[!s|P1s| B0ORA-10184: CBO disable OR-exp if long inlist on bitmap column
F#I{g0o`gB2yF@7r0ORA-10185: CBO force index joins
ORA-10186: CBO disable index join51Testing软件测试网L{N3]US/C9~
ORA-10187: CBO additional index join switch51Testing软件测试网Q(lMqi&t
ORA-10188: CBO additional index join switch
K+r)f^YO)W2o(@+y R0ORA-10189: CBO turn off FFS null fix
ORA-10190: Analyze use old frequency histogram collection and density51Testing软件测试网Uh_P`1i6G
ORA-10191: Avoid conversion of in-lists back to OR-expanded form
ORA-10192: nopushdown when number of groups exceed number of rows
/i%tCc/jOkP[ f'a0ORA-10193: Force repeatable sampling with specified seed
ORA-10194: CBO disable new LIKE selectivity heuristic51Testing软件测试网7SJ m:M.C
ORA-10195: CBO don't use check constraints for transitive predicates51Testing软件测试网-LWKf,R(N8w
ORA-10196: CBO disable index skip scan51Testing软件测试网sZa,^c{l
ORA-10197: CBO force index skip scan51Testing软件测试网g;o+mzC%[
ORA-10198: check undo record51Testing软件测试网6dw!D\Vu y
ORA-10199: set parameter in session
UcX ~r@d5]0ORA-10200: consistent read buffer status
M#a5w'[0P-B0ORA-10201: consistent read undo application
a.a @-dhu?U8c0ORA-10202: consistent read block header51Testing软件测试网Wb?IHa
ORA-10203: block cleanout51Testing软件测试网\.ux/\ P
ORA-10204: signal recursive extend51Testing软件测试网xB)E5c%pw
ORA-10205: row cache debugging
d,MK9`Rd;D0ORA-10206: transaction table consistent read
ORA-10207: consistent read transactions' status report
ORA-10208: consistent read loop check
ORA-10209: enable simulated error on controlfile
ORA-10210: check data block integrity
"K g8R u-~t"@C{;@0ORA-10211: check index block integrity51Testing软件测试网e l k1^dc
ORA-10212: check cluster integrity
(_7@%NOpP{0ORA-10213: crash after controlfile write
ORA-10214: simulate write errors on controlfile51Testing软件测试网 K-X y:jN
ORA-10215: simulate read errors on controlfile
n9S.M/kr x @0ORA-10216: dump controlfile header
]J!e)d&W#z-mK]W0ORA-10217: debug sequence numbers
h6k?a/O!W:cN0ORA-10218: dump uba of applied undo
4W,LsukM0ORA-10219: monitor multi-pass row locking51Testing软件测试网%M mru9gL
ORA-10220: show updates to the transaction table
ORA-10221: show changes done with undo
9u,|[Up|0ORA-10222: row cache
M%j7pnJ4x3b2}%P0ORA-10223: transaction layer - turn on verification codes51Testing软件测试网cFP_J
ORA-10224: index block split/delete trace
ORA-10225: free/used extent row cache
ORA-10226: trace CR applications of undo for data operations
ORA-10227: verify (multi-piece) row structure51Testing软件测试网3T(F@nFs,V
ORA-10228: trace application of redo by kcocbk51Testing软件测试网/unq@x
ORA-10229: simulate I/O error against datafiles
ORA-10230: check redo generation by copying before applying
*j9r5R,eNeD0ORA-10231: skip corrupted blocks on _table_scans_
)@(G&yxmz,|m q(t0ORA-10232: dump corrupted blocks symbolically when kcbgotten
ORA-10233: skip corrupted blocks on index operations
e.z@$b^p$`,^,F'f0ORA-10234: trigger event after calling kcrapc to do redo N times
ORA-10235: check memory manager internal structures
%E$Q{6BHy#lNU_ M0ORA-10236: library cache manager
V SeAV-C2m0ORA-10237: simulate ^C (for testing purposes)51Testing软件测试网:}wGYs4aT[
ORA-10238: instantiation manager
ORA-10239: multi-instance library cache manager51Testing软件测试网8@{YLhg
ORA-10240: dump dba's of blocks that we wait for51Testing软件测试网5R3[Okor3S
ORA-10241: remote SQL execution tracing/validation
UHf^^%\0ORA-10242: suppress OER 2063 (for testing distrib w/o different error log)
ORA-10243: simulated error for test of K2GTAB latch cleanup
ORA-10244: make tranids in error msgs print as 0.0.0 (for testing)
QJHZ!e"Q0ORA-10245: simulate lock conflict error for testing PMON
2NMy`+V"o D!zf[a0ORA-10246: print trace of PMON actions to trace file
)\/W$@R!t&Pn0ORA-10247: Turn on scgcmn tracing. (VMS ONLY)
-oP$po [1F0ORA-10248: turn on tracing for dispatchers
+xy1~p8? gh@0ORA-10249: turn on tracing for multi-stated servers
a$oAP\r&F0ORA-10250: Trace all allocate and free calls to the topmost SGA heap51Testing软件测试网7pc|.r_
ORA-10251: check consistency of transaction table and undo block51Testing软件测试网!MbO%A0A
ORA-10252: simulate write error to data file header
ORA-10253: simulate write error to redo log51Testing软件测试网KQt*D8soB
ORA-10254: trace cross-instance calls51Testing软件测试网OA6m oEI9@
ORA-10255: pl/sql parse checking
HRkcj,lt0ORA-10256: turn off shared server load balancing
8`5{)mdt^0ORA-10257: trace shared server load balancing
uA4C;lQ`"E qk0ORA-10258: force shared servers to be chosen round-robin51Testing软件测试网y ]6g$yn j
ORA-10259: get error message text from remote using explicit call
"}w@Y5c:l0ORA-10260: Trace calls to SMPRSET (VMS ONLY)
Dl1Q1@5w0ORA-10261: Limit the size of the PGA heap
ORA-10262: Don't check for memory leaks51Testing软件测试网'B&ZB:J(a)~ m
ORA-10263: Don't free empty PGA heap extents
c2ISa4bh0ORA-10264: Collect statistics on context area usage (x$ksmcx)51Testing软件测试网#ugP#_8M
ORA-10265: Keep random system generated output out of error messages
/`p.[-e!Oj0ORA-10266: Trace OSD stack usage
x!MNq-NH'})~0ORA-10267: Inhibit KSEDMP for testing
ORA-10268: Don't do forward coalesce when deleting extents51Testing软件测试网VP] h}G`
ORA-10269: Don't do coalesces of free space in SMON51Testing软件测试网b_1X~t_1_^
ORA-10270: Debug shared cursors
ORA-10271: distributed transaction after COLLECT
ORA-10272: distributed transaction before PREPARE
ORA-10273: distributed transaction after PREPARE
PV7ZN:p1R0ORA-10274: distributed transaction before COMMIT
o(?:CQ9vVMf0ORA-10275: distributed transaction after COMMIT
![:X/Z)]+OWY&Q,d0ORA-10276: distributed transaction before FORGET51Testing软件测试网9aK8~,gQK'z
ORA-10277: Cursor sharing (or not) related event (used for testing)
RX|mG kz'P qn0ORA-10278: Internal testing
?L@Nu&N%jQ$h0ORA-10279: Simulate block corruption in kdb4chk
]4bc+D$LEoc3]0ORA-10280: Internal testing - segmentation fault during crash recovery
/bJ(G\ D!VBh0ORA-10281: maximum time to wait for process creation
ORA-10282: Inhibit signalling of other backgrounds when one dies51Testing软件测试网 OGvG#i1P6|
ORA-10283: simulate asynch I/O never completing
#@+W:[0U-G:~0ORA-10284: simulate zero/infinite asynch I/O buffering
]!h4m tjG-hz0ORA-10285: Simulate controlfile header corruption
Z*B+X3og'~0ORA-10286: Simulate controlfile open error
ORA-10287: Simulate archiver error
hq0y(S6COB6w7W0ORA-10288: Do not check block type in ktrget
ORA-10289: Do block dumps to trace file in hex rather than fromatted
ORA-10290: kdnchk - checkvalid event - not for general purpose use.51Testing软件测试网x`b.[,J
ORA-10291: die in tbsdrv to test controlfile undo
#uU7Zc0pp mQ }c0ORA-10292: dump uet entries on a 1561 from dtsdrv51Testing软件测试网0Z^7KE1o_Xi
ORA-10293: dump debugging information when doing block recovery51Testing软件测试网+@k%{wb
ORA-10294: enable PERSISTENT DLM operations on non-compliant systems51Testing软件测试网 Z Gx'}n6X
ORA-10295: die after file header update durning cf xact51Testing软件测试网Nhj.F B;dA
ORA-10296: disable ORA-37951Testing软件测试网tU.{y` w
ORA-10297: customize dictionary object number cache
+bTfIIn0ORA-10298: ksfd i/o tracing51Testing软件测试网Zm{EHG)VW-`
ORA-10299: Trace prefetch tracking decisions made by CKPT
D0E4J(sF0ORA-10300: disable undo compatibility check at database open
*\b&m-EL7n.T3d0ORA-10301: Enable LCK timeout table consistency check51Testing软件测试网)_iMyS(w
ORA-10302: trace create or drop internal trigger
ORA-10303: trace loading of library cache for internal triggers
ORA-10304: trace replication trigger
[P#B/I{.M1d+wv0ORA-10305: trace updatable materialized view trigger
S7Tf!K[sa0ORA-10306: trace materialized view log trigger51Testing软件测试网i9KxKr{Q
ORA-10307: trace RepCat execution
ORA-10308: replication testing event51Testing软件测试网4bN?Xh-r%x
ORA-10309: Trigger Debug event51Testing软件测试网j_4zoS
ORA-10310: trace synchronous change table trigger
e lw'Kq~2^0ORA-10311: Disable Flashback Table Timestamp checking
R-n0U-}8Vu2? U+@0ORA-10312: Allow disable to log rows into the mapping table
u A~5u"Ya0ORA-10313: Allow Row CR operations for single instance
m e:D3Y4fhz(u0ORA-10314: Enable extra stats gathering for CR
_8Nd en@0ORA-10316: Events for extensible txn header, non zero ext header size51Testing软件测试网@$qgW6i#G
ORA-10317: Events for extensible txn header, zero ext header size
ORA-10318: Trace extensible txn header movements51Testing软件测试网!H!h'v8hs0q$}
ORA-10319: Trace PGA statistics maintenance
;^I k;|7\&WDe1p0ORA-10320: Enable data layer (kdtgrs) tracing of space management calls
ORA-10321: Datafile header verification debug failure.
#ad s t$r{ x0ORA-10322: CBO don't simplify inlist predicates
ORA-10323: before committing an add datafile command
G*dT$M A&z/{E2E| R0ORA-10324: Enable better checking of redo logs errors
g$X }o&w0Xz vl0ORA-10325: Trace control file record section expand and shrink operations
[E0`.zX,C_t/w0ORA-10326: clear logfile debug crash at , log
ORA-10327: simulate ORA-00235 error for testing
rW3yh h ^"u `z0ORA-10328: disable first-to-mount split-brain error, for testing
ORA-10329: simulate lost write, test detection by two-pass recovery51Testing软件测试网`woF2B"z5a
ORA-10330: clear MTTR statistics in checkpoint progress record51Testing软件测试网#Y ~ hen5|8ZK
ORA-10331: simulate resilvering during recovery51Testing软件测试网9Y c YP:W1l2^h
ORA-10332: force ALTER SYSTEM QUIESCE RESTRICTED command to fail51Testing软件测试网U0p'aLD,~*|1?
ORA-10333: dump MTTR statistics each time it is updated
F h}4ki q^0ORA-10334: force FG to wait to be killed during MTTR advisory simulation
ORA-10336: Do remote object transfer using remote SQL
ORA-10337: enable padding owner name in slave sql
&Ge;M3t2~aq^0ORA-10338: CBO don't use inlist iterator with function-based indexes
ORA-10339: CBO disable DECODE simplification
+n#[@H(dOq0ORA-10340: Buffer queues sanity check for corrupted buffers51Testing软件测试网&J8dY|'MY
ORA-10341: Simulate out of PGA memory in DBWR during object reuse
/h%x~/mS!G0ORA-10342: Raise unknown exception in ACQ_ADD when checkpointing
ORA-10343: Raise an out of memory exception-OER 4031 in ACQ_ADD
\tcNW*k$]'T,`(RQ.G0ORA-10344: Simulate kghxal returning 0 in ACQ_ADD but no exception
ORA-10345: validate queue when linking or unlinking a buffer
ORA-10346: check that all buffers for checkpoint have been written
%X-}:t%f R!j ~$f0ORA-10347: dump active checkpoint entries and checkpoint buffers
R(tAZrp c A0ORA-10348: test abnormal termination of process initiating file checkpoint51Testing软件测试网;~$Xu9_.s3s(v
ORA-10349: do not allow ckpt to complete51Testing软件测试网\U#??&b`
ORA-10350: Simulate more than one object & tsn id in object reuse
?`g }2rR dU0ORA-10351: size of slots
*?#s#x$Gz0ORA-10352: report direct path statistics
:n^PUd}R0zo0ORA-10353: number of slots
V#R)J.GZ?%C"i?0ORA-10354: turn on direct read path for parallel query51Testing软件测试网^"VWw9B9|-w
ORA-10355: turn on direct read path for scans51Testing软件测试网cF|i9vN
ORA-10356: turn on hint usage for direct read
_Cmx5_u:X.|0ORA-10357: turn on debug information for direct path
oHH1?ons0ORA-10358: Simulate out of PGA memory in cache advisory reset
ORA-10359: turn off updates to control file for direct writes51Testing软件测试网.g/b3_C#t U
ORA-10360: enable dbwr consistency checking
ORA-10365: turn on debug information for adaptive direct reads
W0Omi:z!@9m)b0ORA-10370: parallel query server kill event
n_~u*?0ORA-10371: disable TQ hint
7W?{/k"lF1[z'_@^0ORA-10372: parallel query server kill event proc51Testing软件测试网9f+l#hH"c
ORA-10373: parallel query server kill event
LW VZ-oT0ORA-10374: parallel query server interrupt (validate lock value)
ek}(fx9n0ORA-10375: turn on checks for statistics rollups
ORA-10376: turn on table queue statistics51Testing软件测试网jo\&}g%R{U
ORA-10377: turn off load balancing
3Hc4{:d;F6ECS4Y0ORA-10378: force hard process/range affinity
"G1ccW*O]3kW5A%J0ORA-10379: direct read for rowid range scans (unimplemented)
s9e)~ @ c"aL0ORA-10380: kxfp latch cleanup testing event
ORA-10381: kxfp latch cleanup testing event
J/?/t ku,CXv3d0ORA-10382: parallel query server interrupt (reset)
2C4jw MH2[0ORA-10383: auto parallelization testing event
s } \ {g6?c0ORA-10384: parallel dataflow scheduler tracing
R;VO*E1d:K%`%V'B0ORA-10385: parallel table scan range sampling method
ORA-10386: parallel SQL hash and range statistics
Z-tkU H8YG0ORA-10387: parallel query server interrupt (normal)
-^ITJC_~`0ORA-10388: parallel query server interrupt (failure)
:YC-W9H kk$|%j0ORA-10389: parallel query server interrupt (cleanup)51Testing软件测试网Ty6Y1g,vdi
ORA-10390: Trace parallel query slave execution
sMs]Tl2[0ORA-10391: trace PX granule allocation/assignment
(X/R/u0[0?9~:W8a B[0ORA-10392: parallel query debugging bits
Jr*zc3i9y1@f*NV_0ORA-10393: print parallel query statistics51Testing软件测试网?G+UBy
ORA-10394: generate a fake load to test adaptive and load balancing
ORA-10395: adjust sample size for range table queues
YF#KxW tw/y0ORA-10396: circumvent range table queues for queries
-n goREJ2M_E!N0ORA-10397: suppress verbose parallel coordinator error reporting
ORA-10398: enable timeouts in parallel query threads
!M(@KR+N @g`b B0ORA-10399: trace buffer allocation51Testing软件测试网"_c)B*UZS-q
ORA-10400: turn on system state dumps for shutdown debugging51Testing软件测试网bgE!Rr^ J
ORA-10401: turn on IPC (ksxp) debugging
ORA-10402: turn on IPC (skgxp) debugging51Testing软件测试网4_"JU6Ad4~2Yk
ORA-10403: fake CPU number for default degree of parallelism
OdXwt"e5U0ORA-10404: crash dbwr after write
ORA-10405: emulate broken mirrors51Testing软件测试网1Vkw[n }x{
ORA-10406: enable datetime TIMESTAMP, INTERVAL datatype creation51Testing软件测试网:}%? u5[{n{
ORA-10407: enable datetime TIME datatype creation51Testing软件测试网UaLNQcj-j
ORA-10408: disable OLAP builtin window function usage51Testing软件测试网,CZ~_{,O-B
ORA-10409: enable granule memset and block invalidation at startup
ORA-10410: trigger simulated communications errors in KSXP
&W"bU'UcA0ORA-10411: simulate errors in IMR
ORA-10412: trigger simulated errors in CGS/CM interface
5c?JP2l0ORA-10413: force simulated error for testing purposes51Testing软件测试网'c1lKet
ORA-10414: simulated error from event level51Testing软件测试网SH}cI
ORA-10425: enable global enqueue service open event trace
/G1Dw:_f `(mE0ORA-10426: enable global enqueue service convert event trace51Testing软件测试网,|Zi T q"K&[
ORA-10427: enable global enqueue service traffic controller event trace
ORA-10428: enable tracing of global enqueue service distributed resource
,i'th@_&`0v0ORA-10429: enable tracing of global enqueue service IPC calls
6~yC6k1k0`0ORA-10430: enable tracing of global enqueue service AST calls
ORA-10431: enable verification messages on pi consistency
-]1ie [tW/cZ0ORA-10432: enable tracing of global cache service fusion calls51Testing软件测试网0NbcPIrJY
ORA-10433: global enqueue service testing event
a/v+ea[Ryeyr0ORA-10434: enable tracing of global enqueue service multiple LMS
ORA-10435: enable tracing of global enqueue service deadlock detetction
%Ah1Y!~&BS1Z:w0ORA-10436: enable global cache service duplicate ping checking51Testing软件测试网]4y^| lB
ORA-10437: enable trace of global enqueue service S optimized resources
@;p(U9CG!Y2L0ORA-10442: enable trace of kst for ORA-01555 diagnostics
ORA-10450: signal ctrl-c in kdddca (drop column) after n rows
`I\3b |T3hwzd0ORA-10496: Turn off fix for bug 2554178
ORA-10498: Trim blank characters including contol characters
7C S.g'G?*CG0ORA-10499: revert to old scale behaviour
.Ftb^K_0ORA-10500: turn on traces for SMON
P(jtJh0ORA-10501: periodically check selected heap
#E+{r p+xJ nA0ORA-10502: CBO disable the fix for bug 2098120
ORA-10503: enable user-specified graduated bind lengths
7d&k"f*Qc,T b(B6\z0ORA-10504: CBO disable the fix for bug 2607029
z9p5C1AcI^`3T,V0ORA-10510: turn off SMON check to offline pending offline rollback segment
;x%S.{.zV^0ORA-10511: turn off SMON check to cleanup undo dictionary
7^hMM tAxD.y0ORA-10512: turn off SMON check to shrink rollback segments
]r8Tx8v*~S0ORA-10513: turn off wrap source compression51Testing软件测试网d/Tz_H,m+R
ORA-10515: turn on event to use physical cleanout51Testing软件测试网R,E0U,Zv"F(j
ORA-10520: recreate package/procedure/view only if definition has changed
(\sh.dO0ORA-10550: signal error during create as select/create index after n rows
LV*a?F] rBUA0ORA-10560: block type ''
:H.U~W%a+P;A0ORA-10561: block type '', data object#51Testing软件测试网{Q7IFkd
ORA-10562: Error occurred while applying redo to data block (file# , block# )
h-klq%[#h:s5^0ORA-10563: Test recovery had to corrupt data block (file# , block# ) in order to proceed51Testing软件测试网-@ND0jeya
ORA-10564: tablespace
S:j O$j0_-?0ORA-10565: Another test recovery session is active51Testing软件测试网LN9y G4V,Q
ORA-10566: Test recovery has used all the memory it can use
HQ!]8@a/V4o$Z0ORA-10567: Redo is inconsistent with data block (file# , block# )
1Ttn q \/r~4w.] k]0ORA-10568: Failed to allocate recovery state object: out of SGA memory
|fb BN^ o0ORA-10570: Test recovery complete51Testing软件测试网+m+w;kU&hu
ORA-10571: Test recovery canceled
5M'j:U$}8RFa'v0ORA-10572: Test recovery canceled due to errors
^ I0io(c4_L*u;?0ORA-10573: Test recovery tested redo from change to
1L7sP"]$V g3W @r?0ORA-10574: Test recovery did not corrupt any data block
ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory51Testing软件测试网];v3K-hs4g$M
ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred
7N~@3gW(x0ORA-10577: Can not invoke test recovery for managed standby database recovery51Testing软件测试网Nc-h/Lv&Ns
ORA-10578: Can not allow corruption for managed standby database recovery
ORA-10579: Can not modify control file during test recovery
ORA-10580: Can not modify datafile header during test recovery
ORA-10581: Can not modify redo log header during test recovery51Testing软件测试网'p%W;rhk8@+|
ORA-10582: The control file is not a backup control file
ORA-10583: Can not recovery file renamed as missing during test recovery
-r:n1bLs+[0_0ORA-10584: Can not invoke parallel recovery for test recovery
&U%LJw"x6lY0ORA-10585: Test recovery can not apply redo that may modify control file
2G1OwGu0ORA-10586: Test recovery had to corrupt 1 data block in order to proceed51Testing软件测试网,|v0|4yk{(r
ORA-10587: Invalid count for ALLOW n CORRUPTION option
ORA-10588: Can only allow 1 corruption for normal media/standby recovery
nS3L!o&H(D!p X CG0ORA-10589: Test recovery had to corrupt data blocks in order to proceed51Testing软件测试网;ST-N0H{vQr
ORA-10590: kga (argus debugger) test flags51Testing软件测试网.l?;s[z
ORA-10591: kga (argus debugger) test flags
)q]AjT0ORA-10592: kga (argus debugger) test flags
ORA-10593: kga (argus debugger) test flags
2Bt8WLN0ORA-10594: kga (argus debugger) test flags51Testing软件测试网 TC2BAMg1cH
ORA-10595: kga (argus debugger) test flags
QQ:J!zE/}0ORA-10596: kga (argus debugger) test flags
9SI3T'dMFp2r%`/y0ORA-10597: kga (argus debugger) test flags
{~c(d0ck0ORA-10598: kga (argus debugger) test flags
ORA-10599: kga (argus debugger) test flags
ORA-10600: check cursor frame. allocation
#sY_iIu?0ORA-10601: turn on debugging for cursor_sharing (literal replacement)51Testing软件测试网yp)oNS"H
ORA-10602: cause an access violation (for testing purposes)
0hgY@/S(_ EM0ORA-10603: cause an error to occur during truncate (for testing purposes)
ORA-10604: trace parallel create index
O~$M[ eM0ORA-10605: enable parallel create index by default
ORA-10606: trace parallel create index
*@'v/T*kK0l0ORA-10607: trace index rowid partition scan51Testing软件测试网V(NcR3ah
ORA-10608: trace create bitmap index
2E{%u C0TM0ORA-10609: trace for array index insertion
)j5k)a A@&_FB&MXV0ORA-10610: trace create index pseudo optimizer
ORA-10611: causes migration to fail - testing only
3ya*Bb_/h/]/N"c H-[ I0ORA-10612: prints debug information for auto-space managed segments
\~C"XiH9R a'C2rh0ORA-10613: prints debug information for auto-space managed segments51Testing软件测试网+Nh7Y|M9o
ORA-10614: Operation not allowed on this segment51Testing软件测试网(`.V[_ xM,en
ORA-10615: Invalid tablespace type for temporary tablespace
ORA-10616: Operation not allowed on this tablespace
pf?"^p.Q5]yH2R0ORA-10617: Cannot create rollback segment in dictionary managed tablespace51Testing软件测试网7[J*B/sK3f$E
ORA-10618: Operation not allowed on this segment
iz,W#R-y0K0ORA-10619: Avoid assertions when possible
)Qs7x8TB,\N!y'U0ORA-10620: Operation not allowed on this segment51Testing软件测试网NvD,X3](Kg
ORA-10621: data block does not belong to the segment
(@0I ]k@`0ORA-10622: test/trace online index (re)build
/r sW"Y ?s\F0ORA-10623: Enable Index range scan Prefetch - testing only
-w"g.D.B'X0ORA-10624: Disable UJV invalidation on drop index51Testing软件测试网 [qH:` f&^3m
ORA-10625: Turn off redo log dump for the index when OERI 12700
4@"do([}U?0ORA-10627: Dump the content of the index leaf block
ORA-10628: Turn on sanity check for kdiss index skip scan state
ORA-10640: Operation not permitted during SYSTEM tablespace migration
:gn+A'tUc0ORA-10641: Cannot find a rollback segment to bind to
AUI;IR1T+~0]5m0ORA-10642: Found rollback segments in dictionary managed tablespaces51Testing软件测试网 qvn a(K.D:q
ORA-10643: Database should be mounted in restricted mode and Exclusive mode51Testing软件测试网XaH b9y]t,n
ORA-10644: SYSTEM tablespace cannot be default temporary tablespace
)]D*eb'|i0ORA-10645: Recursive Extension in SYSTEM tablespace during migration
1SC} S1X9OTb0ORA-10646: Too many recursive extensions during SYSTEM tablespace migration
9S}2j1D'R$R0ORA-10647: Tablespace other than SYSTEM,, not found in read only mode
_~&d/Kv;SU0ORA-10650: disable cache-callback optimisation
(E2}W zh E0ORA-10651: incorrect file number block number specified
%G1u"TVS/o/~*t8U0gR0ORA-10666: Do not get database enqueue name
lR/Q[[9K q0ORA-10667: Cause sppst to check for valid process ids
ORA-10690: Set shadow process core file dump type (Unix only)
ORA-10691: Set background process core file type (Unix only)
U!c#ADw0ORA-10700: Alter access violation exception handler51Testing软件测试网5N!wfOTp
ORA-10701: Dump direct loader index keys
T_z9L o ?M0ORA-10702: Enable histogram data generation
)yF'Z/b`0ORA-10703: Simulate process death during enqueue get51Testing软件测试网xX9f%JVv
ORA-10704: Print out information about what enqueues are being obtained51Testing软件测试网7m L7q%Zy P
ORA-10705: Print Out Tracing information for every I/O done by ODSs
9}z Tx"jO9C9zC wf0ORA-10706: Print out information about global enqueue manipulation51Testing软件测试网D6w~L-d2dW
ORA-10707: Simulate process death for instance registration
h:Xl`e&_k0ORA-10708: print out trace information from the RAC buffer cache51Testing软件测试网"\ RD?!g q
ORA-10709: enable parallel instances in create index by default
p p7nWL y2Ga0ORA-10710: trace bitmap index access
]6d"T,_R*cfJ0ORA-10711: trace bitmap index merge
SwgI(a/f8t(S5n8p0ORA-10712: trace bitmap index or
'X'vwM'r,m9sVX0ORA-10713: trace bitmap index and51Testing软件测试网 JaX0ze
ORA-10714: trace bitmap index minus
ORA-10715: trace bitmap index conversion to rowids
ORA-10716: trace bitmap index compress/decompress51Testing软件测试网q u.a Dv8Cy0X
ORA-10717: trace bitmap index compaction trace for index creation51Testing软件测试网lmVC5tC.k
ORA-10718: event to disable automatic compaction after index creation
%[6DQ;]3A.c0ORA-10719: trace bitmap index dml
ORA-10720: trace db scheduling
|0b\b(S4aB0ORA-10721: Internal testing - temp table transformation51Testing软件测试网6Q+Q1i$@4] vC8W
ORA-10722: set parameters for CPU frequency calculation (debug)
ORA-10723: Internal testing - release buffer for buffer cache shrink51Testing软件测试网{sYa&rYJ
ORA-10724: trace cross-instance broadcast51Testing软件测试网(t,BD3]&\y-U3A
ORA-10730: trace row level security policy predicates
z/c&mfn;AZ0ORA-10731: dump SQL for CURSOR expressions
z0Q:T9@8^w)d0ORA-10740: disables fix for bug 598861
;I1zi`cLL0ORA-10750: test rollback segment blksize guessing for index array insert51Testing软件测试网5D"efU#y|v
ORA-10800: disable Smart Disk scan51Testing软件测试网-W{LP[^h/Q
ORA-10801: enable Smart Disk trace
.~%Y$H7bh*z4`0ORA-10802: reserved for Smart Disk
ORA-10803: write timing statistics on cluster database recovery scan
[`:}#^1vic0U0ORA-10804: reserved for ksxb
(Ei"n-z/c/R0ORA-10806: Switch to 7.3 mode when detaching sessions
]#]&c"RN/r5@`/|q#F0ORA-10807: Disable user id check when switching to a global transaction
qcfn+z1?1Pq0ORA-10810: Trace snapshot too old51Testing软件测试网6[$i'Sd(i
ORA-10811: Trace block cleanouts
3N8^1r Us3j e0ORA-10812: Trace Consistent Reads
f1i?[#w8v#v0ORA-10826: enable upgrade/downgrade error message trace
$BZm T0`6M\0ORA-10827: database must be opened with MIGRATE option
a?_;__1g2|0ORA-10830: Trace group by sort row source
Tf'SPq[0ORA-10831: Trace group by rollup row source
qr!l%n&_Xl1a pqT0ORA-10841: Default un-inintialized charact set form. to SQLCS_IMPLICIT51Testing软件测试网D;l5l9} C;{Jg
ORA-10842: Event for OCI Tracing and Statistics Info
Ji6v#L*\i0ORA-10850: Enable time manager tracing
I0t JT3@ sd't0ORA-10851: Allow Drop command to drop queue tables
VM9v3L-W2z5[N7D0ORA-10852: Enable tracing for Enqueue Dequeue Operations
]F1a$e@dd\L0ORA-10853: event for AQ statistics latch cleanup testing
3j\7J4LK_Og0ORA-10856: Disable AQ propagator from using streaming
ORA-10857: Force AQ propagator to use two-phase commit
ORA-10858: Crash the AQ propagator at different stages of commit51Testing软件测试网9MV)u)N(m
ORA-10859: Disable updates of message retry count51Testing软件测试网T-s)\:xh4m
ORA-10860: event for AQ admin disable new name parser51Testing软件测试网4B;zxN2nb
ORA-10861: disable storing extended message properties
*ld1@3yQ5TtNx0ORA-10862: resolve default queue owner to current user in enqueue/dequeue
3d)I1Mq!@;mg @O{N0ORA-10871: dump file open/close timestamp during media recovery
\Y;W:~!L/n&pt0ORA-10900: extent manager fault insertion event #
u!wr+wXup q0ORA-10902: disable seghdr conversion for ro operation
G"oWH.?&vj(ld|0ORA-10903: Force tablespaces to become locally managed51Testing软件测试网 U:W{;}0tjmf
ORA-10904: Allow locally managed tablespaces to have user allocation
#GeHuv^5G^0ORA-10905: Do cache verification (kcbcxx) on extent allocation51Testing软件测试网3V#s+i(`*{
ORA-10906: Unable to extend segment after insert direct load
.q%D-^m&` ]-@%k0ORA-10907: Trace extent management events
6wV'y:ZA0_0ORA-10908: Trace temp tablespace events
aVF(q/h'g@"WC~\0ORA-10909: Trace free list events51Testing软件测试网0c?"V0v Ro4X
ORA-10910: inject corner case events into the RAC buffer cache51Testing软件测试网%S_6J,L,^2](K
ORA-10911: Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle Support
/V~Bd!H)Tx)L0ORA-10912: Used to perform. admin operations on locally managed SYSTEM tablespace
Y"@EJpP3M.L0ORA-10913: Create locally managed database if compatible > 920 by default
ORA-10924: import storage parse error ignore event
]I[uD0ORA-10925: trace name context forever
ORA-10926: trace name context forever
ORA-10927: trace name context forever
.v9K%D2?+[iVb0hO0ORA-10928: trace name context forever
Ut/D1J\H$v{0ORA-10929: trace name context forever
"l%x2q&K$\:K(?y I m0ORA-10930: trace name context forever51Testing软件测试网?)w6Y'Rvf0H
ORA-10931: trace name context forever
ORA-10932: trace name context forever
ORA-10933: trace name context forever
)B!PEa X3B1q0ORA-10934: Reserved. Used only in version 7.x.51Testing软件测试网]9SY c`2n
ORA-10935: Reserved. Used only in version 7.x.
nY+T+{#sB*d0ORA-10936: trace name context forever
"D!J{yzs Dq/KL0ORA-10937: trace name context forever51Testing软件测试网W*t:C|#D-CT3k
ORA-10938: trace name context forever
U9yU7vZ~/[0ORA-10939: trace name context forever
#uZ Ry$@%d ]!l e0ORA-10940: trace name context forever
)t*h8v{!`:I0ORA-10941: trace name context forever51Testing软件测试网0}ob"I e%J ue
ORA-10943: trace name context forever51Testing软件测试网;`4IK9TP&DV
ORA-10944: trace name context forever
ORA-10945: trace name context forever
Ax9~.EJd0ORA-10970: backout event for bug 2133357
V9W5k8p7m wPcAv0ORA-10975: trace execution of parallel propagation51Testing软件测试网.KB M&J1w,w(X
ORA-10976: internal package related tracing
p%z t;P8E8SP0ORA-10977: trace event for RepAPI51Testing软件测试网_lo,}J7L@
ORA-10979: trace flags for join index implementation
&\9},|([F4F6X0ORA-10980: prevent sharing of parsed query during Materialized View query generation
S8c(C'|Mut0ORA-10981: dscn computation-related event in replication
G9~#w%N[PEytd0ORA-10982: event to turn off CDC-format MV Logs51Testing软件测试网RZ:@TX M;O
ORA-10983: event to enable Create_Change_Table debugging
a8u9pT K Y0ORA-10984: subquery materialized view-related event51Testing软件测试网/O{$|A0j,V
ORA-10985: event for NULL refresh of materialized views51Testing软件测试网4m B{!c W
ORA-10986: donot use HASH_AJ in refresh
v(b%eg ccIh2r0ORA-10987: event for the support of caching table with object feature
w't;` c Naw'J?0ORA-10988: event to get exclusive lock during materialized view refresh in IAS
v1t-ra+c/]V0ORA-10989: event to internally create statistics MV
;z1EP2m)lS$GvMG0ORA-10996: event to make a process hold a latch in ksu
,d5g_cer6l k$U*X0ORA-10999: do not get database enqueue name51Testing软件测试网8N A4Uj_P"~