OCP-1Z0-053-V12.02-35题
35.You want the Automatic SQL Tuning process to stop accepting and implementing the recommendedSQL profiles automatically. Which action would you perform to achieve this?
A. Edit the automatic maintenance window group configuration.
B. Set the CURSOR_SHARING parameter to EXACT for the database instance.
C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.
D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
Answer: C
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF94849
if want to stop accepting and implementing the recommended SQL profiles automatically
set ACCEPT_SQL_PROFILES to FALSE.
ACCEPT_SQL_PROFILE
Specifies whether to accept SQL profiles automatically.
To configure automatic SQL tuning:
[*] Start SQL*Plus, and connect to the database with DBA privileges (or connect as SYS if you plan to run EXECUTE_AUTO_TUNING_TASK).
[*] Run the DBMS_AUTO_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER procedure.
The following example configures the automatic SQL tuning task to automatically accept SQL profiles recommended by SQL Tuning Advisor:
BEGINDBMS_AUTO_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER( parameter => 'ACCEPT_SQL_PROFILES', value => 'TRUE');END;/
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]