一个RAC数据库,在实例2上执行exec statspack.snap没有问题,在实例1上执行时就报错,错误为:
SQL> exec statspack.snap
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
ORA-06512: at "PERFSTAT.STATSPACK", line 1361
ORA-06512: at "PERFSTAT.STATSPACK", line 2471
ORA-06512: at "PERFSTAT.STATSPACK", line 91
ORA-06512: at line 1
我使用spdrop删除重建了perfstat,但问题照旧,而且仍然是实例1不能执行,实例2执行成功。请问是什么原因造成的,该如何解决?要重建PERFSTAT表空间吗?