我使用的环境是 8.1.7.0.0
最初安装好 statspack 时,执行 statspack.snap 没有问题,但是今天突然就冒出那个 BUG 的问题,立即修改 spcpkg.sql 文件,用 internal 用户在 sqlplus 中运行了,可是又冒出来一些错误,麻烦大家看看。本来想卸载了重新安装,但是想还是最好知道原因的好。
SQL> exec statspack.snap
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "TEST.STATSPACK" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1