Archive

Posts Tagged ‘ORA-0600’

ORA-0600 after migrating to oracle 10.2.0.4 (bug 4730372)

December 13, 2010 Leave a comment

I’ve recently migrated an application from oracle 9.2.0.8 to 10.2.0.4 and now I’m getting an ORA-0600 in the alert log:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kkqtfixfro:1: No outer-joined ta], [], [], [], [], [], [], []

The SQL statement (intentionally obfuscated) is this:

SELECT
 (SELECT mcl
 FROM mce, mmo
 WHERE fcn = cci(+)
 AND ccn = mcn(+)
 ) AS mcl,
 fcn,
 pct,
 (SELECT COUNT(*)
 FROM mii
 WHERE iia = 'S'
 AND TO_CHAR(idi,'YYYYMMDD') >= TO_CHAR(:1,'YYYYMMDD')
 AND TO_CHAR(idi,'YYYYMMDD') <= TO_CHAR(:2,'YYYYMMDD')
 ) AS tl,
 COUNT(*) AS COUNT
FROM
 (SELECT pct,
 fcn,
 ici
 FROM mii,
 mft,
 mas,
 mpa,
 mmo
 WHERE ici = acd
 AND ici = fcd
 AND mci = pct
 AND mgg = 'S'
 AND iia = 'S'
 AND TO_CHAR(idi,'YYYYMMDD') >= TO_CHAR(:3,'YYYYMMDD')
 AND TO_CHAR(idi,'YYYYMMDD') <= TO_CHAR(:4,'YYYYMMDD')
 AND acp = pci
 AND ava = 'S'
 AND ars = '+'
 GROUP BY pct,
 fcn,
 ici
 ORDER BY pct,
 fcn,
 ici
 )
WHERE 0 = 1
GROUP BY fcn,
 pct
ORDER BY mcl,
 fcn,
 pct;

In Metalink I’ve found this error is similar to bug 4730372.

As I cannot migrate to oracle 11.2.0.1 yet, I tried in my development environment the workaround proposed:

SQL> alter session set "_simple_view_merging" = false;

As this workaround worked for me, I altered the system instead, because our users cannot issue alter session commands in their applications:

SQL> alter system set "_simple_view_merging" = false scope=both;

As I’ve red in other posts, this is a bug of oracle 10, as it worked fine in oracle 9. See a similar bug with this parameter in http://hemantoracledba.blogspot.com/2008/05/ever-heard-of-simpleviewmerging.html

Advertisements
Categories: bug, oracle Tags: