Re: Tablespace growing at enormous rate

Could be a couple of things :-

What objects are actually in your USERS tablespace?

    select * from dba_objects where tablespace_name = 'USERS';

I'd guess you may have PCTINCREASE set to something other than 0 on the objects stored in the tablespace.
Each time the segment extents it will also increase its percent size by the pctincrease amount. Hence if its set to 50 it will 'double' the size of the next extent each time it extends. select pctincrease,segment_name from dba_segments where tablespace_name = 'USERS' and pctincrease <> 0;
Its usually a very good idea to set the pctincrease to 0 for each object and size the next extent manually.

What is pctused and pctfree on the segments?

Alun

"Joe" <Joe_at_foo.com> wrote in message
news:aconjo$rlf0d$1_at_ID-87429.news.dfncis.de...
> "Joe" <Joe_at_foo.com> wrote:
>
>
> > However since Monday our USERS tablespace is growing at
> > an alarming rate - 1400 MB per day.
>
> To be more precise - our USERS tablespace consisted of
> 10 datafiles. Since Monday these files have gone berserk -
> as I said, 1400 MB was allocated for a datafile in USERS
> tablespace per day.
>
> To remedy this somehow, yesterday I added
> new datafile (11th datafile for USERS), and set
> AUTOEXTEND OFF on old datafiles (10 of them).
> Initial size for this datafile was 500 M, AUTOEXTEND ON.
>
> However, even this one skyrocketed to 1500 MB
> after just one day.
>
>
Received on Sun May 26 2002 - 05:39:22 CDT