internal error code [message #438653] |
Mon, 11 January 2010 07:44  |
ayush_anand
Messages: 417 Registered: November 2008
|
Senior Member |
|
|
I am getting this error
Any ideas
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [],
[], []
ORA-06512: at "XXMITG.XX_REPORTS_PKG", line 2886
ORA-06512: at line 2
|
|
|
|
|
Re: internal error code [message #438663 is a reply to message #438655] |
Mon, 11 January 2010 08:55   |
ayush_anand
Messages: 417 Registered: November 2008
|
Senior Member |
|
|
The query is a connect by query and
http://forums.oracle.com/forums/thread.jspa?threadID=676727
thread helped me
the second action is working fine for me
SQL> set linesize 2000
SQL> @ r1
WITH x AS (
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [], [], []
SQL> alter session set "_optimizer_connect_by_cost_based"=false;
Session altered.
SQL> @ r1
DEPL_PACKAGE_NUMBER DEPL_PACKAGE_LINE DEPL_PACKAGE_SEQ OBJECT_REVISION
------------------- ----------------- ---------------- ---------------------------------------------
44748 86448 1 126422
SQL>
|
|
|
|
|
|
|
|
Re: internal error code [message #439208 is a reply to message #438765] |
Thu, 14 January 2010 22:57  |
ayush_anand
Messages: 417 Registered: November 2008
|
Senior Member |
|
|
SQL> select banner from v$version
2 /
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> select 1 from
2 sys.table_privileges tp, user_objects uo
3 where tp.grantee in
4 (select 1 from
5 sys.dba_role_privs connect by prior granted_role=grantee start with
6 grantee ='scott')
7 /
sys.table_privileges tp, user_objects uo
*
ERROR at line 2:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [],
[], []
Oracle has a patch for this bug but only for Solaris 64-bit platform(for 10.2.0.4). Also Oracle says that this bug is fixed in 10.2.0.5 & starting from 11.1.0.7. We have got 10.2.0.4 version.We can update our database to 10.2.0.5 version (anyway we should do this some when) or use workaround provided by Oracle:
1. Use a /*+no_unnest*/ hint, but this may have perfomance implications.
2. alter session set "_optimizer_connect_by_cost_based"=false;
The second workaround is preferable because the first one may have performance implications.
[Updated on: Thu, 14 January 2010 23:10] Report message to a moderator
|
|
|