Tablespace autoextend problem

From: Robert Klaus <bobnaoko_at_xnet.com>
Date: Wed, 3 Feb 1999 12:05:47 -0600
Message-ID: <79a3vj$nuk$1@flood.xnet.com>

Our application has a tablespace that autoextends even though it seems that it shouldn't have to.

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.

Why might a tablespace autoextend itself as a table allocates extents even though there are huge contiguous blocks of free space available.

We are running Oracle 8.04 on Solaris 2.51 with an 8K blocksize.

Any help would be appreciated.

Bob Klaus Received on Wed Feb 03 1999 - 12:05:47 CST