Re: Is space released after deletes?
Date: 1996/09/12
Message-ID: <519cto$217_at_scel.sequent.com>#1/1
The parameters are PCTFREE and PCTUSED.
Oracle fills blocks until they are PCTFREE % full.
When deleting from a table Oracle will not reuse the space within a block until the space used is less than PCTUSED %.
jwalters_at_igate.iohk.com (Jay Walters) wrote:
> There are some parameters on the table, I don't remember what they are
> called, but they control how full ORACLE will make the blocks and when
> it will begin to reuse empty space within a block. If you deleted all
> rows from the table, then all of the blocks should be empty so it should
> reuse the space for that table. The blocks will stay allocated to the
> table until you do an export/import.
> Jay Walters
> Yuri Ludevig (WBRD34A_at_prodigy.com) wrote:
> : I can't get a definite answer if Oracle reuses space after deletes. I ran
> : analyze before and after deletes (I deleted all rows form the table) and
> : statistics didn't seem to change (number of empty blocks, extents, bytes
> : used, etc). Anybody out there knows for sure if you have to do
> : export/import or Oracle takes care of all the holes?
> : Thanks,
> : Yuri in NY
-- Peter Moore. DBA, IS Ops, Sequent Computer Systems Ltd, Weybridge, UK.Received on Thu Sep 12 1996 - 00:00:00 CEST