EMCC 中 运用SQL 优化的建议

1. 性能中心 关于SQL的执行信息

 

2. 优化SQL：

 

 

------整个过程SQL 实现----------------------

DECLARE
  my_task_name VARCHAR2(30);
  my_sqltext CLOB;
BEGIN
  my_sqltext := 'SELECT * '   ||
                'FROM sales ' || 'WHERE prod_id = 10 AND ' || 'cust_id = 100 ';

  my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
                           sql_text => my_sqltext,
                           user_name => 'SH',
                           scope => 'COMPREHENSIVE',
                           time_limit => 60,
                           task_name => 'TEST_sql_tuning_task',
                           description => 'Task to tune a query on a specified PRODUCT');
END;

Or us sqlid:

SET SERVEROUTPUT ON
declare
stmt_task VARCHAR2(40);
begin
stmt_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id => '5etrekix123');
DBMS_OUTPUT.put_line('task_id: ' || stmt_task );
end;
/

SET SERVEROUTPUT ON
declare
stmt_task VARCHAR2(40);
begin
stmt_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id => '7jaaum7xx');
DBMS_OUTPUT.put_line('task_id: ' || stmt_task );
end;
/

begin 
  dbms_sqltune.Execute_tuning_task (task_name => '任务_4943');
end;

select * from dba_advisor_log order by task_id desc
 
select dbms_sqltune.report_tuning_task('任务_4943') from dual;