From oracle-l-bounce@freelists.org Mon Jul 12 03:34:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6C8YeW31671 for ; Mon, 12 Jul 2004 03:34:50 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6C8YU631636 for ; Mon, 12 Jul 2004 03:34:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E9D072C8A0; Mon, 12 Jul 2004 03:15:12 -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 17899-57; Mon, 12 Jul 2004 03:15:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5175372C989; Mon, 12 Jul 2004 03:15:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Jul 2004 03:13:39 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 59DDA72C87E for ; Mon, 12 Jul 2004 03:13:38 -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 16850-79 for ; Mon, 12 Jul 2004 03:13:38 -0500 (EST) Received: from mail110.dandomain.dk (mail110.dandomain.dk [194.255.46.110]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 17E1272C83E for ; Mon, 12 Jul 2004 03:13:17 -0500 (EST) Received: from miracleas.dk ([194.106.42.33]) by mail110.dandomain.dk (DanDomain Mailserver) with ASMTP id ECA74362 for ; Mon, 12 Jul 2004 10:37:50 +0200 Message-ID: <40F24DDD.6000403@miracleas.dk> Date: Mon, 12 Jul 2004 10:37:49 +0200 From: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: Hot indexes References: <20040708132055.IWZY28232.fed1rmmtao08.cox.net@smtp.west.cox.net> <40F219A7.4080804@miracleas.dk> <100b01c467e4$dd72cff0$bff923d5@porgand> <101701c467e7$09293ba0$bff923d5@porgand> In-Reply-To: <101701c467e7$09293ba0$bff923d5@porgand> Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4832 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mln@miracleas.dk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org In fact LIO's can originate in 8-900 places in the code, I think (depending on the version). With or without latching, etc. Mogens Tanel Põder wrote: >>You probably meant tracking PIO calls here, since v$session_wait and 10046 >>trace arent able to report LIOs in detailed level. If one wanted to track >>LIOs, event 10200 could be used. But as you said, it would generate huge > > > One more comment, event 10200 traces only consistent gets, not all possible > types of LIOs. > > Tanel. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------