Issue:--
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
ORA-06512: at "PERFSTAT.STATSPACK", line 3588
ORA-06512: at "PERFSTAT.STATSPACK", line 5300
ORA-06512: at "PERFSTAT.STATSPACK", line 104
ORA-06512: at line 1
Solution :--
Errors in file
/opt/oracle/admin/ABC/bdump/abc_j000_20902.trc:
ORA-12012: error on auto execute of job 2ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
ORA-06512: at "PERFSTAT.STATSPACK", line 3588
ORA-06512: at "PERFSTAT.STATSPACK", line 5300
ORA-06512: at "PERFSTAT.STATSPACK", line 104
ORA-06512: at line 1
Solution :--
SQL> alter table perfstat.STATS$SQL_SUMMARY disable
constraint STATS$SQL_SUMMARY_PK;
Table altered.
SQL> exec statspack.snap;
PL/SQL procedure successfully completed.
SQL>