Re: Temporary Table Space Abuse

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Tue, 14 Sep 1999 10:58:00 -0400
Message-ID: <37DE6278.CDB3C782@fmr.com>

In general, several temp tablespaces should be faster if they are on separate disks...

Chris Forlano wrote:

> I have about 10 tablespaces, each containing one file and averaging
> about 50MB.
> I have a single temporary tablespace containing one 500MB file.
>
> Would it be better to have separate smaller temporary tablespaces for
> each of
> the other tablespaces? At what point am I abusing the temporary
> tablespace?
>
> Running Oracle8.0.5 on Solaris2.6.
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> TMS Project Manager
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
Received on Tue Sep 14 1999 - 09:58:00 CDT