Re: Temporary tablespaces using tempfile and concurrent insert/update


"suri" <suriawan@xxxxxx> wrote in message
news:1141083253.938437.247000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Temporary tablespaces using tempfile and concurrent insert/update
    ... What is the different from a "normal" temporary tablespace and a ... temporary tablespace using temp file? ... created on temporary tablespace will not generate any redo (except redo ... I use locally managed tablespace and have many 5 concurrent insert to ...
    (comp.databases.oracle.server)
  • Re: Temporary table use and the redo log
    ...   I'm using a global temporary table to break up a section ... Especially -I don't want redo logs for it-. ... Temporary blocks are written from PGA to temporary tablespace in a way ... So if you have a stored procedure that inserts 1000 rows when called ...
    (comp.databases.oracle.server)
  • Re: Temporary table use and the redo log
    ... Temporary blocks are written from PGA to temporary tablespace in a way ... REDO, but for conventional DML this is still covered by UNDO, and UNDO ... SQLTools++ for Oracle: ...
    (comp.databases.oracle.server)
  • Re: ora-03232
    ... Add files to the tablespace using ADD TEMPFILE command. ... Is it a true temporary tablespace, ... If it's not a true temporary tablespace then it's ... It is a temporary tablespace and coalescing doesn't work. ...
    (comp.databases.oracle.server)
  • Re: TEMP tablespace: a big one or 10 small ones?
    ... Additionally during monthly production huge amounts of data need to be put into the database. ... assigned the tablespace group as a temporary tablespace to the user ... scott@ORA102> create temporary tablespace temp_1 tempfile ...
    (comp.databases.oracle.server)