From oracle-l-bounce@freelists.org Fri Feb 18 17:21:25 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j1INLM0N010642 for ; Fri, 18 Feb 2005 17:21:22 -0600 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 j1INLKem010636 for ; Fri, 18 Feb 2005 17:21:20 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 55CEC760AA; Fri, 18 Feb 2005 17:20:07 -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 27472-07; Fri, 18 Feb 2005 17:20:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CB82A7605B; Fri, 18 Feb 2005 17:20:06 -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:references; b=jGWESxPQf1JZd9ll0gfSX6AOBF+gfduonFK+DF0piJazZLRZSUT5cS44SFk5q2bda64jPw7C7hrutZas0CiOR/QqZEy6bdNLPgDLb8MqiVKhJQ2lwMOtIudaN7BsRCd4UggX/VLoS7DHnN9V/LoHynUo+dQ9TjVjylBFqEu9+/A= Message-ID: <7765c89705021814186641ef25@mail.gmail.com> Date: Fri, 18 Feb 2005 22:18:01 +0000 From: Niall Litchfield To: Meenakshi.Aggarwal@fishersci.com Subject: Re: Windows block size Cc: oracle-l In-Reply-To: <32729C17301C744582A747BD41569C12017CB430@PGHCR-EXMB-VS-1.na.fshrnet.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <32729C17301C744582A747BD41569C12017CB430@PGHCR-EXMB-VS-1.na.fshrnet.com> X-archive-position: 16431 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: On Fri, 18 Feb 2005 17:12:38 -0500, Aggarwal, Meenakshi wrote: > Hi, > > How can I know what is Windows 2003 block size.=20 > I mentioned db_block_size=3D8192 in init file but it is 16384 after = > database creation. I see this value in v$parameter after database is = > created. Any clue? 1. It seems unlikely that the init.ora you thought you were using was the one that you were using, though check the spfile parameters. 2. On windows 16k is probably better than 8k anyway..... -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- http://www.freelists.org/webpage/oracle-l