Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news3.rdc2.on.home.com.POSTED!not-for-mail
From: "Paul Quenneville" <paulq@home.com>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
References: <36df3e33.0110101407.1d5ece22@posting.google.com>
Subject: Re: Help with Tablespace fragmentation
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <_A4x7.41724$5h5.18749396@news3.rdc2.on.home.com>
Date: Wed, 10 Oct 2001 23:11:54 GMT
NNTP-Posting-Host: 24.156.176.182
X-Complaints-To: abuse@home.net
X-Trace: news3.rdc2.on.home.com 1002755514 24.156.176.182 (Wed, 10 Oct 2001 16:11:54 PDT)
NNTP-Posting-Date: Wed, 10 Oct 2001 16:11:54 PDT
Organization: Excite@Home - The Leader in Broadband http://home.com/faster
Xref: easynews comp.databases.oracle.server:120875 comp.databases.oracle.misc:70161
X-Received-Date: Wed, 10 Oct 2001 16:12:56 MST (news.easynews.com)

select segment_name,count(*)
from user_extents
group by segment_name
having count(*) > 1

"Wade Chy" <wchy65@hotmail.com> wrote in message
news:36df3e33.0110101407.1d5ece22@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.