Re: peeking into global temporary table from other session and some tunning
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 24 Nov 2017 21:41:00 +0300
Message-ID: <CAOVevU7MObXzeuRmdS-wY+NLer0BKfppnz5QMyqr2s2PXETq3A_at_mail.gmail.com>
Date: Fri, 24 Nov 2017 21:41:00 +0300
Message-ID: <CAOVevU7MObXzeuRmdS-wY+NLer0BKfppnz5QMyqr2s2PXETq3A_at_mail.gmail.com>
Could you create and share sqld360 reportfor a couple of such queries? and
if possible trace 10053 for the execution with the data in gtt
24 нояб. 2017 г. 21:35 пользователь "GG" <grzegorzof_at_interia.pl> написал:
> W dniu 2017-11-24 o 18:29, Sayan Malakshinov pisze:
>
> Hi,
>
> > especially the result of dynamic sampling level 2 (default) on gtt
> involved in joins
>
> Have you deleted table statistics of this gtt?
>
> There is no statistics there , only dynamic_sampling 2 takes place .
>
> G
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 24 2017 - 19:41:00 CET