Re: ORA-00001: unique constraint (SYS.WRH$_MUTEX_SLEEP_PK) violated

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Sun, 9 Dec 2012 22:24:28 +0200
Message-ID: <CAMHX9JLEr11vdBW5om8ADXZb8u+yXE=r=Js+JugpwYAezBaSug_at_mail.gmail.com>

Oh I used two table names in the example just to show you can specify a comma separated list of tables. Yep you need to only use the wrh$_mutex_sleep as the parameter ...

Tanel

On Sun, Dec 9, 2012 at 8:30 PM, Marko Sutic <marko.sutic_at_gmail.com> wrote:

> btw
> What is "WRH$_MEM_DYNAMIC_COMP"?
>
> Shouldn't be enough for this particular problem just to execute:
> alter system set "_awr_disabled_flush_tables"='WRH$_MUTEX_SLEEP'; (haven't
> executed this yet)
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Dec 09 2012 - 21:24:28 CET