8.1.5i: hints causes a internal error

From: Robert Fenk <Robert.Fenk_at_gmx.de>
Date: 2000/08/02
Message-ID: <wyw7l9zqvu6.fsf@sunwibas14.forwiss.tu-muenchen.de>#1/1

I have a relation with 14 attributes and 3 bitmap indexes on the relation. When doing a select oracle thinks it has to perform a full table scan, so I have a hint for the bitmaps.

But if I trace the session I get an internal error. Without hints there is no error and with a "set autotrace on" in sqlplus neither, but this is no solution for my OCI-program. Further more some queries run without error.

So is this a known bug which is fixed in 8.1.6i or is there some workaround, e.g. a way to force the optimizer to use the bitmaps with out a hint (optimizer_goal = rule does not solve this)?

Any ideas?

Thanks,
Robert

Example:

ALTER SESSION SET SQL_TRACE = TRUE; SQL> SELECT /* rtest: test.bm-4 */

  2          /*+ INDEX(gfkc_PRODUCT_CS gfkc_SEGMENT_CS gfkc_TIME_CS ) */ 
  3          * FROM gfkc WHERE 
  4          PRODUCT_CS BETWEEN 102760448 AND 102760919 AND 
  5          SEGMENT_CS BETWEEN 0 AND 294972 AND 
  6          TIME_CS = 9;
        * FROM gfkc WHERE
               *

ERROR at line 3:
ORA-00600: internal error code, arguments: [20056], [1], [29914326], [0], [29913517], [23], [], []

So far my Oracle experience is quite annoying ... ;(

Received on Wed Aug 02 2000 - 00:00:00 CDT