AWR Snapshots Failing with ORA-00001: unique constraint (SYS.WRH$_RULE_SET_PK) violated
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
- Automatic AWR Snapshots are failing
- MMON trace (mmon) shows the Flush slave failed:
This will create duplicate stats in gv$rule_set which is based on the fixed table x$rule_set.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms