Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: TEMPORARY TABLE

RE: TEMPORARY TABLE

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 27 Oct 2004 14:43:12 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F9E4@exchsen0a1ma>


And, what do you mean by dynamic sampling?

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Post, Ethan [mailto:Ethan.Post_at_ps.net] Sent: Wednesday, October 27, 2004 2:35 PM To: rjamya_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: TEMPORARY TABLE

Can you clarify a bit more on #2? Is DDL something that would be common or did you mean DML?=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya
Sent: Wednesday, October 27, 2004 1:31 PM To: thomas.mercadante_at_labor.state.ny.us
Cc: oracledbam_at_hotmail.com; oracle-l_at_freelists.org 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_at_labor.state.ny.us> wrote:
> Seema,

>=20
> I use Global Temporary Tables all the time. They are memory
structures.
> Very fast. Very easy to set up. No problems at all.

>=20

> Good Luck
>=20

> Tom Mercadante
> Oracle Certified Professional
>=20
>=20
>=20
>=20

> -----Original Message-----
> From: Seema Singh [mailto:oracledbam_at_hotmail.com]
> Sent: Wednesday, October 27, 2004 1:34 PM
> To: oracle-l_at_freelists.org
> Subject: TEMPORARY TABLE
>=20

> Hi,
> Is any performance problem if we go with TEMPORARY table?
> any thoughtS?
> thx
>=20  _________________________________________________________________

> Express yourself instantly with MSN Messenger! Download today - it's
FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>=20

> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--=20
------------------------------
--

http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 27 2004 - 13:38:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US