Temporary tablespaces using tempfile and concurrent insert/update

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

Thanks,
Suriawan Received on Mon Feb 27 2006 - 17:34:14 CST