Oracle-L: Re: optimal tablespace blocksize

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Tue, 22 Apr 2003 08:22:41 -0800
Message-ID: <F001.00586E24.20030422082241@fatcity.com>

On Tue, Apr 22, 2003 at 07:36:39AM -0800, Pete Sharman wrote:
> There is so little in the way of performance gains in using different block
> sizes for different objects that there are far more important tuning efforts
> to be done before even considering this as a tuning tool.

"Out of all of the sophisticated enhancements of Oracle9i, many experienced DBAs consider multiple block sizes to be the most important feature for tuning the Oracle database." - Donald K. Burleson

http://www.dba-oracle.com/art_dbazine_9i_multiblock.htm

I feel like Rosanna Rosanna Danna.

Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Apr 22 2003 - 11:22:41 CDT