So is that what it says in the bible? I personally have no problem with temp
tablespace being permanent. I have switched a few databases back and forth
between temp and perm and find no detectable performance impact. Your system
may be different but it doesn't hurt to test it. Just don't make the extents
too small.
"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 - 18:07:47 CDT
