On Fri, 18 Feb 2005 17:12:38 -0500, Aggarwal, Meenakshi <Meenakshi.Aggarwal@xxxxxxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l