Re: enqueue contention
From: Taral Desai <taral.desai_at_gmail.com>
Date: Thu, 11 Feb 2010 13:39:44 -0600
Message-ID: <2b0cd5cd1002111139g6a74ed1dod40e880c811ca558_at_mail.gmail.com>
Sorry, Mark it's 10.2.0.3 on solaris sparc 64 bit
> -Mark
> *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
>
Date: Thu, 11 Feb 2010 13:39:44 -0600
Message-ID: <2b0cd5cd1002111139g6a74ed1dod40e880c811ca558_at_mail.gmail.com>
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>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
> > >> *To:* 'taral.desai_at_gmail.com'; oracle-l_at_freelists.org
> *From:* Bobak, Mark
> *Sent:* Thursday, February 11, 2010 1:37 PM
> *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
>
-- Thanks & Regards, Taral Desai -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 11 2010 - 13:39:44 CST