Tuesday 8 October 2013

ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated

Issue:--

Errors in file /opt/oracle/admin/ABC/bdump/abc_j000_20902.trc:
ORA-12012: error on auto execute of job 2
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 :--

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>