Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Tablespace fragmentation

Re: Help with Tablespace fragmentation

From: Paul Quenneville <paulq_at_home.com>
Date: Wed, 10 Oct 2001 23:11:54 GMT
Message-ID: <_A4x7.41724$5h5.18749396@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 Wed Oct 10 2001 - 18:11:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US