"row cache lock" waits on INSERT
Date: Mon, 11 Aug 2008 12:43:59 -0700 (PDT)
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).