fragmentation at table level

Could any one provide me with some script to view the amount of fragmentation of a single table...

Thanks in advance...
S.Prabhakar

A table will not be fragmented if you set PCTFREE and PCTUSED carefully. Fragmentation is just applicable to index.

Pls tell me if I make a mistake.

Are two scripts enough ??

Gladly provided
Here

[Edited by clio_usa on 06-09-2002 at 03:38 AM]

Sorry. Some links limitations, cut the message.

The second one is Click Here

Hope that helps,

clio_usa
OCP DBA 8/8i/9i

visit our web site Here

Hi Gurus,

Thanks a lot for the script.

S.Prabhakar