Re: fragmentation

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 26 Nov 2004 09:01:38 +1100
Message-ID: <41a6563f$0$17545$afc38c87@news.optusnet.com.au>

vertigo wrote:
> Hello
>
> How can i check what is maximal size of extent which i can put into
> specified tablespace ? (i create table with stotage initial values).
>
> Are there any perespectives which 'shows' me fragmentation level ?
> How can i correct fragmentation ?
>
> Thanx
> Michal
>

As others have said, LMTs abolish tablespace fragmentation at a stroke. However, it's possible you can't use LMTs, so you may instead be interested in

http://www.dizwell.com/html/fragmentation.html

Regards
HJR Received on Thu Nov 25 2004 - 16:01:38 CST