Hello Community,
Please let me know if there is any proper view/method from which we can get long running queries from history between a mentioned time period.
As far as i explored, v$session_longops is for current long running session and dba_hist_active_sess_history does not provides end time/ time elapsed for the query execution.
Kindly help me in finding the same.
Thanks