RE: Tablespace autoextend problem

From: Rodgers, Tony (CEI-Atlanta) <Tony.Rodgers_at_cox.com>
Date: Wed, 3 Feb 1999 15:45:03 -0500
Message-ID: <529B47EE34C4D1118D0800A0C99ABC9832873B@EATL0S04>

Have you checked the PCTFREE value for the table and/or the tablespace? Sounds almost like you might have a high value for this which would cause Oracle to reserve a large amount of space for updates to these rows.

> -----Original Message-----
> From: Robert Klaus [SMTP:bobnaoko_at_xnet.com]
> Posted At: Wednesday, February 03, 1999 1:06 PM
> Posted To: comp.databases.oracle.server
> Conversation: Tablespace autoextend problem
> Subject: Tablespace autoextend problem
>

[Rodgers, Tony (Atlanta)] Snip
>
> A table had a number of inserts so that it now has 41 extents. Its
> next
> extent size is 104K. It now has 1300 rows with an average length of
> 68
> bytes.
>
> The tablespace that its in was created with 500M and an autoextend of
> 50M.
> It has extended itself 11 times now.
>
> It seems that the only reason that the tablespace is extending is due
> to the
> inserts into this table. Of the 1050M now in the tablespace 465M is
> used.
> There are a number of very large free extents in the tablespace that
> this
> table doesn't use.
>

[Rodgers, Tony (Atlanta)] Snip
> Bob Klaus
>
Received on Wed Feb 03 1999 - 14:45:03 CST