Truncate global temporary table! That is the right thing to do, especially
if there are multiple users using it. Temporary tables are memory
structures, with temporary tablespace as backup storage and are protected by
shared pool latches. Of course, one has to acquire that latch when doing
truncate, so there are quite a few interesting possibilities with global
temporary tables and truncate. You can really check all those fancy shmancy
algorithms for deadlock resolution and latch coordination by performing
truncate on GTT. Analyze table is also good.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Mercadante, Thomas F
> [mailto:thomas.mercadante_at_labor.state.ny.us]
> Sent: Wednesday, October 27, 2004 2:58 PM
> To: 'rjamya'; Mercadante, Thomas F
> Cc: oracledbam_at_hotmail.com; oracle-l_at_freelists.org
> Subject: RE: TEMPORARY TABLE
>
>
> Raja,
>
> We don't even do delete's on this table - nothing. Oracle
> cleans it up for us at the end of each transaction.
>
> So I'd say you are doing extra work.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 27 2004 - 14:04:45 CDT
