"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 ( on Solaris 10 w/ ASM).


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

Original text of this message