Tag Archives: BIND VARIABLE

单个分区索引失效导致绑定变量查询无法使用索引

Posted on 2012/06/27 by yangtingkun

一个客户碰到的问题，由于分区维护操作，导致个别分区对应的索引处于UNUSABLE状态，最终导致基于绑定变量的查询无法利用索引。 通过一个具体的例子来说明这个问题： SQL> CREATE TABLE t_part 2 (id NUMBER, 3 name varchar2(30)) 4 partition BY range (id) 5 (partition p1 VALUES less than (10), 6 partition p2 VALUES less than (20), 7 partition pmax VALUES less than (maxvalue)); TABLE created. … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

ORA-600(opixrb-4)错误

Posted on 2011/12/28 by yangtingkun

客户环境出现ORA-600(opixrb-4)错误。 错误信息为： Fri Oct 28 05:50:47 2011 Errors IN file /oracle9/app/admin/bill/udump/bill1_ora_11075632.trc: ORA-00600: internal error code, arguments: [opixrb-4], [1036], [ORA-01036: illegal variable name/NUMBER], [], [], [], [], [] Fri Oct 28 05:56:44 2011 Errors IN file /oracle9/app/admin/bill/udump/bill1_ora_11075632.trc: ORA-00600: internal error code, … Continue reading →

Posted in BUG | Tagged , , , , , , | Leave a comment