Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:ASSM and tablespace fragmentation
I suspect you mean allocation_type= 'SYSTEM' which is about the gradual changes in extent sizing as the object grows, rather than ASSM which is about using bitmaps in segment headers and at the start of extents to represent the state of blocks rather than using freelists.
If that's what you had in mind, then the following URL may be useful.
http://jonathanlewis.wordpress.com/2007/05/29/autoallocate-and-px/
If this is what you were thinking of then you probably are better off with uniform extents as you know the size of the data and can set a sensible extent size.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 26 2007 - 08:10:00 CDT