Temporary Table Space Abuse

From: Chris Forlano <cforlano_at_nortelnetworks.com>
Date: Tue, 14 Sep 1999 01:34:13 +0100
Message-ID: <37DD9804.2AE9D5E4@nortelnetworks.com>

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 Mon Sep 13 1999 - 19:34:13 CDT