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.
Answer:A
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.