Re: Temporary tablespace size

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0308110252.3f87176b_at_posting.google.com>...
> rooty_hill2002_at_yahoo.com.au (Gary) wrote in message news:<171bd226.0308102036.ec5015_at_posting.google.com>...
> > Hi! All,
> >
> > I am Oracle newbie and I am using 9i2 on HP-UX 11i.
> >
> > I am puzzled by the size of the temporary tablespaces at the moment.
> > My Data Warehouse team is building a new data mart at the moment, lots
> > of sorting, I suppose. The database is of about 50G, it takes 3.5G
> > temporary tablespace and it just stays there and never changes, even
> > when after I shutdown the instance and no new session is connected.
> >
> > I thought temporary tablespace is the last thing I need to worry
> > about. I made it locally managed and big enough. Automated segment
> > space management is not available for temporary tablespace as far as I
> > know.
> >
> > Just curious to want to know. I know the fact that sort segment
> > created for each instance is reused and it is only dropped if the
> > tablespace is dropped. Does this have anything to do with it?
> >
> > Thanks in advance for all inputs.
> >
> > Gary
>
>
> Combine your last paragraph with the first and answer your question in
> the affirmative
>
> Sybrand Bakker
> Senior Oracle DBA

Thanks Sybrand.

This means this 3.5G is all the space which HAS BEEN USED AND CAN BE REUSED rather than WHICH IS USED AT THE MOMENT. This makes sense to me. Only thing now is to explain this to those developers.

Thanks again.

Gary Received on Mon Aug 11 2003 - 18:27:18 CDT