Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OS Block Size - MS Windows NT
Right, but how can I (or my DBA) determine what the lowest-best value for
this setting would be under NT. For instance, under VMS, the OS block size
is (or used to be) 512 bytes (and I think it cannot be changed), so the DB
block size could be any multiple of that (i.e. 512 x 5 = 2560). I think you
can set this database parameter however you like, but if you know the OS
block size, you can set it most efficiently so as little disk space as
possible is consumed by empty allocation.
Am I making sense?
Thanks
Tommy Noble
tnoble_at_lawaudit.com
Joe Maloney <mpir_at_compuserve.com> wrote in message
news:88sb0s$mli$1_at_nnrp1.deja.com...
> The default size is usually (or has been ) 2K. It is set at database
> creation time and cannot be changed for that instance/database.
> (Export/recreate/import is doable). It can go up to 16K on most
> platforms (I seem to remember hearing about 32K but can't prove it).
Received on Mon Feb 21 2000 - 16:01:01 CST