Tag Archives: insert into select

ORA-600(ktrgcm_3)错误

Posted on 2013/07/10 by yangtingkun

客户10.2.0.5 RAC数据库出现ORA-600[ktrgcm_3]错误。 错误信息如下： Sun Jul 07 01:06:00 EAT 2013 Errors IN file /oracle/admin/orcl/udump/orcl1_ora_28947.trc: ORA-00600: internal error code, arguments: [ktrgcm_3], [], [], [], [], [], [], []Sun Jul 07 01:06:00 EAT 2013 Errors in file /oracle/admin/orcl/udump/orcl1_ora_28947.trc: ORA-00600: internal error code, arguments: … 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