Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TEMPORARY TABLESPACE IS PERMANENT ON 7.3.2 NT4
jbmorlaATcalva.net wrote:
>
> The database is installed by an application without temporary tablespace.
> The users default to a tablespace TEMPO that is permanent. On big "analyze
> compute..." I can see the temporary segments with tablespace manager. Is
> there a performance overhead to not having the tempo tablespace really
> temporary???
The main performance hit is "clean up" ie the database has to clean up temporary segments that were created to get some free space back for creation of other temp segs...By setting the tspace to temporary, the cleanup does not take place - the existing segments just become available for reuse...
If you do lots of sorting - this is a significant thing...If you don't do lots of sorting (or all of your sorts are small), then you probably won't be impacted as much...
Why not just create a temporary one, change the user definitions and see if you get some improvement ?
HTH
--