RE: TEMPORARY TABLE
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: 'K Gopalakrishnan' <kaygopal@xxxxxxxxx>, "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- Date: Wed, 27 Oct 2004 15:48:16 -0400
> -----Original Message-----
> From: K Gopalakrishnan [mailto:kaygopal@xxxxxxxxx]
> Sent: Wednesday, October 27, 2004 3:18 PM
> To: mladen.gogala@xxxxxxxx
> Cc: thomas.mercadante@xxxxxxxxxxxxxxxxx; rjamya;
> oracledbam@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
