ASH REPORT “** 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.


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.

Leave a Reply