Hi Justin,
A larger data block size provides greater efficiency in disk and memory I/O (access and storage of data). Such cases include:
a) Oracle is on a large computer system with a large amount of memory and fast disk drives. For example, databases controlled by mainframe computers with vast hardware resources typically use a data block size of 4K or greater.
b) The operating system that runs Oracle uses a small operating system block size. For example, if the operating system block size is 1K and the data block size matches this, Oracle may be performing an excessive amount of disk I/O during normal operation. For best performance in this case, a database block should consist of multiple operating system blocks.
Hope that this would helps you.
Nirmal.
-----Original Message-----
From: Justin Coleman [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 10:06 AM
To: Multiple recipients of list ORACLE-L
Subject: How to size db_block_size?
Dear All,
Is there a recommended approach on how to decide on the db_block_size for
your database? I am looking to create a database that during the day will
be used for light OLTP, but during the day and night will have heavish batch
jobs. Therefore I was intent on using 8k or 16k blocks. Most likely 8k
blocks. But is there an approach to actually chosing the correct
db_block_size?
Cheers for any help in advance.
Justin
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Justin Coleman
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
