Hi,
We have migrated our database from 10g to 11g recently and then onwards we were started getting the ORA-00600: internal error code, arguments: [kcblin_3], [103], [253952], [8192], [32769], [312], [528], [], [], [], [], [].
When we contacted oracle they have given a parameter "_gby_hash_aggregation_enabled" = false to set at session level to fix this issue and it has worked out. We have noticed we are already using a hint /*NO_USE_HASH_AGGREGATION */ in our select query but for some reason it didn't worked out in 11g and started giving the ORA error.
I am currently looking for a hint in 11g to replace the old hint /*NO_USE_HASH_AGGREGATION */ and came across a hint name NO_USE_HASH_GBY_PUSHDOWN but didn't able to find any notes related to this.
Please let me know whether any alternate hints are present for the one we are having issues.
Regards,
VJ