Re: FRAGMANTATION on a table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 8 Feb 2000 10:55:20 +0100
Message-ID: <950003857.18622.0.pluto.d4ee154e@news.demon.nl>

Analyzing table compute statistics
and a select * from dba_tables where table_name = '<your table>' and owner = '<your owner>' should provide useful info.

Hth,

Sybrand Bakker, Oracle DBA

<atta707_at_my-deja.com> wrote in message news:87o7kv$qj5$1_at_nnrp1.deja.com...
> 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 Tue Feb 08 2000 - 03:55:20 CST