From oracle-l-bounce@freelists.org Mon Aug 22 20:21:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7N1L8h5014131 for ; Mon, 22 Aug 2005 20:21:08 -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 j7N1L4IP014117 for ; Mon, 22 Aug 2005 20:21:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 189A01E54C0; Mon, 22 Aug 2005 20:21:01 -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 04985-08; Mon, 22 Aug 2005 20:21:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 941041E56EA; Mon, 22 Aug 2005 20:21:00 -0500 (EST) Message-ID: <01e901c5a780$aaaaa610$68f5a8c0@TerryVaio> From: "Terry Sutton" To: References: <77A4D80DB2ADD74EB5D7F1D31626F0C0022B7422@usa0300ms03.na.xerox.net> Subject: Re: Idle events list Date: Mon, 22 Aug 2005 18:17:29 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01A6_01C5A745.C1CB37F0" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-ELNK-Trace: 5830af7b3b91928f1aa676d7e74259b7b3291a7d08dfec799c33be92f1cad83d54310eb38e9fb3ec350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 4.20.98.115 X-archive-position: 24320 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: terrysutton@usa.net Precedence: normal Reply-To: terrysutton@usa.net 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-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_01A6_01C5A745.C1CB37F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Idle events listI've never seen a formal definition of an "idle event" = (notwithstanding the fact that I've listed some in a paper :-) ), and = ignoring idle events in addressing performance problems can be = dangerous. But if you want a list, the table STATS$IDLE_EVENT in the = PERFSTAT schema contains one. I would note that in some versions this = list has varied, and not just because new events have been created. --Terry Does anyone have a complete list of all idle events in Oracle 9i2, = including idle RAC events?=20 Thanks=20 ------=_NextPart_000_01A6_01C5A745.C1CB37F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Idle events list
I've never seen a formal definition of = an "idle=20 event" (notwithstanding the fact that I've listed some in a paper :-) ), = and=20 ignoring idle events in addressing performance problems can be = dangerous. =20 But if you want a list, the table STATS$IDLE_EVENT in the PERFSTAT = schema=20 contains one.  I would note that in some versions this list has = varied, and=20 not just because new events have been created.
 
--Terry
Does anyone=20 have a complete list of all idle events in Oracle 9i2, including idle = RAC=20 events?

Thanks=20

------=_NextPart_000_01A6_01C5A745.C1CB37F0-- -- http://www.freelists.org/webpage/oracle-l