Re: block_size

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: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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: rferguso_at_level1.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).

_________________________________________________________________
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: rafiq9857_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).