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: Temporary tablespaces using tempfile and concurrent insert/update

Re: Temporary tablespaces using tempfile and concurrent insert/update

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 27 Feb 2006 15:54:06 -0800
Message-ID: <1141084446.875079.190940@i40g2000cwc.googlegroups.com>


suri wrote:

> - What is the different from a "normal" temporary tablespace and a
> temporary tablespace using temp file? I think that every objects
> created on temporary tablespace will not generate any redo (except redo
> to protect undo), what is then the benefit using tempfile?

Sort work areas, group aggregation work areas, temporary tables, among others.

> - I use locally managed tablespace and have many 5 concurrent insert to
> the table. Is there any contention issue? I think freelist management
> will not be used anymore if locally managed tablespace is used. Is this
> correct?

You're confusing extent management (LMT) with segment management. You need the latter to get rid of freelist management issues. It's the SEGMENT SPACE MANAGEMENT [AUTO|MANUAL] option of CREATE TABLESPACE. Received on Mon Feb 27 2006 - 17:54:06 CST

Original text of this message

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