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

Home -> Community -> Usenet -> c.d.o.server -> Why my Temporary tablespace is always 99% full ?

Why my Temporary tablespace is always 99% full ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 6 May 2003 09:43:42 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703A35068@lnewton.leeds.lfs.co.uk>


Tingl wrote :

>> alter tablespace ... permanent;

that is not going to make things any better, only worse ! Permanent 'temp' tablespaces are a bad thing to have !

Cheers,
Norm.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
Received on Tue May 06 2003 - 03:43:42 CDT

Original text of this message

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