Home » RDBMS Server » Server Administration » ora-00001 unique constrain (PERFSTAT.STAT$DATABASE_INSTANCE) violated (oracle 10g R1)
ora-00001 unique constrain (PERFSTAT.STAT$DATABASE_INSTANCE) violated [message #354153] Thu, 16 October 2008 11:33 Go to next message
Messages: 136
Registered: November 2006
Senior Member
ora-00001 unique constrain (PERFSTAT.STAT$DATABASE_INSTANCE) violated
We observe the same error occuring everyday at same time .
Statspack job is running every hour.
But we are not able to find any reason for this error and why it occurs at this time. I/O activity is very high during that period .
Is it related anyway to this error.
kindly help
Re: ora-00001 unique constrain (PERFSTAT.STAT$DATABASE_INSTANCE) violated [message #354396 is a reply to message #354153] Sat, 18 October 2008 06:59 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

At the same time two job is running for the same work????
I means you need to check there is any other job is scheduled for the same work.

[Updated on: Sat, 18 October 2008 07:00]

Report message to a moderator

Previous Topic: materialized views
Next Topic: How to generate "Create tablespace statement"
Goto Forum:

Current Time: Wed Aug 23 20:23:17 CDT 2017

Total time taken to generate the page: 0.18544 seconds