Re: How to uncover fragmentation?

In <46o87m$a9g_at_its.hooked.net> Craig Harper <caharper_at_hooked.net> writes:
>
>I am sorry if this question is to simple, but I am in need of a little
 

>assistance, being a developer thrust into the DBA role I have a steep
>learning curve and need a little help.
>
>I am trying to find out if our DB's tablespaces are fragmented, and if
 so
>then what do I do about it. I have tried looking through the
>documentation that was left behind but it is pretty thin. Apparently
 the
>last DBA helpedd himself to all the important doc's.
>
>Thanks for anyone's help
>
>
>Craig Harper
>IFTN
>
Craig,

To determine if a table or index is fragmented, perform the following query:

select segment_name,max(extent_id) from dba_extents where owner != 'SYS'
group by segment_name having max(extent_id) > 0;

This will show you any database object that has exceeded its initial extent.

The simplest way to resolve this problem is to Export the object(s) using the compress=y option, drop the object(s), then Import the object(s).

Rich Woods
Oracle Worldwide Customer Support Received on Sat Oct 28 1995 - 00:00:00 CET