Re: Table Fragmentation

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Thu, 01 Jul 1999 07:54:52 -0400
Message-ID: <377B570B.DB85E0CB@Unforgettable.com>

There is a script provided by oracle that will check for chained rows. Look in your $ORACLE_HOME/rdbms/admin directory for utlchain.sql.

If you run statistics on your table (for accuracy, use COMPUTE STATISTICS) the CHAIN column in DBA_TABLES will show the number of rows that are chained.

Ken

pauldb wrote:

> I have a table where there is always a large percentage of
> updating on the table. And the change of row size is from
> approx 50bytes to 2000 bytes.
>
> So I need to check that the values PCTFREE and PCTUSED are
> optimal.
>
> The question is:
> 1) how can I check if there are chained blocks?
> 2) Is there a way to check if these values are optimal?
> 3)any suggestions for an optimal setting?
>
> **** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****
Received on Thu Jul 01 1999 - 06:54:52 CDT