Oracle 11g ora-00979 bug handling

Oracle 11g ora-00979 bug processing migrate oracle 10g Report library to oracle 11g existing Stored Procedure compilation times ora-00979 error, determined to be group by followed by the cursor cannot be used, later I found a bug of 11g with metlink query: ORA-979 bugs on 11.2.0.1 [ID 1085766.1] modification time 23-MAR-2012 type FAQ status PUBLISHED Applies: oracle Server-Enterprise Edition-Version: 11.2.0.1.0 to 11.2.0.1.0-Release: 11.2 to 11.2 Information in this document applies to any platform. purposeThe purpose of this document Is to have a complete list of ORA-979 bugs with workarounds and their current status on 11.2 Questions and Answers1. BUG 9411496-ORA-979 ON 'Union all pushed predicate '(Query Optimizer bug) --- Symptoms --- When the query has group by and order by, and they use the same attribute and the cursor_sharing is set to a value <> EXACT, the queries fail with ORA-979.The call stack from the event 979 erro Rstack is :... qcuErroer qcuErroep erroep qecgoc qecoby qecpqbcheck qecdrv ???#=kkkqdrv =apadrv opitca kkksfulltypecheck rpiswu2 =kkksfbc... --- Changes --- Following the upgrade to 11. 2. --- Cause --- Bug 9411496-ORA-979 ON 'Union all pushed predicate '--- Solution --- The workarounds are: 1. "_ fix_control" = "5520732: OFF "OR2. optimizer_features_enable = '11. 1.0.7'or3. "_ optimizer_push_pred_cost_based" = falseOR4. "_ optimizer_cost_based_transformation" = offThe bug is fixed and there are patches for some platforms. if the workarounds are not acceptable, a one-off patch for the bug shocould be requested from Oracle Support. 2. bug 9478304 "loop failing with ORA-00979 not a group by expression" (Query Optimizer bug) --- Symptoms --- group by/order by in PL/SQL cursor loops fails with ORA-979. 1, 3, and 4 are implicit parameters. The database must be restarted after modification. Only 2 can be modified online. After modification, the database is compiled and the problem is solved.