| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: optimal tablespace blocksize
Nope, sorry, Don got this one wrong. Internal and external testing has
shown very little performance improvement this way. If you don't believe
me, I think Anjo was one of those that tested it and saw how small the
performance improvement was.
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-----
Sent: Tuesday, April 22, 2003 9:23 AM
To: Multiple recipients of list ORACLE-L
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.
-- 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). -- 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:31:42 CDT
 |
 |