How To Know If A SQL Profile Is Used

A quick and easy way to know if a SQL Profile is being used is through the following query.

 
SELECT 
    SQL_ID,
    SQL_PROFILE,
    SQL_TEXT
FROM V$SQL
WHERE SQL_PROFILE IS NOT NULL;

This query will give us all the statements that are in the library cache and are currently using a SQL Profile in its execution plan.

Remember that a problem with the SQL profileS is that they can stop used by the optimizer without notice.

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