In this post I would like to share a quick way of identifying the timed-out SQLs from a SQL tuning task report.
Usually you would do that from EM Express (12c) or Cloud control. But, having an access to EM/Cloud control is not always possible and you might be stuck in identifying the correct statements.
Here is an example, the portion of the SQL Auto Tuning Task report which shows how many statements have timed-out.
I’ve extracted the following SQL from the EM Express – SQL Tuning Advisor report (page).
The original statement is much bigger, but the following portion should be good enough to give you the statements which have timed-out.
All you need to do is to specify the execution name. It has been tested on 11.2 and 12.1.