Re: Help with Tablespace fragmentation

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 12 Oct 2001 07:31:33 +1000
Message-ID: <3bc613f9$1@news.iprimus.com.au>

Excuse me??

The guy asks for advice on how to find out about tablespace fragmentation, and you give him a query that shows when a segment's acquired more than 1 extent.

You do know, I hope, that fragmentation has got precisely nothing to do with the number of extents a segment may have acquired?

If not you should. If yes, why post a pretty useless query?

Regards
HJR "Paul Quenneville" <paulq_at_home.com> wrote in message news:_A4x7.41724$5h5.18749396_at_news3.rdc2.on.home.com...
> select segment_name,count(*)
> from user_extents
> group by segment_name
> having count(*) > 1
>
> "Wade Chy" <wchy65_at_hotmail.com> wrote in message
> news:36df3e33.0110101407.1d5ece22_at_posting.google.com...
> > Hi All
> > How can I find out if a tablespace is fragmented? Is there any data
> > dictionary view I can query to find out howmuch a tablespace has
> > fragmented and what is the best way to coalesc the tablespace.
> > Thank you in advance.
>
>
Received on Thu Oct 11 2001 - 16:31:33 CDT