Re: "row cache lock" waits on INSERT

  • From: "Anjo Kolk" <anjo.kolk@xxxxxxxxxxx>
  • To: ebadi01@xxxxxxxxx
  • Date: Tue, 12 Aug 2008 14:25:59 +0200

using sequneces with no cache?

On 8/11/08, A Ebadi <ebadi01@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: