Re: optimal tablespace blocksize

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 22 Apr 2003 09:31:41 -0800
Message-ID: <F001.00586F48.20030422093141@fatcity.com>

definition please for:

"many" -- quantify please: how many said they agree out of how many surveyed out of how many DBAs are considered "experienced"

which brings me to the next definition:

define "experienced" -- number of years working with Oracle? number of complicated databases worked with? number of tables dealt with? number of various versions of Oracle worked with?

I have way too much work to do to worry about how many different blocksizes I have in the database, along with a number of different buffer cache sizes and various and assorted pools.

Pick a reasonable database block size, define your multiple locally managed tablespaces to have reasonable extent sizes and work on tuning something important -- like business processes and wait events.

• Ray Stell <stellr_at_cns.vt.edu> wrote:
  > 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).
  >
  

  ---

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo http://search.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

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 - 12:31:41 CDT