RE: optimal tablespace blocksize

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Tue, 22 Apr 2003 09:58:27 -0800
Message-ID: <F001.00587059.20030422095827@fatcity.com>

Couldn't agree more!
Pete
"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA  

-----Original Message-----
Carmichael
Sent: Tuesday, April 22, 2003 10:32 AM
To: Multiple recipients of list ORACLE-L

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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: peter.sharman_at_oracle.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:58:27 CDT