Friday, 23 December 2022

How to find the minimum and maximum execution time for a sql_id based on plan hash value

select sql_plan_hash_value, COUNT(*), MIN(sql_exec_start), MAX(sql_exec_start)
from   dba_hist_active_sess_history
where  sql_id = <sql_id>

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)