"row cache lock" waits on INSERT

From: A Ebadi <ebadi01_at_yahoo.com>
Date: Mon, 11 Aug 2008 12:43:59 -0700 (PDT)
Message-ID: <676014.87555.qm@web51103.mail.re2.yahoo.com>

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

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

Received on Mon Aug 11 2008 - 14:43:59 CDT

This message: [ Message body ]
Next message: Bobak, Mark: "RE: "row cache lock" waits on INSERT"
Previous message: Riyaj Shamsudeen: "Re: AWR Report - "Segments by Row Lock Waits" -> Column "% of Capture""
Next in thread: Bobak, Mark: "RE: "row cache lock" waits on INSERT"
Reply: Bobak, Mark: "RE: "row cache lock" waits on INSERT"
Reply: Anjo Kolk: "Re: "row cache lock" waits on INSERT"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message