Re: FRAGMANTATION on a table

run the utlchain.sql in the /$ORACLE_HOME/rdbms/admin directory

then issue this command:
analyze table table_name list chained rows into chained_rows.

query the chained_rows table as such:
select count(*) from chained_rows where table_name='TABLE_NAME'; compare this to the actual number of rows in the table.

If the ratio of chained_rows to num_rows is high rebuild your table.

atta707_at_my-deja.com wrote:

> hi all the oracle gurus,
>
> i'm a newbie oracle dba.
>
> we've got a table with lotta frequent inserts and deletes. more often
> the highwater mark, and number of extents allocated for this table is
> way above what it should be.
> could you please suggest a way to find out how bad is the fragmentation
> and, more importantly, if it is the appropriate time to drop and re-
> create this table to prevent the hog.
>
> thanks in anticipation.
>
> ATTA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Feb 09 2000 - 21:02:14 CST