Also, what do you see for P1, P2, P3, P1TEXT, P2TEXT, P3TEXT in V$SESSION_WAIT for this event when the wait occurs? -Mark From: Bobak, Mark Sent: Thursday, February 11, 2010 1:37 PM To: 'taral.desai@xxxxxxxxx'; oracle-l@xxxxxxxxxxxxx Subject: RE: enqueue contention Oracle version? From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Taral Desai Sent: Thursday, February 11, 2010 12:46 PM To: oracle-l@xxxxxxxxxxxxx Subject: enqueue contention Hi All, Anybody have details regarding enq: MS - contention I didn't find much details about it. It just says it's for MV logs related but how to decode this and find which MV log is having problem. -- Thanks & Regards, Taral Desai