在对数据库进行性能统计时，生产数据的awr报告得到ORA-06502错误，查询资料发现属于11.2.0.3的bug，不过还是有办法解决的。

点击(此处)折叠或打开

ORA-06502:PL/SQL:数字或值错误:字符串缓冲区太小
ORA-06512:在"SYS.DBMS_WORKLOAD_REPOSITORY",line 1033
ORA-06512:在 line 1

Bug 13527323 - ORA-6502 generating HTML AWR report using awrrpt.sql in Multibyte characterset database [ID 13527323.8]
解决方法：

点击(此处)折叠或打开

update WRH$_SQLTEXT set sql_text = SUBSTR(sql_text, 1, 1000);
commit;

以下内容引用其他博主的文章，博客地址http://blog.sina.com.cn/s/blog_75ad98f301017t05.html

在之前的MOS中也提到这个bug,出现版本为Oracle 10.2.0.4，修复版本为Oracle 11.2.0.1。

在Oracle 11.2.0.3.0中这个bug再次出现，MOS也给出解决方法：

Bug 13527323 - ORA-6502 generating HTML AWR report using awrrpt.sql in Multibyte characterset database [ID 13527323.8]

Affects:

Product (Component) Oracle Server (Rdbms)

Range of versions believed to be affected Versions BELOW 12.1

Versions confirmed as being affected

11.2.0.3

Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

12.1 (Future Release)

11.2.0.3.3 Patch Set Update

11.2.0.3 Bundle Patch 7 for Exadata Database

11.2.0.3 Patch 7 on Windows Platforms

打PSU至11.2.0.3.3，修复相关awr问题。

ITPub博客

在ORACLE 11.2.0.3中AWR遭遇ORA-06502和06512

Affects:

Fixed:

最新文章

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 12.1
Versions confirmed as being affected	11.2.0.3
Platforms affected	Generic (all / most platforms affected)