Re: "row cache lock" waits on INSERT

We ended up dropping the sequences and that did it.  
Thanks for your replies everyone!

• On Tue, 8/12/08, Anjo Kolk <anjo.kolk_at_oraperf.com> wrote:

From: Anjo Kolk <anjo.kolk_at_oraperf.com>
Subject: Re: "row cache lock" waits on INSERT To: ebadi01_at_yahoo.com
Cc: oracle-l_at_freelists.org
Date: Tuesday, August 12, 2008, 6:25 AM

using sequneces with no cache?

On 8/11/08, A Ebadi <ebadi01_at_yahoo.com> wrote:
> We are seeing lots of "row cache lock" waits in the DB during a
long running
> insert and the performance is really poor on this insert. Any suggestions
> on what to look for? We have not come up with much from Metlink/Oracle
> Support/Google yet.
>
> Environment: 3-node Oracle RAC (10.2.0.3.0 on Solaris 10 w/ ASM).
>
> Thanks,
> Abdul
>
>
>

-- 
Anjo Kolk
Owner and Founder OraPerf Projects
tel:    +31-577-712000
mob: +31-6-55340888
--
http://www.freelists.org/webpage/oracle-l





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