Re: Temp Tablespace Full

I think Vittal is talking about rollback segs, cause the optimal clause is used only for rollback segments, secondly, since RBS tend to extend and shrink, by specifying the optimal clause, after extending the rollback seg will shrink back to its optimal size or manually u could as :Alter rollback segment shrink.

This cannot be done on tablespace: to maximize the reusability of the dropped extent is temp tablespace, u should choose an initial and next extent size of 1/20th to 1/50th of the size of the temp tablespace and pctincrease of 0
so the segments will be same sized extents, when the seg is dropped, the

next temp seg to be formed will be able to reuse the dropped extent.

Nilima

Vitaliy Mogilevskiy wrote:

> SHRINK ? - I have never seen such a command !
> anyone else ?
>
> +------------
> -------------------------------------------------------------+
> | Vitaliy Mogilevskiy
> | Senior Consultant
> | CORE Technology Group, Inc.
> | E-mail: vit100gain_at_earthlink.net
> | Web Page: http://home.earthlink.net/~vit100gain/index.html
> | *** Free DBA Script Library at my Web Page ***
> +----------------------------------------------------------
> ---------------+
>
> "G.H VITTAL" wrote:
>
> > If you give optimal size for the tablespace it should automatically
> shrink
> > when it exceeds the shrink value.
> >
> > Alternatively you can give the sql command
> >
> > ALTER TABLESPACE ts_name shrink to 10MB which will shrink the
> tablespace to
> > 10MB. If you don't specify the size as 10MB it will shrink to the
> optimal
> > value
> >
> > thank you
> > vittal gh
> >
> > Gitesh Haridas wrote:
> >
> > > I have a Temp tablespace of type temporary.
> > > I recently had to add additional datafile to allow major joins and
> sorts
> > > to go through.
> > >
> > > Is there anyway of shrinking a temporary tablespace to reclaim
> that space,
> > > after
> > > the transaction is completed.
> > > I dont understand. The tablespace is of type temporary.
> > >
> > > Any ideas
>
> --
Received on Tue May 04 1999 - 10:29:58 CDT