How would you implement this?

You used SQL Tuning Advisor for a long-running SQL statement that suggested a SQL profile
which can be used by the query subsequently for better execution plan. View the Exhibit. But you
want certain user sessions not to use this SQL profile for their queries. How would you implement this?

You used SQL Tuning Advisor for a long-running SQL statement that suggested a SQL profile
which can be used by the query subsequently for better execution plan. View the Exhibit. But you
want certain user sessions not to use this SQL profile for their queries. How would you implement this?

A.
Alter the SQL profile to change the category of the SQL profile.

B.
Set the OPTIMIZER_USE_PENDING_STATISTICS to TRUE the desired sessions.

C.
Use database resource manager to prevent the use of the SQL profile by these user sessions.

D.
Use database resource manager to preUse the resource management feature in profiles of
these users to prevent the use of the SQL profile.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

SQLTUNE_CATAGORY is the way to filter out some sessions when using sql profile

So A is correct