Oracle OCP 1Z0 053 Q40(DBMS_ADVISOR.QUICK_TUNE)
40.Evaluate the following code:
SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000);
SQL>BEGIN :sql_stmt := 'SELECT COUNT(*) FROM customers
WHERE cust_state_province =''CA''';
:task_name := 'MY_QUICKTUNE_TASK';
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
END;
What is the outcome of this block of code?
A. It creates a task and workload, and executes the task.
B. It creates a task and workload but does not execute the task.
C. It produces an error because a template has not been created.
D. It produces an error because the SQL Tuning Set has not been created.
Answer: A
如下程式碼可以執行:
declare
v_sql_stmt varchar2(4000);
v_task_name varchar2(200);
BEGIN
v_sql_stmt := 'SELECT COUNT(*) FROM emp WHERE ename =''CLARK''';
v_task_name := 'MY_QUICKTUNE_TASK';
dbms_advisor.quick_tune(dbms_advisor.sqlaccess_advisor,
v_task_name,
v_sql_stmt);
END;
通過DBMS_ADVISOR.get_task_script獲取結果。
結果是個CLOB:
Rem SQL Access Advisor: Version 11.2.0.4.0 - Production
Rem
Rem Username: SCOTT
Rem Task: MY_QUICKTUNE_TASK
Rem Execution date:
Rem
CREATE INDEX "SCOTT"."EMP_IDX$$_04E40000"
ON "SCOTT"."EMP"
("ENAME")
COMPUTE STATISTICS;
SQL> declare
2 v_sql_stmt varchar2(4000);
3 v_task_name varchar2(200);
4 BEGIN
5 v_sql_stmt := 'SELECT COUNT(*) FROM emp WHERE ename =''CLARK''';
6 v_task_name := 'MY_QUICKTUNE_TASK2';
7 dbms_advisor.quick_tune(dbms_advisor.sqlaccess_advisor,
8 v_task_name,
9 v_sql_stmt);
10 END;
11 /
PL/SQL procedure successfully completed.
SQL> SELECT DBMS_ADVISOR.get_task_script('MY_QUICKTUNE_TASK2') AS script
2 FROM dual;
SCRIPT
--------------------------------------------------------------------------------
Rem SQL Access Advisor: Version 11.2.0.4.0 - Production
Rem
Rem Username:
SQL>
SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000);
SQL>BEGIN :sql_stmt := 'SELECT COUNT(*) FROM customers
WHERE cust_state_province =''CA''';
:task_name := 'MY_QUICKTUNE_TASK';
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
END;
What is the outcome of this block of code?
A. It creates a task and workload, and executes the task.
B. It creates a task and workload but does not execute the task.
C. It produces an error because a template has not been created.
D. It produces an error because the SQL Tuning Set has not been created.
Answer: A
如下程式碼可以執行:
declare
v_sql_stmt varchar2(4000);
v_task_name varchar2(200);
BEGIN
v_sql_stmt := 'SELECT COUNT(*) FROM emp WHERE ename =''CLARK''';
v_task_name := 'MY_QUICKTUNE_TASK';
dbms_advisor.quick_tune(dbms_advisor.sqlaccess_advisor,
v_task_name,
v_sql_stmt);
END;
通過DBMS_ADVISOR.get_task_script獲取結果。
結果是個CLOB:
Rem SQL Access Advisor: Version 11.2.0.4.0 - Production
Rem
Rem Username: SCOTT
Rem Task: MY_QUICKTUNE_TASK
Rem Execution date:
Rem
CREATE INDEX "SCOTT"."EMP_IDX$$_04E40000"
ON "SCOTT"."EMP"
("ENAME")
COMPUTE STATISTICS;
SQL> declare
2 v_sql_stmt varchar2(4000);
3 v_task_name varchar2(200);
4 BEGIN
5 v_sql_stmt := 'SELECT COUNT(*) FROM emp WHERE ename =''CLARK''';
6 v_task_name := 'MY_QUICKTUNE_TASK2';
7 dbms_advisor.quick_tune(dbms_advisor.sqlaccess_advisor,
8 v_task_name,
9 v_sql_stmt);
10 END;
11 /
PL/SQL procedure successfully completed.
SQL> SELECT DBMS_ADVISOR.get_task_script('MY_QUICKTUNE_TASK2') AS script
2 FROM dual;
SCRIPT
--------------------------------------------------------------------------------
Rem SQL Access Advisor: Version 11.2.0.4.0 - Production
Rem
Rem Username:
SQL>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2075005/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle
- Oracle OCP 1Z0 053 Q28(INCREMENTAL)OracleREM
- Oracle OCP 1Z0 053 Q332Oracle
- Oracle OCP 1Z0 053 Q269Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle OCP 1Z0 053 Q344(V$SESSION)OracleSession
- Oracle OCP 1Z0 053 Q558(V$BACKUP)Oracle
- Oracle OCP 1Z0 053 Q427(Transportable Tablespace)Oracle
- Oracle OCP 1Z0 053 Q182(RMAN)Oracle
- Oracle OCP 1Z0 053 Q428(transport database)OracleDatabase
- Oracle OCP 1Z0 053 Q458(Globalization NLSRTL)Oracle
- Oracle OCP 1Z0 053 Q465(NLS Parameters)Oracle
- Oracle OCP 1Z0 053 Q21(RMAN Duplicate)Oracle
- Oracle OCP 1Z0 053 Q600(RMAN BACKUP)Oracle
- Oracle OCP 1Z0 053 Q114Oracle
- Oracle OCP 1Z0 053 Q700(RMAN Duplicate)Oracle
- Oracle OCP 1Z0 053 Q223Oracle
- Oracle OCP 1Z0 053 Q703(Rman Backup)Oracle