The max db_block_size depends on your OS platform. 8K size is better for
OLTP and 16-32K is better for Datawarehouse applications.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 18 Apr 2001 11:25:53 -0800
I'm in the process of upgrade to 8.1.6 from 8.0.5 and will be changing the
block_size by re-building the database via exp/imp. This is on a Sun Sparc
Solaris 2.6 server. I noticed that the db block_size can have a maximum
value
of 16k.
I was wondering if anyone has experience in determining the block size that
works best in their environment and if you could share how you determined
the
value.
Thanks in advance. Roy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Roy Ferguson
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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
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).
