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 -> Re: Why my Temporary tablespace is always 99% full ?

Re: Why my Temporary tablespace is always 99% full ?

From: tingl <all4one_at_one4all.not>
Date: Tue, 06 May 2003 22:57:52 GMT
Message-ID: <Q5Xta.58259$ey1.5278020@newsread1.prod.itd.earthlink.net>


Actually it is not as bad as most think.

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA703A35068_at_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 - 17:57:52 CDT

Original text of this message

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