Re: TEMPORARY TABLE

EP,

Even though DDL is less common than DML, DML isn't affected, whereas
DDL is. It behaves just like a regular-run-of-the-mill-physical table,
only that the data you see is session specific.

In our environment, we use lots of GTT for various reasons, and
sometimes we have to push some users out of the db to perform column
adds etc.

Raj


On Wed, 27 Oct 2004 13:35:00 -0500, Post, Ethan <ethan.post@xxxxxx> wrote:
> Can you clarify a bit more on #2? Is DDL something that would be common
> or did you mean DML?
> 
> 
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of rjamya
> Sent: Wednesday, October 27, 2004 1:31 PM
> To: thomas.mercadante@xxxxxxxxxxxxxxxxx
> Cc: oracledbam@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: Re: TEMPORARY TABLE
> 
> well tom is almost 99% there ... there is the rest of the story ...
> about GTTs that
> 
> 1. you better use dynamic_sampling with them
> 2. any even one session is useing it, you can't perform most DDLs
> 3. forget doing truncates on them, KGopal probably has the proof.
> 
> otherweise they work almost as advertised ...
> Raj
> 
> On Wed, 27 Oct 2004 14:20:03 -0400, Mercadante, Thomas F
> <thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> > Seema,
> >
> > I use Global Temporary Tables all the time.  They are memory
> structures.
> > Very fast.  Very easy to set up.  No problems at all.
> >
> > Good Luck
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> >
> >
> >
> > -----Original Message-----
> > From: Seema Singh [mailto:oracledbam@xxxxxxxxxxx]
> > Sent: Wednesday, October 27, 2004 1:34 PM
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: TEMPORARY TABLE
> >
> > Hi,
> > Is any performance problem if we go with TEMPORARY table?
> > any thoughtS?
> > thx
> >
> > _________________________________________________________________
> > Express yourself instantly with MSN Messenger! Download today - it's
> FREE!
> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> 
> --
> ------------------------------
> --
> 
> 
> http://www.freelists.org/webpage/oracle-l
> 


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

Other related posts: