enq: TX - row lock contention ... usn<<16 | slot ... sequence Wait
From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 18 Jan 2008 10:08:44 +0530
Message-ID: <69E1360E54B50C4A828A136C158E4742036A7076A2@BLRKECMBX02.ad.infosys.com>
-------------- --------------
EVENT
Date: Fri, 18 Jan 2008 10:08:44 +0530
Message-ID: <69E1360E54B50C4A828A136C158E4742036A7076A2@BLRKECMBX02.ad.infosys.com>
Folks
During a Benchmark Run following Wait is extremely High
enq: TX - row lock contention
usn<<16 | slot
sequence
Qs How is the issue to be approached / actioned please?
Cheers & Thanks
P.S.
select * from v$session_wait sw
04:15:31 2 where sw.event not in ('rdbms ipc message','smon timer','pmon timer', 04:15:31 3 'SQL*Net message from client','lock manager wait for remote message', 04:15:31 4 'client message', 'SQL*Net more data from client', 'pipe get', 04:15:31 5 'null event', 'PX Idle Wait', 'single-task message', 'wakeup time manager') 04:15:31 6 order by sw.seconds_in_wait desc; SID SEQ#
-------------- --------------
EVENT
P1TEXT P1P1RAW
---------------------------------------------------------------- --------------
P2TEXT P2P2RAW
---------------------------------------------------------------- --------------
P3TEXT P3SECONDS_IN_WAIT STATE
---------------------------------------------------------------- --------------
P3RAW WAIT_CLASS_ID WAIT_CLASS#
---------------- -------------- --------------
WAIT_CLASS WAIT_TIME
---------------------------------------------------------------- --------------
--------------- ------------------- 10569 38 enq: TX - row lock contention name|mode 1415053318 0000000054580006 usn<<16 | slot 262144022 000000000FA00016 sequence 167 00000000000000A7 4217450380 1 Application 0 2179 WAITING **************** CAUTION - Disclaimer *****************This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 17 2008 - 22:38:44 CST