问题:
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,’TASK1’);
END; /
BEGIN
dbms_advisor.set_task_parameter(’TASK1’,’ANALYSIS_SCOPE’,’ALL’); dbms_advisor.set_task_parameter(’TASK1’,’MODE’,’COMPREHENSIVE’);
END;
/
BEGIN
dbms_advisor.execute_task(’TASK1’);
dbms_output.put_line(dbms_advisor.get_task_script(’TASK1’));
END;
/
The blocks of code execute successfully;however,you do not get the required outcome.
What could be the reason?()
A . A template needs to be associated with the task.
B . A workload needs to be associated with the task.
C . The partial or complete workload scope needs to be associated with the task.
D . The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,’TASK1’);
END; /
BEGIN
dbms_advisor.set_task_parameter(’TASK1’,’ANALYSIS_SCOPE’,’ALL’); dbms_advisor.set_task_parameter(’TASK1’,’MODE’,’COMPREHENSIVE’);
END;
/
BEGIN
dbms_advisor.execute_task(’TASK1’);
dbms_output.put_line(dbms_advisor.get_task_script(’TASK1’));
END;
/
The blocks of code execute successfully;however,you do not get the required outcome.
What could be the reason?()
● 参考解析
本题暂无解析
相关内容
相关标签