> -----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