Hello,
I am trying to get some statistics on the execution of a particular SQL. I get the sql_id from DBA_HIST_SQLTEXT but I can't find that sql_id in dba_hist_sqlstat. Now I understand that not all SQL is captured by dba_hist_sqlstat but this SQL is responsible for 7% of total db activity and was executed 2300 times in the last 24hrs.
Is there another way to get executions stats for this SQL ID?
or
Can someone explain what are the rules based on which stats are stored in dba_hist_sqlstat?
Thank you all,