在撤销事务的时候碰到了ORA-600错误,错误函数ktftb_backout_xids_3。
这个bug是由于指定参数有问题造成的。
SQL> DECLARE
2 V_XID XID_ARRAY;
3 BEGIN
4 V_XID := SYS.XID_ARRAY('0002001C00000374');
5 DBMS_FLASHBACK.TRANSACTION_BACKOUT(2, V_XID);
6 END;
7 /
DECLARE
*第 1 行出现错误:
ORA-00600: 内部错误代码, 参数: [ktftb_backout_xids_3], [1], [0], [], [], [], [], []
ORA-06512: 在 "SYS.DBMS_FLASHBACK", line 37
ORA-06512: 在 "SYS.DBMS_FLASHBACK", line 70
ORA-06512: 在 line 5
后台错误信息为:
Errors in file /data/oracle/diag/rdbms/test11g/test11g/trace/test11g_ora_15095.trc (incident=6154):
ORA-00600: 内部错误代码, 参数: [ktftb_backout_xids_3], [1], [0], [], [], [], [], []
Incident details in: /data/oracle/diag/rdbms/test11g/test11g/incident/incdir_6154/test11g_ora_15095_i6154.trc
从trace文件中查看:
Dump file /data/oracle/diag/rdbms/test11g/test11g/incident/incdir_6154/test11g_ora_15095_i6154.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /data/oracle/product/11.1
System name: SunOS
Node name: netdb1
Release: 5.10
Version: Generic_118833-33
Machine: sun4u
Instance name: test11g
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 15095, image: oracle@netdb1
*** 2007-12-19 13:28:44.299
*** SESSION ID:(146.29822) 2007-12-19 13:28:44.299
*** CLIENT ID:() 2007-12-19 13:28:44.299
*** SERVICE NAME:(test11g.netdb) 2007-12-19 13:28:44.299
*** MODULE NAME:(sqlplusw.exe) 2007-12-19 13:28:44.299
*** ACTION NAME:() 2007-12-19 13:28:44.299
Dump continued from file: /data/oracle/diag/rdbms/test11g/test11g/trace/test11g_ora_15095.trc
ORA-00600: 内部错误代码, 参数: [ktftb_backout_xids_3], [1], [0], [], [], [], [], []
========= Dump for incident 6154 (ORA 600 [ktftb_backout_xids_3]) ========
*** 2007-12-19 13:28:44.310
----- Current SQL Statement for this session (sql_id=79q2xt2hapu3m) -----
DECLARE
V_XID XID_ARRAY;
BEGIN
V_XID := SYS.XID_ARRAY('0002001C00000374');
DBMS_FLASHBACK.TRANSACTION_BACKOUT(2, V_XID);
END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
www.ixdba.net
object line object
handle number name
3950e0648 37 package body SYS.DBMS_FLASHBACK
3950e0648 70 package body SYS.DBMS_FLASHBACK
441b274b8 5 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst1() 96 CALL skdstdst() FFFFFFFF7FFF1490 ?
000000000 ?
FFFFFFFF7FFC9018 ?
000000000 ?
FFFFFFFF7FFC9018 ?
1095E7F10 ?
ksedst() 56 CALL ksedst1() 000000000 ? 000000001 ?