RE: "row cache lock" waits on INSERT

From: Bobak, Mark <>
Date: Mon, 11 Aug 2008 15:49:56 -0400
Message-ID: <>


When you see the wait happening, what is being reported in P1, P2, P3?

Take the P1 value and do:
Select * from v$rowcache where cache#=<value of P1 when session waits on 'row cache lock' wait>;

Hope that helps,



Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059<><><>

ProQuest...Start here.

From: [] On Behalf Of A Ebadi Sent: Monday, August 11, 2008 3:44 PM
Subject: "row cache lock" waits on INSERT

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:49:56 CDT

Original text of this message