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:[EMAIL PROTECTED]]
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
Yahoo! Greetings
- Send your seasons greetings online this year!