How To Know If A Outline Is Used

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;

  1. Returns no rows, this indicates that there is no outline, at this time, into the library cache.
  2. Returns n rows, these SQL statements that are using Outline in their execution plan.

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s