Akimeu wrote:
> 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.
And here I was ready to tell you that 'id' is not a sql_id. ;-)
Also look at the DBMS_XPLAN.DISPLAY_CURSOR pipelined table function.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Aug 04 2006 - 18:47:48 CDT
