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

Home -> Community -> Usenet -> c.d.o.server -> DB_BLOCK_SIZE set to the highest value

DB_BLOCK_SIZE set to the highest value

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Fri, 25 May 2001 08:19:43 +0800
Message-ID: <co8rgt0tahhh06ufjhg689g9pmbq4gklfg@4ax.com>

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 Thu May 24 2001 - 19:19:43 CDT

Original text of this message

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