Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB_BLOCK_SIZE set to the highest value
Dino, check this out:
http://www.ixora.com.au/tips/creation/block_size.htm
Steve does an excellent job of explaining away the old myth that block size should be dependent on application type, and that for most Unixes that means an 8K block size, and for NT, 16K or bigger (NT has direct I/O).
(Now, don the flameproof overalls, and retire to a safe distance).
Regards
HJR
-- =============================!!============================= The views expressed are my own only, and definitely NOT those of Oracle Corporation =============================!!============================= "Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:co8rgt0tahhh06ufjhg689g9pmbq4gklfg_at_4ax.com...Received on Thu May 24 2001 - 20:13:33 CDT
> Dear all,
>
> In a book, it says:
> "In the config.ora file, setting the DB_BLOCK_SIZE parameter to the
> highest value supported by your operating system" (see note for
> source)
>
> My question:
> 1.How to find the highest values in Windows NT/2K and Unix's?
> 2.Are these values somehow related to the file system block size?
> 3.Why highest?
> Thanks in advance.
>
> Dino
>
> Note: soure information:
> p.44, Kevin Loney, Oracle 8i DBA Handbook
> Ch1. Getting Started with the ORACLE Architecture ->
> Creating a Database ->
> Modifying the Template Creation Scripts
>