Re: Lost Table Space

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 21 Oct 1999 15:54:59 -0700
Message-ID: <7uo5p7$pmi$1@plo.sierra.com>

Check into PCTFREE (the percentage of free space in each extent) PCTUSED (the percentage of used space before a new extent is allocated)

Your table may "use" 6GB in a 9GB allocation

KM <skmok_at_worldnet.att.net> wrote in message news:7ul0na$elr$1_at_bgtnsc01.worldnet.att.net...
> I'm not a trained DBA, but have been asked a DBA question. Your help
would
> be much, much appreciated!
>
> We have allocated 10 GB of table space with 100 MG auto extents. We have
> several tables that take up about 6 GB of space - we verified that by
> looking at the space available using the DBA manager. However, when we
> tried to create a new table, we cannot allocate a 1GB space for that table
> out of this table space. Why? Anything to do we fragmented space in the
10
> GB allocated?
>
> Thanks in advance!!!
>
>
Received on Thu Oct 21 1999 - 17:54:59 CDT