Re: DB_BLOCK_SIZE set to the highest value

Do we set DB_BLOCK_SIZE to the highest value or to the OS block size?

According to CH20 of Oracle8i Designing and Tuning for Performance (A76992-01) and CH1 of Oracle8i Reference (A76961-01), the DB_BLOCK_SIZE is operating system and device dependent.

Using the "df -g" command (no quotes) on the local system to check for the optimal value, my system has 8192 block size so that's what I use for the DB_BLOCK_SIZE in my initTHESID.ora pfile.

Did I miss the point? What about the SGA and the DB_BLOCK_BUFFERS as the means to ensure adequate memory?

I am a developer rather than a "real DBA" so I have to rely on the manuals to make the tradeoffs as opposed to "real world" experience.

Have a great day,
mikejay

Dino Hsu wrote:
>
> 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
Received on Fri May 25 2001 - 08:35:50 CDT