生成AWR报告时遇到的问题:ORA-06502

[复制链接]
查看11 | 回复3 | 2012-9-14 14:12:01 | 显示全部楼层 |阅读模式
系统:AIX6.1
数据库版本:oracle11.2.0.3
在生成AWR报告的时候遇到以下问题:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 919
ORA-06512: at line 1
请问各位这个问题怎么解决。

回复

使用道具 举报

千问 | 2012-9-14 14:12:01 | 显示全部楼层
有哪位遇到过这个问题吗?
回复

使用道具 举报

千问 | 2012-9-14 14:12:01 | 显示全部楼层
The message "Database/Instance 976214629/1 was re-started during specified snapshot interval" is self-explanatory.
If you have restarted a database instance you CANNOT get an AWR report where the begin snapshot is before the restart and the end snapshot is after a restart.
A database instance restart resets most performance and other statistics used by AWR to 0 so AWR cannot compute values (which it does as "end-snapshot-value" MINUS "begin-snapshot-value") as these would very likely be negative and certainly be wrong and misleading.

回复

使用道具 举报

千问 | 2012-9-14 14:12:01 | 显示全部楼层
yanggq 发表于 2013-1-10 15:37
The message "Database/Instance 976214629/1 was re-started during specified snapshot interval" is sel ...

数据库实例一直在运行,没重启
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行