Re: How to measure level of database disorganization/fragmentation?

> How can we measure level of index disorganization so we can determine when
> and what level to launch an index rebuild?

Check out the ANALYZE INDEX command. That will populate the *_INDEXES tables which can be interrogated to find out the clustering_factor.

> When running an export/import on a table, we run into situations where we
> can export but not import due to a need for contiguous space which is not
> available, even though the overall space IS available.

Even after you drop the object(s) you have just EXPorted !!!  

> My question is: How can we determine the level of fragmentation in a
> tablespace so we are able to determine when a full tablespace import/export
> is needed?

Check out the SYS.DBA_FREE_SPACE & SYS.DBA_FREE_SPACE_COALESCED tables; as long as you know the tablespace name you can see things like MIN(EXTENTS_COALESCED).

Eugene (Oracle Certified dba still seeking employment). Received on Tue Jan 05 1999 - 16:14:28 CET