Re: Indexed Tablespace Fragmentation

There's a difference between

    extents per segment
and

    extents per tablespace

One reason I like to keep extents per segment quite low (ideally a few dozen, worst case a couple of hundred) is to ensure that the tablespace as a whole doesn't end up
with huge number of extents.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Niall Litchfield wrote in message
<3ccda888$0$231$cc9e4d1f_at_news.dial.pipex.com>...


>

>I'll live with up to (say) 1000 extents in an lmt (though truthfully more

>than 300 or so gets my goat). I guess I'm saying a couple of hundred seems

>conservative.

>

>

>--

>Niall Litchfield

>Oracle DBA

>Audit Commission UK

>

>