awrrpt.sqll生成awr报ORA-06502,ORA-06512

MOS搜搜

Bug 13575143 : ORA-6502 OCCURS WHEN TRYING TO GENERATE HTML AWR REPORT USING AWRRPT.SQL    

通过如下SQL可以还原报错信息：
select output from table(dbms_workload_repository.awr_report_html(1955022668,2,38439,38440,0 ));

Case  

The AWR report can be generated without any errors when using the TXT format.

百度搜搜

有人匹配Mos，bug修改基表，由于是生产系统，非常不建议修改基表，建议1.使用txt临时生成awr报告；2.打psu相关补丁包
update WRH$_SQLTEXT set sql_text = SUBSTR(sql_text, 1, 1000);
commit;

awrrpt.sqll生成awr报ORA-06502,ORA-06512

标签：sqlt   comm   sys   osi   character   生成awr报告   repos   数据库版本   sum