执行awr报告时,直接报ora-06502的错误

郑全

The default report file name is awrrpt_1_35700_35701.html.  To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name awrrpt_1_35700_35701.html
select output from table(dbms_workload_repository.awr_report_html( :dbid,
                         *
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 2834
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 677
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 537
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 387
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 339
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 224
ORA-06512: at line 1

Report written to awrrpt_1_35700_35701.html

版本:10.1.0.2

这个是一个bug,临时解决办法为,报告类型设置text即可.