RE: enqueue contention

Select owner, object_type,object_name from dba_objects where object_id=229466;

From: Taral Desai [mailto:taral.desai_at_gmail.com] Sent: Thursday, February 11, 2010 2:40 PM To: Bobak, Mark
Cc: oracle-l_at_freelists.org
Subject: Re: enqueue contention

Sorry, Mark it's 10.2.0.3 on solaris sparc 64 bit

WAIT #56: nam='enq: MS - contention' ela= 488355 name|mode=1297285126 master object #=229466 0=0 obj#=-1 tim=1155110529463 WAIT #56: nam='enq: MS - contention' ela= 488360 name|mode=1297285126 master object #=229466 0=0 obj#=-1 tim=1155111018049

Also, from session wait

                                                                                                                          % Total  Total Event   Distinct   Avg time
    SID STATE   EVENT                               P1                         P2              P3                    SEQ#    Time      Time ms     Events   ms/Event


------- ------- ----------------------------------- -------------------------- --------------- --------------- ---------- ------- ------------ ---------- ----------

    594 WAITING enq: MS - contention                name|mode= 1297285126      master object   0= 0                         99.99    24328.662          1  24328.662
                                                                               #= 229466

    594 WORKING On CPU / runqueue                                                                                             .01        1.338          1      1.338

On Thu, Feb 11, 2010 at 12:39 PM, Bobak, Mark <Mark.Bobak_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>> wrote: 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<mailto:taral.desai_at_gmail.com>'; oracle-l_at_freelists.org<mailto: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> [mailto: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<mailto: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

--

Thanks & Regards,
Taral Desai

--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 11 2010 - 13:51:09 CST