Only for the bound segment.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th
"Brian Dick" <bdick_at_cox.net> wrote in message
news:11dbclzlpu4ps.dh82t1bdvn49$.dlg_at_40tude.net...
> On Thu, 23 Sep 2004 00:50:44 +0000 (UTC), Jonathan Lewis wrote:
>
> > Read about dynamic sampling.
> >
> > Use a level where all tables without
> > statistics are sampled at run time, and
> > your problem will go away.
>
> Cool feature. The docs don't say anything about its use with GTT. Are
there
> any special considerations when using dynamic sampling with GTT's? Does
the
> sampling get performed only for the segments bound to the
> session/transaction or do all GTT segments get sampled?
Received on Thu Sep 23 2004 - 13:42:22 CDT
