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: <sybrandb_at_yahoo.com>
Date: 11 Aug 2003 03:52:55 -0700
Message-ID: <a1d154f4.0308110252.3f87176b@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 Received on Mon Aug 11 2003 - 05:52:55 CDT

Original text of this message

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