block_size

From: Roy Ferguson <rferguso_at_level1.com>
Date: Wed, 18 Apr 2001 12:56:05 -0700
Message-ID: <F001.002EC194.20010418112553@fatcity.com>

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). Received on Wed Apr 18 2001 - 14:56:05 CDT