Re: "row cache lock" waits on INSERT
From: Anjo Kolk <anjo.kolk_at_oraperf.com>
Date: Tue, 12 Aug 2008 14:25:59 +0200
Message-ID: <54973d5e0808120525w6d812b69t14ea90ed63d1f6d6@mail.gmail.com>
Date: Tue, 12 Aug 2008 14:25:59 +0200
Message-ID: <54973d5e0808120525w6d812b69t14ea90ed63d1f6d6@mail.gmail.com>
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-lReceived on Tue Aug 12 2008 - 07:25:59 CDT