Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Temporary tablespace size

Re: Temporary tablespace size

From: Joel Garry <joel-garry_at_home.com>
Date: 11 Aug 2003 16:26:19 -0700
Message-ID: <91884734.0308111526.45d7f73@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?

It's supposed to be cleaned up on startup. I've seen where you need to startup twice to make it clean up. I don't know if this is a feature or a bug. Try it. Also see notes on metalink explaining temp ts's.

>
> Thanks in advance for all inputs.
>
> Gary

jg

--
@home.com is bogus.
grep VAX `find / -name "*.h"`
Received on Mon Aug 11 2003 - 18:26:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US