Re: Temporary tablespaces using tempfile and concurrent insert/update

"suri" <suriawan_at_gmx.de> wrote in message news:1141083253.938437.247000_at_p10g2000cwp.googlegroups.com...
> Hi,
>
> I have two questions (Oracle 9.2.0.7):
>
> - 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?

tempfiles are not needed for recovery, but datafiles are, even if they are temporary.
The one exception is the default temporary tablespace tempfile used to create a locally
managed system tablespace.

>
> - 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?

What noons said is correct.

>
> Thanks,
> Suriawan
>
Received on Mon Feb 27 2006 - 19:03:20 CST