Oracle
1Z0-054 · Question #193
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…
The correct answer is A. Alter the SQL profile to change the category of the SQL profile. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AAlter the SQL profile to change the category of the SQL profile.
- BSet the OPTIMIZER_USE_PENDING_STATISTICS to TRUE the desired sessions.
- CUse database resource manager to prevent the use of the SQL profile by these user sessions.
- DUse database resource manager to preUse the resource management feature in profiles of these
How the community answered
(43 responses)- A74% (32)
- B5% (2)
- C14% (6)
- D7% (3)
Community Discussion
No community discussion yet for this question.