RE: How to size db_block_size?

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Tue, 19 Jun 2001 01:07:49 -0700
Message-ID: <F001.0032E45A.20010619010045@fatcity.com>

Well, you'd want your database block size to be an integer multiple of your file system block size, to minimize I/O, because Oracle reads and writes in blocks, if there is any overlap that means you are using an file system level I/O for a partial block. I remember hearing that Oracle were recommending a block size of 8k for almost everything now. It used to be that one would select a block size of 2k or 4k for OLTP and 8 or 16k for DSS.

g.

-----Original Message-----

Sent: 19 June 2001 08:06
To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
  INET: guy.hammond_at_avt.co.uk

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 - 03:07:49 CDT