Re: defragmenting free space in a tablespace

In article <480vjf$27v8_at_usenetw1.news.prodigy.com>, DGWW16A_at_prodigy.com says...
>
>I called Oracle about the same problem a couple of days ago and they said
>that SMON will not defragment the free space in any tablespace which has
>the default storage parameter "pctincrease" set to 0. I set the
>pctincrease to 1 and the fragmentation was gone in a frew hours. Oracle
>7.3 will add an alter tablespace command to defragment.
>
this is due to bug#250441 in 7.1.3 of SMON

You can defragment a tablespace manually with   alter session set events 'immediate trace name coalesce level <n>'

where <n> is the number of the tablespace obtained by   select ts# from ts$ where name = <name of the tablespace>    

-- 
    _/_/_/   _/_/_/ _/    _/  // Reinhard Kuhn             /  It can be      
   _/    _/ _/     _/  _/    //         (kuhn_at_cas-ps.com) /  done quickly,   
  _/_/_/   _/_/_/ _/_/      // CAS GmbH                  /  cheaply or well  
 _/  _/   _/     _/  _/    // Lemberger Strasse 14      /   - pick any two!  
_/   _/  _/_/_/ _/    _/  // 66955 Pirmasens, Germany  /