Joe <joe1977_at_tlen.pl> wrote in news:1186881727.056989.27590@
19g2000hsx.googlegroups.com:
> 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.
>
How can folks who don't have TOAD, independently verify your results?
Received on Sat Aug 11 2007 - 21:16:22 CDT