Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do enqueue waits affect overall db performance?

How do enqueue waits affect overall db performance?

From: Dave <shoad316_at_hotmail.com>
Date: 6 May 2004 14:15:21 -0700
Message-ID: <78cf0572.0405061315.3a13ae8f@posting.google.com> 





Hey all,



 I have a DB with a large number of enqueue waits, taking up about 77%
of the wait time in a statspack snapshot of 25 minutes.   After some
research its basically because of some distributed transactions over
db_links.  All the blocking locks that I can see are DX.



Event         Waits    Time (s) Ela Time
------------- -------- -------  --------
enqueue       1,372    4,115    77.71%




How will this affect over all db performance?  ie, I have another app
in the same database.. Will this affect them?  If so, how can I
measure it..?



tnx.



Dave
Received on Thu May 06 2004 - 16:15:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US