Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Tablespace fragmentation
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