Re: Size of temporary tablespace

The rule I try to follow (but am not always allowed to) is that the TEMP space should be at least twice the size of the largest object in the database (sometimes a table, sometimes an index.) Depending on the number of simultaneous users and what they are doing (lots of reporting sorts and/or joins), it might even have to go higher.

In article <38E1DC7E.195F_at_yahoo.com>,
connor_mcdonald_at_yahoo.com wrote:
> Peter Laursen wrote:
> >
> > Hi
> >
> > What guidelines do you use when estimating the size of the temporary
> > tablespace?
> >
> > I just had an import fail because the size of an index was larger
 than the
> > temp tablespace. (8.0.5 on NT 4.0) So I guess temp should be at
 least the
> > size of the largest index?
> >
> > tia
> > Peter Laursen
>
> (About) double the size of the index is a roughie - but in any event
 you
> want to be adding your indexes after the import not during so you can
> add clauses such as parallel, nologging and tweak you sort area size.
>
> HTH
>
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.