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>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'; oracle-l@xxxxxxxxxxxxx > *Subject:* RE: enqueue contention > > > > Oracle version? > > > > *From:* 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 > *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