Oracle-L: RE: optimal tablespace blocksize

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Tue, 22 Apr 2003 07:36:39 -0800
Message-ID: <F001.00586CF6.20030422073639@fatcity.com>

Dead easy, same as the database block size should be identified. Different block sizes are designed only for transporting tablespaces from an OLTP system to a staging database before summarization into a data warehouse. 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.

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 7:32 AM
To: Multiple recipients of list ORACLE-L

What's the best way to determine the optimal tablespace blocksize?

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

--

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