RE: TEMPORARY TABLE

> -----Original Message-----
> From: K Gopalakrishnan [mailto:kaygopal_at_gmail.com]
> Sent: Wednesday, October 27, 2004 3:18 PM
> To: mladen.gogala_at_aetn.com
> Cc: thomas.mercadante_at_labor.state.ny.us; rjamya;
> oracledbam_at_hotmail.com; oracle-l_at_freelists.org
> Subject: Re: TEMPORARY TABLE
>
>
> Mladen:
>
> Truncates and GTTs may not together. I think we had discussed
> this same last week..

I must confess that I didn't react last week because I already knew that stuff.
Basically, doing truncate on a GTT can cause a gorgeous shared pool latch deadlock that will effectively hang the whole instance.

--
http://www.freelists.org/webpage/oracle-l