Hi,
11.2.0.3 oracle
We have etl routines which run every day one if execution of a pl/sql procedure which in turn runs several other sql inclduing refresh of mviews.
Notice there is a data dictionary object called dba_hist_active_sess_history but this only has sqlids in it and has info about blocking sessions etc.
If could find the sqlid associated with this then could prove the session it was blocked by.
Also ability to find sqlid associated with execution of a particular pl/sql procedure on a given day in past would be of general use to us.
Thanks