Problem:
You are getting ORA-00600: internal error code, arguments: [qkaffsindex5] in Oracle 12.1.0.1 or higher.
This seems like a bug in 12c and it happens because your query is using a function based index and DESC.
Solution:
-- Downgrade the optimizer from 12.1.0.1 to 11.2.0.3:
Sql> alter system set optimizer_features_enable = '11.2.0.3' scope=both;
|
or
-- You can also try to use this workaround:
Sql> alter session set "_fast_full_scan_enabled" = false;
|
I hope this helps.
Please feel free to leave your questions or suggest improvements to this section.
No comments:
Post a Comment