Re: Sessions using TEMP and sharing extents

Under create tablespace temp temporary and create temporary tablespace
temp the single sort segment per node is shared but extents allocated
within the segment are used by one session at a time. Under
traditional dictionary management each session allocates its own
private extents.

Does this mean that with a locally managed Temp tablespace there is
effectively a bunch of extents grouped into a single segment that is
used for sorting by all sessions on the database, but with dictionary
managed each session just grabs an extent as it needs it. Either way,
10 sessions sorting at the same time needs 10 extents.

I am guessing that when a session needs a temp extent to hold LOB data
it will just grab one from temp in either locally managed or
dictionary managed.

I checked DBA_Tablespaces again, and in the contents column, oracle
reports 'Temporary' so it knows its a temp tablespace - does this not
mean its a true temp tablespace? From reading Kyte's Expert Oracle,
temp is supposed to be NOLOGGING, but on our system its reported as
LOGGING - this doesn't sound correct does it?



.

Relevant Pages

  • Re: Sessions using TEMP and sharing extents
    ... temp the single sort segment per node is shared but extents allocated ... locally managed temporary tablespace the ... management to be uniform, which it should be). ...
    (comp.databases.oracle.server)
  • Re: Sessions using TEMP and sharing extents
    ... temp the single sort segment per node is shared but extents allocated ... Does this mean that with a locally managed Temp tablespace there is ... locally managed temporary tablespace the ... management to be uniform, which it should be). ...
    (comp.databases.oracle.server)
  • Re: linking a research form with a display page
    ... But if the webmaster will delete the record n°4, ... do I need to delete the temp table) or an other solution to do things ... and when the session is closed the temp table dies. ... this king of search->browse in display ...
    (comp.lang.php)
  • RE: [Info-ingres] ABF - temp tables and exec sql connect question s...
    ... The temp table is not destroyed, just that it's 'scope' is limited to the db ... If you want to 'merge' data from 2 db sessions into one session table you ... as I connect to db2 - how can I get round this and retreive data from ... Neither Npower nor any of the other companies in the RWE Npower group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments for viruses. ...
    (comp.databases.ingres)
  • Re: linking a research form with a display page
    ... I have a page rech.php where I'm doing a multi-criteria research Ex. ... do I need to delete the temp table) or an other solution to do things ... Depending on your database, you can create a persistent session, ...
    (comp.lang.php)