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@xxxxxxxxxxx>
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@xxxxxxxx> wrote:
Stefan