Out of the blue, 9.2.0.6-database on Sun-Sparc 64-bit:

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 1148
ORA-06512: at “PERFSTAT.STATSPACK”, line 2134
ORA-06512: at “PERFSTAT.STATSPACK”, line 72
ORA-06512: at line 1

Cause: bug 2784796 , fixed in 10G ……. Solution:

re-create the Statspack view stats$v_$sqlxs with a WHERE clause appended:

cp $ORACLE_HOME/rdbms/admin/spcusr.sql newview.sql

filter the create view out of this file, and add the where-clause like this:

create or replace view STATS$V_$SQLXS as
select max(sql_text) sql_text
, sum(sharable_mem) sharable_mem
, sum(sorts) sorts
, min(module) module
, sum(loaded_versions) loaded_versions
, sum(fetches) fetches
, sum(executions) executions
, sum(loads) loads
, sum(invalidations) invalidations
, sum(parse_calls) parse_calls
, sum(disk_reads) disk_reads
, sum(buffer_gets) buffer_gets
, sum(rows_processed) rows_processed
, max(command_type) command_type
, address address
, hash_value hash_value
, count(1) version_count
, sum(cpu_time) cpu_time
, sum(elapsed_time) elapsed_time
, max(outline_sid) outline_sid
, max(outline_category) outline_category
, max(is_obsolete) is_obsolete
, max(child_latch) child_latch
from v$sql
where (plan_hash_value >0
or executions >0
or parse_calls >0
or disk_reads >0
or buffer_gets>0)
group by hash_value, address;

run it as SYS.

m4s0n501