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

Home -> Community -> Mailing Lists -> Oracle-L -> are there any extensive docs on 10g wait events?

are there any extensive docs on 10g wait events?

From: <ryan_gaffuri_at_comcast.net>
Date: Mon, 19 Jun 2006 15:47:13 +0000
Message-Id: <061920061547.21563.4496C701000165EE0000543B2205886014079D9A00000E09A1020E979D@comcast.net> 





Oracle added alot of granularity to the 10g wait interface, but the documentation seems to be lacking. I tried googling, google groups, metalink, and otn and I can't really find any detail on this wait:



enq: SQ - contention



Looks like some kind of share lock contention(if I am reading it). I saw a vague reference in some powerpoint slides to ITL waits.  



I opened a TAR, but sometimes it takes a while to get a response. Does Oracle document the new waits anywhere? 

--
http://www.freelists.org/webpage/oracle-l


Received on Mon Jun 19 2006 - 10:47:13 CDT












Original text of this message













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