Akimeu wrote:
> 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.
found my issue... i had to put it into a pl/sql block.
Received on Fri Aug 04 2006 - 15:23:10 CDT
