----- Original Message -----
Sent: Tuesday, June 19, 2001 4:30
PM
Subject: RE: How to size db_block_size?
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).