getting closer.... with auto sql tuning w/o em

Ok... So thanks to Brian P. and Dan Morgan, I am a bit further in my quest of trying to see the tuning results from addm/advisor through sqlplus w/ out EM. However, I am not stuck again... any help would be appreciated.

I ran the addmrpt and awrrpt, from which I see the SQL ID's for particular expensive sql statements. I now try to pass those sql id's to the dbms_sqltune.create_tuning_task api and am getting error message:

   Invalid SQL Statement

All I'm doing is something like this from sqlplus:

exec dbms_sqltune.create_tuning_task(sql_id=>'id', plan_has_value=>null,scope=>'COMPREHENSIVE', time_limit=>60, task_name=>'tester',description=>'description');

(docs ref:
<http://download-east.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_sqltun.htm#1001021>)

Thanks for your insight. Received on Fri Aug 04 2006 - 14:22:39 CDT