On Aug 11, 7:33 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Joe wrote:
> > I just dropped varchar2 (50) column full of data on a couple of tables
> > (approx 3 millions of records total) in my tablespace, and now I would
> > like to "defragment" the 10g database.
> > Toad 8 that I use shows tablespace Fragmentation Index = 33.57 and
> > when I look at tablespace map, it has many free space pieces spreaded
> > around whole tablespace as well as data of many tables spreaded too.
> > I would like to reorganize this tablespace (I can do it offline). Can
> > you please quide me with that?
> > I would also like to know the Fragmentation Index.. 33 is high
> > defragmentation or fair enough?
>
> > Thank you.
>
> And you have determined there is fragmentation by what means?
>
> Please show us the SQL statement(s) and the metrics retrieved.
>
> 33.57 is a measure of what?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
what I said its a measure done by Toad.
Received on Sat Aug 11 2007 - 20:22:07 CDT
