RE: enqueue contention

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 11 Feb 2010 13:39:23 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F3BDE7D0B_at_AAPQMAILBX02V.proque.st>

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_at_gmail.com'; oracle-l_at_freelists.org Subject: RE: enqueue contention

Oracle version?

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taral Desai Sent: Thursday, February 11, 2010 12:46 PM To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 11 2010 - 12:39:23 CST