Category Archives: ORACLE

所有Oracle技术文章

ORA-600(17271)错误

Posted on 2011/12/07 by yangtingkun

告警日志中发现了ORA-600(17271)错误。 详细错误信息为： Fri Mar 6 17:15:37 2009 Errors IN file /home/oracle/admin/ARIC/udump/aric_ora_28118.trc: ORA-00600: internal error code, arguments: [17271], [instantiation SPACE leak], [], [], [], [], [], [] ORA-03135: connection lost contactFri Mar 6 17:15:37 2009 Errors in file /home/oracle/admin/ARIC/udump/aric_ora_28118.trc: ORA-00600: internal … Continue reading →

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

ORA-7445(qerixGetKey)错误

Posted on 2011/12/06 by yangtingkun

执行并行查询时碰到的问题。 错误信息如下： Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p001_8093.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [21] [] [] [] Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p000_8091.trc: ORA-07445: exception encountered: core dump … Continue reading →

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

OPAQUE_TRANSFORM提示的产生

Posted on 2011/12/05 by yangtingkun

最近经常在AWR中看到带有OPAQUE_TRANSFORM提示的SQL语句，根据分析可以确认执行这个SQL的语句是通过数据库链连接到本地，但是测试时发现，普通的数据库链连接并不会导致这个提示的产生。 于是做了一个简单的例子： -bash-3.2$ sqlplus test/test SQL*Plus: Release 10.2.0.5.0 – Production ON Mon DEC 5 15:05:09 2011 Copyright (c) 1982, 2010, Oracle. ALL Rights Reserved. Connected TO: Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 – Production WITH the Partitioning, OLAP, DATA … Continue reading →

Posted in ORACLE | Tagged , , | Leave a comment

索引重建的数据源（二）

Posted on 2011/12/04 by yangtingkun

对这个问题有了进一步的认识。 索引重建的数据源：http://yangtingkun.itpub.net/post/468/457384 上一篇文章测试的结果认为DDL也是基于CBO的，但是今天发现问题并非如此。Oracle在评估REBUILD索引时并不是根据统计信息，而是根据数据字典中非索引字段的长度： SQL> CREATE TABLE t_rebuild (id NUMBER, flag CHAR(1)); TABLE created. SQL> INSERT INTO t_rebuild SELECT rownum, ‘a’ FROM dba_objects; 15695 ROWS created. SQL> commit; Commit complete. SQL> CREATE INDEX ind_t_rebuild_id ON t_rebuild(id); INDEX created. SQL> EXPLAIN plan … Continue reading →

Posted in ORACLE | Tagged , | Leave a comment

ORA-600(qerfxFetch_01)错误

Posted on 2011/12/03 by yangtingkun

在客户的9201数据库中，发现这个错误。 错误信息为： Wed Jul 29 09:23:32 2009 Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []Wed Jul 29 09:23:32 2009 Errors in file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

11g收集统计信息引发wri$_optstat_histhead_history表的删除

Posted on 2011/12/02 by yangtingkun

在查看一个客户11.2.0.2的AWR报告时，发现了这个问题。 在SQL ORDER BY ELASPED TIME表中，前两项的结果如下： Elapsed Time (s) Executions %Total %CPU %IO SQL Id SQL Module SQL Text 10,752.79 0 25.86 98.20 7.49 4sff1qphjvbwn SQL*Plus BEGIN dbms_stats.gather_table_… 10,752.75 13 25.86 98.20 7.49 bqn2h1xrmhmht delete from sys.wri$_optstat_h… 可以看到，这2两个语句在花费时间，占用CPU以及IO的百分比上惊人的一致，这绝对不是一个偶然的事件。 第一个SQL是收集表的统计信息，显然这是在SQLPLUS里面执行的操作，其执行次数是0，说明在采样时间内，这个操作还没有完成。根据Elspsed Time估算，这个SQL已经运行了3个小时。 … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

运行脚本diagcollection.pl报错

Posted on 2011/11/29 by yangtingkun

Oracle的RAC提供了diagcollection.pl脚本，用来收集CLUSTER和数据库的脚本。不过在客户环境中执行这个脚本报错。 详细错误信息为： [root@smsdbrac1 ora_test]# $ORA_CRS_HOME/bin/diagcollection.pl -crshome=$ORA_CRS_HOME -collect Production Copyright 2004, 2005, Oracle. ALL rights reserved Cluster Ready Services (CRS) diagnostic collection tool The following CRS diagnostic archives will be created IN the LOCAL directory. crsData_smsdbrac1.tar.gz -> logs,traces AND cores FROM … Continue reading →

Posted in BUG | Tagged , | Leave a comment

告警日志出现skgpspawn failed category 27142错误

Posted on 2011/11/28 by yangtingkun

客户的数据库告警日志出现skgpspawn failed信息。 详细错误信息如下： Mon Nov 28 07:59:59 2011 skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn5 skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3 skgpspawn failed:category = 27142, depinfo = … Continue reading →

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

ORA-600(5351)错误

Posted on 2011/11/26 by yangtingkun

在告警日志中发现了ORA-600(5351)错误，同时出现大量的There are 3 memory allocation errors for object-level stat错误。 详细的错误信息为： Tue Jun 22 12:00:09 2010 Thread 1 advanced TO log SEQUENCE 1522 CURRENT log# 3 seq# 1522 mem# 0: /dev/rredo03 There are 6 memory allocation errors FOR object-level stat IN … Continue reading →

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

ORA-7445($cold_qerfxArrayMaxSize)错误

Posted on 2011/11/25 by yangtingkun

客户的数据库告警日志中出现这个错误。 详细错误信息如下： Wed Oct 26 15:38:14 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address NOT mapped TO object] [0x000003058] [] [] Wed Oct 26 15:38:27 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-00081: address range [0x6000000000127430, 0x6000000000127434) … Continue reading →

Posted in BUG | Tagged , , | Leave a comment