Re: Table keeps growing inspite of purging

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: 1997/11/26
Message-ID: <347CEB67.7C2@si.unirioja.es>#1/1

Sasha Ostojic wrote:
> =

> What if I set PCTUSED 99 and PCTFREE 0? Would that ensure maximum re-u=
se of
> freed space? I tried this, and it did not seem to degrade performance =
much.
> =

> .sasha

Wich is your ORACLE version? In 7.1.6 Oracle doesn't reuse space. I remember now the number of problems with the Installation of Designer 2K (we have to install and uninstall it a lot of times) and the space was not freed..

Julio Negueruela
Telf: 941-299177 Fax: 941- 299244
Servicio Inform=E1tico
Universidad de La Rioja - Spain
mailto:julio.negueruela_at_si.unirioja.es Received on Wed Nov 26 1997 - 00:00:00 CST