RE: "row cache lock" waits on INSERT
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "ebadi01@xxxxxxxxx" <ebadi01@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Aug 2008 15:49:56 -0400
Abdul,
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
--
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
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of A Ebadi
Sent: Monday, August 11, 2008 3:44 PM
To: oracle-l@xxxxxxxxxxxxx
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 (10.2.0.3.0 on Solaris 10 w/ ASM).
Thanks,
Abdul
Other related posts:
