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.

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.

Leave a Reply