According to Oracle Support note 336315.1, this ORA-600 error is a known issue (bug 4335559) affecting some versions of 9i and 10g. It is a bug in the cost-based optimizer's initial join order routine. The note mentions a simple known workaround that you can implement either in one session, or throughout the whole Oracle instance. To implement … [Read more...]