Re: Hint for in memory temporary table?
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- Date: Mon, 16 Jan 2006 00:41:23 +0000
Why do you think your temporary table went to disk?
Where you think data in a temporary table physically located?
I'm not sure on that, but I would guess that GTT data stored in sessions PGA.
If it true that presumably sort_arrea_size can have some effect on how
long Oracle will try to keep GTT data in the memory.
Please correct me if I am wrong.
J
On 1/13/06, Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx> wrote:
> No, just something that will force my global temporary table session
> segment to stay in memory, instead of going to tempfile.
>
> On 1/13/06, Tanel Põder <tanel.poder.003@xxxxxxx> wrote:
> > Are you talking about materialize hint?
> >
> > Tanel.
> >
> > ----- Original Message -----
> > From: "Christo Kutrovsky" <kutrovsky.oracle@xxxxxxxxx>
> > To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>; "oracle-l"
> > <oracle-l@xxxxxxxxxxxxx>
> > Sent: Friday, January 13, 2006 10:58 AM
> > Subject: Hint for in memory temporary table?
> >
> >
> > > Hello,
> > >
> > > Do you guys remember what was the hidden/special hint to create a
> > > global temporary table in memory or to force the data to stay in
> > > memory?
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Christo KutrovskySenior Database/System AdministratorThe Pythian Group
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Jurijs
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
