sql - Why SQL_PROFILE not showing recommendations? -
i trying run sql tuning advisor sqlplus. following below steps create
to create tuning task using sql_id:
declare l_sql_tune_task_id varchar2(100); begin l_sql_tune_task_id := dbms_sqltune.create_tuning_task ( sql_id => '19v5guvsgcd1v', scope => dbms_sqltune.scope_comprehensive, time_limit => 60, task_name => '19v5guvsgcd1v_tuning_task', description => 'tuning task statement 19v5guvsgcd1v.'); dbms_output.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); end; /
to execute tuning:
exec dbms_sqltune.execute_tuning_task(task_name => '19v5guvsgcd1v_tuning_task');
to check report:
set pagesize 10000 set linesize 20000 select dbms_sqltune.report_tuning_task('19v5guvsgcd1v_tuning_task') recommendations dual; set pagesize 24
when run create tuning task block , execute tuning task successful completed, when try see recommendations see blank report. when run sql tuning advisor (sql tuning advisor icon) sql developer, coming 2 recommendations. why not able see through when run in sqlplus.
add set long:
sql> set long 2000000000
Comments
Post a Comment