Re: Global Temporary Table Scalability Problem

From: Paul Drake <bdbafh_at_gmail.com>
Date: 22 Sep 2004 21:03:19 -0700
Message-ID: <910046b4.0409222003.485023e8@posting.google.com>

Jim Garrison <jhg_at_athensgroup.com> wrote in message news:<4151FE5D.9020005_at_athensgroup.com>...
> Richard Foote wrote:
>
> > "william milbratz" <milbratz_at_hotmail.com> wrote in message
> > news:cee3515e.0402090843.1ffda63f_at_posting.google.com...
> > Hi Bill,
> >
> > Be assured that things get a little easier with 9i although analyzing temp
> > tables can have rather nasty repercussions !!
> >
> > Cheers
> >
> > Richard
>
>
> I haven't found that things get any easier in 9i (9.2.0.5.0).
> I'm still seeing a 40x difference between using a GTT
> and a real table, with the GTT on the wrong end of the
> discrepancy (see my other post here).
>
> The SET_TABLE_STATS solution seems to work, however.

Jim,

what is your setting for the value of

v$parameter.name='optimizer_dynamic_sampling'

and optimizer_features_enable ?

-bdbafh Received on Wed Sep 22 2004 - 23:03:19 CDT