Joe wrote:
> 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.
Which I hope you can appreciate is meaningless in and of itself.
Two thoughts.
1. Find out what is actually being measured.
2. Determine whether it is affecting anything worth investing time in
handling.
Excel spreadsheets are great a producing numbers. Too often they mean
nothing. This may be a similar case.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Aug 12 2007 - 13:34:01 CDT
