RE: enqueue contention

From: Bobak, Mark <>
Date: Thu, 11 Feb 2010 13:39:23 -0500
Message-ID: <>

Also, what do you see for P1, P2, P3, P1TEXT, P2TEXT, P3TEXT in V$SESSION_WAIT for this event when the wait occurs?


From: Bobak, Mark
Sent: Thursday, February 11, 2010 1:37 PM To: ''; Subject: RE: enqueue contention

Oracle version?

From: [] On Behalf Of Taral Desai Sent: Thursday, February 11, 2010 12:46 PM To:
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

-- Received on Thu Feb 11 2010 - 12:39:23 CST

Original text of this message