Re: Temp tablespace vs. tablespace ... temp

I didn't benchmark but I suppose there's a little performance gain but using the proper temporary tablespace since the traditional temporary tablespace is LOGGING, unless you turn it off. I'm managing a production database where I altered the traditional temporary tablespace NOLOGGING a long time ago. Never had any problem. Can anyone say why a temporary tablespace needs logging? If I can't apply redo to it in recovery, so what?

Yong Huang
yong321_at_yahoo.com

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3CDCFBB7.6964_at_yahoo.com>...
>
> The biggest benefits I can see are:
>
> a) you can use a tempfile to have a readonly standby database
> b) you don't need to backup the tempfile (you can do the same with a
> tspace of type temporary but it takes a little more effort during
> recovery)
> c) its an lmt
Received on Sat May 11 2002 - 16:45:05 CDT