Search SQLs in Database Management

You can now search for the SQL statements currently running on a Managed Database or available in retained AWR data. A dynamic search allows you to find a specific SQL statement based on filter attributes such as the parsing schema name, SQL text, and SQL ID. On searching for a SQL statement, you can perform additional tasks such as downloading the SQL active report and adding the SQL statement to a new or existing SQL tuning set.

For more information, see Search SQLs.