Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: wchy65@hotmail.com (Wade Chy)
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
Subject: Help with Tablespace fragmentation
Date: 10 Oct 2001 15:07:24 -0700
Organization: http://groups.google.com/
Lines: 5
Message-ID: <36df3e33.0110101407.1d5ece22@posting.google.com>
NNTP-Posting-Host: 206.221.253.99
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1002751644 15381 127.0.0.1 (10 Oct 2001 22:07:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2001 22:07:24 GMT
Xref: easynews comp.databases.oracle.server:120871 comp.databases.oracle.misc:70157
X-Received-Date: Wed, 10 Oct 2001 15:10:47 MST (news.easynews.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.