Re: are there any extensive docs on 10g wait events?

From: Yongping Yao <yaoyongping_at_gmail.com>
Date: Tue, 20 Jun 2006 10:47:18 +0800
Message-ID: <706468990606191947u7c158c2se5c4a825707ced7d@mail.gmail.com>

I think K Gopalakrishnan has explained it in his Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Chapter 8 talked about it.

On 6/19/06, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
>
> 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?
>

-- 
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog:  http://spaces.msn.com/yaoyp/

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

Received on Mon Jun 19 2006 - 21:47:18 CDT