From oracle-l-bounce@freelists.org Thu May 5 08:01:24 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j45D1OA1028068 for ; Thu, 5 May 2005 08:01:24 -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 j45D1O4Z028063 for ; Thu, 5 May 2005 08:01:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 62DB8190F00; Thu, 5 May 2005 06:58:48 -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 19747-10; Thu, 5 May 2005 06:58:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C7B1A190A80; Thu, 5 May 2005 06:58:47 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=VABkOg0y/y2kXPWR+kH+4JRNlXldCuv5LuGm5JC17FypzEUz4AIZ75h84+9a5xEOWAw47SJithvGFA54Qij7pmS1wXQT5c/bsWpIPEaxmWseMwjHdA57BwIc3AAiKIE0CWKAxakxZzt94nYhH3YoSvwKjhcqQMM18tz9L+jVebg= Message-ID: <962cf44b05050504566ea9c231@mail.gmail.com> Date: Thu, 5 May 2005 19:56:55 +0800 From: zhu chao To: VIVEK_SHARMA@infosys.com Subject: Re: comments on forcedirectio Cc: geraldine_2@comcast.net, oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: X-archive-position: 19364 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zhuchao@gmail.com Precedence: normal Reply-To: zhuchao@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 Hi, Vivek, Is it only batch job related application slow down, or really the WHOLE instance slowed down? Batch job can be slower as now filesystem cache does not cache the data that not cached by oracle SGA when you do full table scan. After you changed the from buffered io to forcedirectio, do you have any change in oracle SGA size? As now more free memory can be used by oracle? On 5/4/05, VIVEK_SHARMA wrote: >=20 > We experienced significant database wide slowdown for a High Transaction > volume Hybrid(OLTP+Batch) type database on setting forcedirectio(Solaris > OS) on datafile's partitions with Oracle 8i. Performance returned to > normal on removal of the same. >=20 > HTH --=20 Regards Zhu Chao www.cnoug.org -- http://www.freelists.org/webpage/oracle-l