RE: How to size db_block

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Tue, 19 Jun 2001 00:39:44 -0700
Message-ID: <F001.0032E3D0.20010619003054@fatcity.com>

Hi Justin,

A larger data block size provides greater efficiency in disk and memory I/O (access and storage of data). Such cases include:

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.
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:jd_coleman_ora1_at_hotmail.com]
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: jd_coleman_ora1_at_hotmail.com

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: ListGuru_at_fatcity.com (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). Received on Tue Jun 19 2001 - 02:39:44 CDT

RE: How to size db_block_size?