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
ankush_chawla
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

Report message to a moderator

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: archive destination
Next Topic: DB migration for Unix to Windows Server (7 to 10g)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 17:44:15 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.