Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tablespaces using tempfile and concurrent insert/update
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