oracle 10.2.0.3 rac数据库下用sql性能监控的一个bug说明

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:139

oracle 10.2.0.3 rac数据库下用sql监控性能的一个bug说明

数据库环境 oracle 10.2.0.3 rac + aix 5300-06
昨天在客户那数据库巡检时,发现以下错误:
Errors in file /opt/oracle/admin/oa/bdump/oa1_s000_430442.trc
ORA-00600: internal error code, arguments: [kolaslGetLength-1], [], [], [], [], [], [], []
通过 more opt/oracle/admin/oa/bdump/oa1_s000_430442.trc
看到是由于以下sql导致
Select s.inst_id, s.username, s.sid, s.serial#, command, t.value cpu_time, i.physical_reads phy_reads, i.block_gets blk_gets, s.st
atus, s.lockwait, q.sql_fulltext sql_text, s.sql_hash_value
FROM GV$session s, GV$sesstat t, GV$statname n, GV$sess_io i, GV$sqlarea q
WHERE s.username is not null
AND (t.value > :"SYS_B_0" or i.physical_reads > :"SYS_B_1" or i.block_gets > :"SYS_B_2")
AND s.sid = t.sid AND s.inst_id = t.inst_id AND t.statistic# = n.statistic# AND t.inst_id = n.inst_id AND n.name = :"SYS_B_3" AND
s.sid = i.sid AND s.inst_id = i.inst_id AND s.sql_address = q.address AND s.sql_hash_value = q.hash_value AND s.inst_id = q.inst_i
d ORDER BY t.value desc
通过查询metalink 已经确认是oracle 10.2.0.3下的bug,这个是toad工具连接到数据库监控性能时导致的
要解决这个问题,必须升级到oracle 10.2.0.4 或11g
以下是metalink详细解释
Bug 4634662 - OERI:kolaslGetLength-1 from V$SQL in RAC
文档 ID: 4634662.8 类型: PATCH
上次修订日期: 12-DEC-2008 状态: PUBLISHED
Bug 4634662 OERI:kolaslGetLength-1 from V$SQL in RAC
This note gives a brief overview of bug 4634662.
The content was last updated on: 12-DEC-2008
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11 Versions confirmed as being affected 10.1.0.5 10.2.0.3 Platforms affected Generic (all / most platforms affected) Fixed: This issue is fixed in 10.2.0.4 (Server Patch Set) 11.1.0.6 (Base Release) Symptoms: Related To: Internal Error May Occur (ORA-600) ORA-600 [kolaslGetLength-1] RAC (Real Application Clusters) / OPS V$SQL GV$SQL Description ORA-600[kolaslGetLength-1] selecting from V$SQL (of GV$SQL) on a RAC database with a varying width character set. Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice. References Bug 4634662 (This link will only work for PUBLISHED bugs) Note 245840.1 Information on the sections in this article

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】