In a previous post explain a quick and easy way to see if a profile is used in the execution plan of a SQL statement, of course, there are many more and provide more information, here it is just a super functional method. East same procedure is valid to see if the SQL is working out an outline. Run the following query;
SELECT SQL_ID, OUTLINE_CATEGORY, SQL_TEXT FROM V$SQL WHERE OUTLINE_CATEGORY IS NOT NULL;
Here we have two cases;
- Returns no rows, this indicates that there is no outline, at this time, into the library cache.
- Returns n rows, these SQL statements that are using Outline in their execution plan.
HTH – Antonio NAVARRO