今天做statspack时报如下错误：

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

今天做statspack时报如下错误：

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

查了下资料，发现是oracle的bug所致，在v$sql中oracle是允许hash_value有重复值的，而在STATS$SQL_SUMMARY中hash_value是主键值列，于是将STATS$SQL_SUMMARY上主键删除，建上原先主键列的索引，重新执行statspack，问题解决。