RE: enqueue contention

Ok, so, what's object # 229466?

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




From: Taral Desai [mailto:taral.desai@xxxxxxxxx]
Sent: Thursday, February 11, 2010 2:40 PM
To: Bobak, Mark
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> 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@xxxxxxxxx<mailto:taral.desai@xxxxxxxxx>'; 
oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: RE: enqueue contention

Oracle version?

From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto: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<mailto: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



--
Thanks & Regards,
Taral Desai

Other related posts: