jimmy

4 积分	0 好友	2 主题

发消息

[常规总体性能调优] AIX 11.2.0.1.0 ora-600[kghsskins1],

1^#

发表于 2013-6-21 18:56:14 | 查看: 4571| 回复: 6

在检查系统时，遇到一则600.查了下google，说是Bug 6439000或Bug 7005209。
希望刘大能给确诊一下并给出解决思路谢谢

log.rar

2.09 MB, 下载次数: 785

日志

已有 1 人评分	威望	理由
Maclean Liu(刘相兵	-10	本贴标题取名不规范除了ORA-600 之外无任.

总评分: 威望 -10 查看全部评分

分享0

收藏0 回复只看该作者道具举报

psufnxk2000

2^#

发表于 2013-6-21 20:46:37

这么牛B的sql , 有可能是 ID 12964245.8

回复只看该作者道具举报

jimmy

3^#

发表于 2013-6-22 09:46:28

psufnxk2000 发表于 2013-6-21 20:46
这么牛B的sql , 有可能是 ID 12964245.8

上不了metalink！！

回复只看该作者道具举报

harryzhang

4^#

发表于 2013-6-22 10:52:37

Click to add to Favorites Bug 12964245 - ORA-600 [kghsskins1] from extremely large query [ID 12964245.8] To BottomTo Bottom
Modified:27-Feb-2013Type:PATCHStatus:PUBLISHEDPriority:3
There are no commentsComments (0) Rate this document Email link to this document Open document in new window Printable Page

Bug 12964245  ORA-600 [kghsskins1] from extremely large query

This note gives a brief overview of bug 12964245.
The content was last updated on: 26-FEB-2013
Click here for details of each of the sections below.
Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected (Not specified)
Versions confirmed as being affected

      11.2.0.3
      10.2.0.5

Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

      12.1 (Future Release)
      11.2.0.4 (Future Patch Set)

Symptoms:

Related To:

Internal Error May Occur (ORA-600)
ORA-600 [kghsskins1]

Optimizer

Description

ORA-600 [kghsskins1] from extremely large query

Rediscovery Notes:
   If you hit ora-600 [kghsskins1] while executing any large query.
   you may have hit this bug.

Workaround
   None

回复只看该作者道具举报

Maclean Liu(刘相兵

5^#

发表于 2013-6-22 15:27:23

1、本贴标题取名不规范除了ORA-600 之外无任何实质意义已修改
警告一次

回复只看该作者道具举报

Maclean Liu(刘相兵

6^#

发表于 2013-6-22 15:29:45

11.2.0.1 +上不了Metalink => 使用盗版Oracle 再次警告

回复只看该作者道具举报

Maclean Liu(刘相兵

7^#

发表于 2013-6-22 15:36:43

11.2.0.1 +AIX 11.2.0.1 是11.2的base release ，装这个版本要么是不懂Oracle 要么是系统不重要

----- Current SQL Statement for this session (sql_id=ghm6rh8rdz04b) -----
select distinct clb.lbi_id,clb.LBI_PACT_STARTEND_DATE,clb.lbi_demand_num,

7005209 OERI:kghsskins1 with > 32000 predicates

你的SQL中使用 where xx or xx的谓词判断超过了32000个会触发该问题，

解决方案是改写SQL，即便打了补丁这样写出来的SQL 运行还是很慢的。

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册