oracle 11g ora-00979 bug的处理
来源:互联网 发布:ae软件的功能 编辑:程序博客网 时间:2024/05/18 14:28
将oracle 10g报表库迁移到 oracle 11g上发现有个存储过程编译时报ora-00979错误,经确定是group by 后面加的游标不能使用,后来用metlink查询发现是11g的一个bug:
ORA-979 bugs on 11.2.0.1 [ID 1085766.1]
修改时间 23-MAR-2012 类型 FAQ 状态 PUBLISHED
Applies to:
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.
Purpose
The 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 Answers
1. 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 errorstack is:
... qcuErroer qcuErroep erroep qecgoc qecoby qecpqbcheck qecdrv kkqcttcalo kkqctdrvJPPD kkqjpdctr qksqbApplyToQbc kkqctdrvTD kkqjpddrv kkqdrv kkqctdrvIT apadrv opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc ...
--- 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"
OR
2. optimizer_features_enable = '11.1.0.7'
OR
3."_optimizer_push_pred_cost_based" = false
OR
4."_optimizer_cost_based_transformation" = off
The bug is fixed and there are patches for some platforms. If the workarounds are not acceptable, a one-off patch for the bug should 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,4都是隐含参数,修改必须重启数据库,只有2可以在线修改,修改后编译通过,问题解决。
- oracle 11g ora-00979 bug的处理
- oracle 11g的ORA-28001 处理
- Oracle 11g参数修改错误导致数据库无法启动的处理方法.[ORA-01034,ORA-27101,ORA-00824]
- oracle 10g的long类型处理bug
- oracle 11g的一个bug
- 关于oracle 11g导出数据时 报 ORA 1455错误的处理
- Oracle 11g 参数修改错误导致数据库无法启动的处理方法.[ORA-01034,ORA-27101]
- oracle 11g,ora-00257,ora-09945
- oracle 11g ora-00972
- Oracle 11g RAC 补丁升级时报ORA-01565: error in identifying spfileprod.ora 错误处理
- oracle 11g ORA-12514错误,我的解决办法
- Oracle 11g ORA-00845 在linux 下的解决方案
- Oracle 11g下 ORA-01417的解决办法
- Oracle 11g RAC环境下的ORA - 19606问题
- Oracle 11g ORA-28002:口令将过期的解决方法
- 关于12c升级11g catalog bug的处理
- Oracle 11g R2 补丁修复的bug list
- oracle 11g dblink 查询的bug --10053用处
- hdu 4215——Number Theory
- 什么是PMU(PMIC)
- hdu 1010 解题报告 ----Tempter of the Bone
- 各版本OS安装wpscan
- CMake常见变量——Project和CMake相关信息
- oracle 11g ora-00979 bug的处理
- 关于ActionContext.getContext()的用法心得
- c/c++笔试题、面试题(一)(不断更新中)
- 【C/C++】C/C++基本数据类型
- generate ext4 file
- bash: ./java: cannot execute binary file 问题
- 关于Struts2中if标签的一些心得
- 自定义UiTableViewCell高度
- 分组ListView使用技巧