ORA-00600: internal error code, arguments: [32695], [hash aggregation can't be done],
We are running Oracle database 10.2.0.4 and have encounter bug 6471770. We set the parameter "_gby_hash_aggregation_enabled" to FALSE as follows:
alter system set "_gby_hash_aggregation_enabled"=false scope=both;
as the work around and did not recycle the instance. We encountered the ORA-00600 [32695] [hash aggregation can't be done] error again. Does the database need to be recycled in order for the parameter to take effect?