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

From: ramick <ramick_at_dotster.com>
Date: Mon, 19 Jun 2006 14:36:14 -0700
Message-Id: <20060619214337.B0237359128@turing.freelists.org>

What version?
What OS?
What configuration, ie RAC, shared server, etc?

What are the values of the parameters:
p1 is the name or mode, p2 should be the object number

K Gopalakrishnan is correct; I believe SQ is a lock to ensure that only one process can replenish the sequence cache at a time.

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net
Sent: Monday, June 19, 2006 10:52 AM
To: K Gopalakrishnan
Cc: oracle-l_at_freelists.org
Subject: Re: are there any extensive docs on 10g wait events?

I saw the blurb in the reference guide. This is a test box. No one else is on it. No sequences in any of the test code.
 

any more detailed docs?
 
 
 

-------------- Original message -------------- From: "K Gopalakrishnan" <kaygopal_at_gmail.com> Ryan:

SQ is related to sequences. Are you using ORDERed sequences on RAC?

-- 
Best Regards,
K Gopalakrishnan 
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

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

Received on Mon Jun 19 2006 - 16:36:14 CDT