ASH REPORT SHOWS “** Row Source Not Available **”
Whenever in ASH report, there is a section called Top SQL with Top Row Sources
There is a column “Row Source” and under that there are sql_id’s for which no data for row source available.
Reason:
After research, it is due to cursor which executed the SQL is not being closed during the collection of samples into ASH and a granular level data is not captured between the snapshots.