Re: completely get rid of perfstat user

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 15 Aug 2005 23:25:28 GMT
Message-ID: <Iv9Me.1481$PM3.1378@twister.nyroc.rr.com>

NetComrade wrote:
> All,
>
> Is there are a way to completely remove perfstat from the database
> (w/o looking through each create script)? (9.2.0.7)
> For whatever reason, something keeps not being incremented, and we get
> the following error on executing the perfstat job.
>
> 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
>
> We've tried dropping the user and then recreating it, but it doesn't
> seem to help (I believe there are other objects being created
> elsewhere that perfstat relies on)
> .......
> We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
> remove NSPAM to email

I ran into same problem a while back. Its a bug in 9i.

I'm not exactly sure if you ran into the same exact bug because that bug was related to perfstat snapshots being taken at >= 5 level.

Bug 2784796 where statspack.snap using level higher than 5 fails with ORA-0001

Checkout the workaround/fix in metalink

Anurag Received on Mon Aug 15 2005 - 18:25:28 CDT