Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Windows block size

Re: Windows block size

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 18 Feb 2005 22:18:01 +0000
Message-ID: <7765c89705021814186641ef25@mail.gmail.com>


On Fri, 18 Feb 2005 17:12:38 -0500, Aggarwal, Meenakshi <Meenakshi.Aggarwal_at_fishersci.com> 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
Received on Fri Feb 18 2005 - 17:21:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US