Re: Is space released after deletes?

From: Peter Moore <ptmoore_at_sequent.com>
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

Original text of this message