-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: index
ORA-600(6033)错误
客户10.2.0.4 RAC for Linux X64环境,告警日志出现ORA-600(6033)错误。 详细错误信息为: /opt/app/oracle/admin/orcl/udump/orcl1_ora_25075.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production WITH the Partitioning, REAL Application Clusters, OLAP, DATA Mining AND REAL Application Testing options ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1 System name: Linux Node name: hb1 … Continue reading
ORA-600(kauxs_do_jou:3)错误
客户9.2.0.6数据库出现ORA-600(kauxs_do_jou:3)错误。 错误信息为: Wed Mar 28 22:44:48 2012 Errors IN file /DATA/oracle/admin/orcl/udump/orcl_ora_19724.trc: ORA-00600: 内部错误代码,参数: [kauxs_do_jou:3], [68], [], [], [], [], [], [] Wed Mar 28 22:46:38 2012 Errors IN file /DATA/oracle/admin/orcl/udump/orcl_ora_19856.trc: ORA-00600: 内部错误代码,参数: [kauxs_do_jou:3], [68], [], [], [], [], [], [] … Continue reading
单个分区索引失效导致绑定变量查询无法使用索引
一个客户碰到的问题,由于分区维护操作,导致个别分区对应的索引处于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
ORA-600(kkdlfjou_1)错误
10.2.0.5 RAC环境出现ORA-600[kkdlfjou_1]错误。 错误信息: Thu Jun 02 10:09:38 EAT 2011 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_17796.trc: ORA-00600: internal error code, arguments: [kkdlfjou_1], [], [], [], [], [], [], [] Thu Jun 02 10:09:40 EAT 2011 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_29452.trc: ORA-00600: 内部错误代码, 参数: [kkdlfjou_1], … Continue reading
ORA-600(qertbFetchByRowID)错误
以前也碰到过这个错误,不过由于无法直接连接数据库,没有办法深入分析。这次虽然同样没有办法连接数据库,但是获取了更详细的信息,基本确定导致问题的原因。 错误信息如下: Wed May 09 10:41:32 2012 Errors IN file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []Wed May 09 10:41:32 2012 Errors in file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], … Continue reading
ORA-600(6002)错误
客户数据库出现ORA-600(6002)错误。 在告警文件中出现大量的错误: Sun Apr 1 16:15:41 2012 Errors IN file /oracle/orcl/udump/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], [] Sun Apr 1 16:16:43 2012 Errors IN file /oracle/orcl/udump/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], … Continue reading
ORA-600(20084)错误
数据库告警日志中出现错误ORA-600(20084)。 错误信息如下: Mon Aug 31 14:56:51 2009 Errors IN file /oracle/admin/oasisdb/udump/oasisdb1_ora_4787.trc: ORA-00600: 内部错误代码, 参数: [20084], [18125507], [60], [18125507], [60], [], [], []Mon Aug 31 14:56:51 2009 Errors in file /oracle/admin/oasisdb/udump/oasisdb1_ora_4787.trc: ORA-00600: 内部错误代码, 参数: [20084], [18125507], [60], [18125507], [60], [], [], … Continue reading
ORA-600(16608)错误
客户10.2.0.4环境出现ORA-600(16608)错误。 详细错误信息如下: Sun DEC 19 11:17:41 2010 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_j005_5937.trc: ORA-00600: internal error code, arguments: [16608], [2], [3], [0x8000002C4FA00DC0], [], [], [], []Sun Dec 19 11:17:41 2010 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_j005_5937.trc: ORA-00600: internal error code, arguments: [16608], [2], [3], … Continue reading
10g新增初始化参数SKIP_UNUSABLE_INDEXES
这个10.1就增加的新特性,是最近才发现的。 公司中的新人问起索引失效对表影响,于是随手做了个例子,才发现10g中已经改变了9i中的默认方式: SQL> CREATE TABLE t_index (id NUMBER, name varchar2(30)); TABLE created. SQL> CREATE INDEX ind_t_id ON t_index(id); INDEX created. SQL> CREATE INDEX ind_t_name ON t_index(name); INDEX created. SQL> INSERT INTO t_index VALUES (1, ‘a’); 1 ROW created. SQL> commit; … Continue reading
外键缺少索引引发的死锁
客户的10.2.0.4 RAC for AIX环境频繁出现ORA-60死锁问题,导致应用程序无法顺利执行。 经过一系列的诊断,发现最终问题是由于外键上没有建立索引所致,由于程序在主子表上删除数据,缺少索引导致行级锁升级为表级锁,最终导致大量的锁等待和死锁。 下面通过一个例子简单模拟一下问题: SQL> CREATE TABLE t_p (id NUMBER PRIMARY KEY, name varchar2(30)); TABLE created. SQL> CREATE TABLE t_f (fid NUMBER, f_name varchar2(30), FOREIGN KEY (fid) REFERENCES t_p); TABLE created. SQL> INSERT INTO t_p VALUES (1, ‘a’); … Continue reading