Re: 8.1.5i: hints causes a internal error

We traced a problem like this back to partitions. If the table was partitioned, (and if the wind was blowing in the wrong direction) then we would get the Ora-600 error. We could take the same query and run it on a non-partitioned table and it would not crash.

Because we are in a star schema environment, we had to make the bitmap indexes work. We are now busy removing partitions from all of the tables. Things are now much more stable.

Randy Eash

Robert Fenk wrote:

> 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 Thu Aug 03 2000 - 00:00:00 CDT