Oracle-L: AW: Multiple block sizes in 9i

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Thu, 16 Jan 2003 09:04:30 -0800
Message-ID: <F001.00531978.20030116090430@fatcity.com>

Hi Jos

I used that to store data with different row sizes in areas of the database where the block size fits the row size best. For instance, you have an OLTP database with rows that fit perfectly fine into 4k blocks. Then, you have some tables with "longer" rows. So, you can go ahead and assign that data to reside on an area with 8k blocks. This allows the database to work with buffers, that fit the size of the row best and avoid unnecessary i/o.

Regards,
Stefan

-----Ursprüngliche Nachricht-----
Von: Jos [mailto:jos1992831_at_yahoo.com.au] Gesendet: Donnerstag, 16. Januar 2003 14:14 An: Multiple recipients of list ORACLE-L Betreff: Multiple block sizes in 9i

List,

Oracle 9i supported multiple block sizes, I am wondering under what circumstances one would setup a database with multiple block sizes?

Jos

<http://au.rd.yahoo.com/mail/tagline/?http://au.greetings.yahoo.com> Yahoo! Greetings
- Send your seasons greetings online this year!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stefan Jahnke
INET: Stefan.Jahnke_at_bov.de

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 Thu Jan 16 2003 - 11:04:30 CST