Re: Spd 19c adaptive statistics

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 6 Jan 2021 13:54:08 +0300
Message-ID: <CAOVevU7T38vHdrLjQQCx65VtA4zoKeXPVVBtFKiaDRDQH5HrVg_at_mail.gmail.com>

Hi Moustafa,

You can try this query:

select
  sql_id

 ,plan_hash_value
 ,id
 ,spd.*

from dba_hist_sql_plan p
 ,xmltable(

     '//spd'
     passing xmltype(other_xml)
     columns spd xmltype path '.'
     )(+) spd

where lower(other_xml) like '%<spd>%';

On Wed, Jan 6, 2021 at 1:20 PM Moustafa Ahmed <moustafa_dba_at_hotmail.com> wrote:

> Stefan
>
> Is there a way to find when this happened in the best and for which
> sql’s(dba_hist_xxx)?
>
> > On Jan 6, 2021, at 1:09 AM, Stefan Koehler <contact_at_soocs.de> wrote:
> >
> > Stefan
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 06 2021 - 11:54:08 CET