Re: temp tablespace in 10g

From: <frank.van.bortel_at_gmail.com>
Date: 12 Sep 2006 04:00:26 -0700
Message-ID: <1158058826.126817.269060@d34g2000cwd.googlegroups.com>

News schreef:

> Frank van Bortel a écrit :
> > Permanent tablespaces have overhead - your performance will increase!
>
> I agree temp tablespaces created with clause TEMPORARY performs better
> (no segment allocation and deallocation and no release by smon) but how
> to avoid the problem without shutting and restarting server ??
>

Problem? What problem? Just create temp tablespace(s). Then alter the db
to use a (new) global temp TS.
Drop the old one(s) Received on Tue Sep 12 2006 - 06:00:26 CDT