How to get execution plans of sql that were run as part of ETL

Hi All,

This might look simple but queries come in handy. Always remember the plan which we get from explain plan is not the actual plan its only estimated plan. The plan that we are getting from below queries is the Actual plan

select a.*, to_char(substr(sql_text,1,400)) from

(

select sql_id, sum(executions_delta), sum(elapsed_time_delta)/1000/1000

from dba_hist_sqlstat where snap_id >= 13222-240

group by sql_id

)a, dba_hist_sqltext b

where a.sql_id=b.sql_id

order by 3 desc

 

Select * From Dba_Hist_Osstat

Where Stat_Name Like '%LOAD%'

And Snap_Id >= 14672-240

order by 6 desc

 

 Select * From Dba_Hist_Snapshot

 where snap_id in (1273,1173,1151,11218,12351)