RE: Is there anything called session specific tables

Above what all have answered you temporary tables do not generate CR buffers. Therefore it could reduce latch contention for cache buffer chains.

Regards.

> -----Mensaje original-----
> De: Jamadagni, Rajendra [SMTP:rajendra.jamadagni_at_espn.com]
> Enviado el: viernes 16 de marzo de 2001 15:46
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Is there anything called session specific tables
>
> Tapas,
>
> 8i release 2 has a concept of session temporary tables. By why that? We
> have
> solved a similar problems since Oracle 7 days by adding two columns to a
> pseudo-temp table. This table is permanent but the data is temporary. All
> data in the table can be identified by the userid and sess_seq columns.
> Every time you need to use the table, you fetch a sess_seq number from a
> oracle sequence. Use the data and delete the information just before
> exiting. This allows to cleanly divide the datasets while using the same
> table.
>
> Once a week, we truncate these pseudo-temp tables.
>
> HTH
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art !
>
> *********************************************************************
>
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law. If
> you have received this message in error, or are not the named
> recipient(s), please immediately notify ESPN at (860) 766-2000 and delete
> this e-mail message from your computer, Thank you.
>
> *********************************************************************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jamadagni, Rajendra
> INET: rajendra.jamadagni_at_espn.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).