Re: Hint for in memory temporary table?

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_at_gmail.com> 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_at_mail.ee> wrote:
> > Are you talking about materialize hint?
> >
> > Tanel.
> >
> > ----- Original Message -----
> > From: "Christo Kutrovsky" <kutrovsky.oracle_at_gmail.com>
> > To: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>; "oracle-l"
> > <oracle-l_at_freelists.org>
> > 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?
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Christo KutrovskySenior Database/System AdministratorThe Pythian Group
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jurijs
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l