Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Empty fragments in tablespaces

Re: Empty fragments in tablespaces

From: Richard Woods <rawoods_at_concentric.net>
Date: 11 Jun 1998 21:22:35 EDT
Message-ID: <35808518.542EBAA7@concentric.net>


In Oracle7, you can combine adjacent free extents in a tablespace by coalescing the tablespace. This will be periodically done automatically by SMON if the tablespace has a pctincrease > 0. This can also be done manually in 7.3+ with the Alter Tablespace ..... Coalesce command.

Didier wrote:

> With ORACLE 6, when you create a table and after you drop il, you
> still have an empty extent that fragments the tablespace. And in time,
> the tablespace can be empty but you can't allocate a huge initial
> extent table.
> I would like to know from which ORACLE 7 release it is fixed (7.2, 7.3
> or more), and if there is solution to force the unfragmentation in
> previous release.
> Than you very much.
Received on Thu Jun 11 1998 - 20:22:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US