From oracle-l-bounce@freelists.org  Thu Oct 20 10:30:31 2005
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air891.startdedicated.com (root@localhost)
 by orafaq.com (8.12.10/8.12.10) with ESMTP id j9KFUPKw007156
 for <oracle-l@orafaq.com>; Thu, 20 Oct 2005 10:30:26 -0500
X-ClientAddr: 206.53.239.180
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9KFTjvX006934
 for <oracle-l@orafaq.com>; Thu, 20 Oct 2005 10:29:46 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B1661208A6E;
 Thu, 20 Oct 2005 10:20:22 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 14137-07; Thu, 20 Oct 2005 10:20:22 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3B97D208121;
 Thu, 20 Oct 2005 10:20:22 -0500 (EST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=WGnIwvOg8jh2D5jG5hpTrBkV9Ed/SV/0lDff0jnsNOrp+K1+9Ut7Or9A5cVV9TVenQE5+h6tQzwJ68k5lZcIFPAGSDGAJ0oKvSgWMNDR9RpeTGaF+ZJR5wNdqJJ5WuQIBT5aRg2wNycb/JltjCcz1shgSh3XA/VFOkxGkhAEQg8=
Message-ID: <be592d550510200818n62a3959et5201eca45e43f4a4@mail.gmail.com>
Date: Thu, 20 Oct 2005 16:18:13 +0100
From: David Sharples <davidsharples@gmail.com>
To: =?ISO-8859-1?Q?Alfonso_Le=F3n?= <aleon68@gmail.com>
Subject: Re: enqueue in statspack
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <83a585ac0510200815ic25efeah3185bebad070a78a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_4093_20407692.1129821493330"
References: <83a585ac0510200803n35520557jfe66e643040e727f@mail.gmail.com>
	 <be592d550510200806m2414f14bt6c82112db10e55ee@mail.gmail.com>
	 <83a585ac0510200815ic25efeah3185bebad070a78a@mail.gmail.com>
X-archive-position: 27256
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: davidsharples@gmail.com
Precedence: normal
Reply-To: davidsharples@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net
X-mailscan-MailScanner-Information: Please contact the ISP for more information
X-mailscan-MailScanner: Found to be clean
X-MailScanner-From: oracle-l-bounce@freelists.org
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on 
 air891.startdedicated.com
X-Spam-Level: 
X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE 
 autolearn=ham version=2.63
------=_Part_4093_20407692.1129821493330
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

what does this return wait, if you have an enqueue wait it till show it her=
e
 select * from v$enqueue_stat where total_wait# > 0;

 On 10/20/05, Alfonso Le=F3n <aleon68@gmail.com> wrote:
>
> I'm sorry but this article wasn't useful.
>
>

------=_Part_4093_20407692.1129821493330
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>what does this return wait, if you have an enqueue wait it till show i=
t here</div>
<div>&nbsp;</div>
<div>select * from v$enqueue_stat where total_wait# &gt; 0;<br><br>&nbsp;</=
div>
<div><span class=3D"gmail_quote">On 10/20/05, <b class=3D"gmail_sendername"=
>Alfonso Le=F3n</b> &lt;<a href=3D"mailto:aleon68@gmail.com">aleon68@gmail.=
com</a>&gt; wrote:</span>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I'm sorry but this article wasn'=
t useful.<br><br></blockquote></div>

------=_Part_4093_20407692.1129821493330--
--
http://www.freelists.org/webpage/oracle-l