Re: alter sql profile to force matching
- From: joshuasingham <joshuasingham@xxxxxxxxx>
- To: Dion Cho <ukja.dion@xxxxxxxxx>
- Date: Tue, 27 Apr 2010 16:19:20 +0800
Hi Dion,
thanks for the reply seem to be a confict in the documents any does anybody
know how to alter the profile to force match with other methods
Thanks
joshua
On Tue, Apr 27, 2010 at 3:52 PM, Dion Cho <ukja.dion@xxxxxxxxx> wrote:
>
> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sqltun.htm#i1008294
>
> Seems that you can only alter following attributes - STATUS, NAME,
> DESCRIPTION, CATEGORY.
> <http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sqltun.htm#i1008294>
> ================================
> Dion Cho - Oracle Performance Storyteller
>
> http://dioncho.wordpress.com (english)
> http://ukja.tistory.com (korean)
> http://dioncho.blogspot.com (japanese)
> http://ask.ex-em.com (q&a)
> ================================
>
>
> 2010/4/27 joshuasingham <joshuasingham@xxxxxxxxx>
>
> Hi all,
>>
>> I have been trying to alter my sql profile to force match but was unable
>> to get it to work according to the document link below it say it is
>> possible but I keep getting the error below any help is appreciated
>>
>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_tune.htm#CHDDABDE
>>
>> SQL> BEGIN
>> 2 DBMS_SQLTUNE.ALTER_SQL_PROFILE(
>> 3 name => 'SYS_SQLPROF_0146a31c146a31c5',
>> 4 attribute_name => 'FORCE_MATCH',
>> 5 value => 'YES');
>> 6 END;
>> 7 /
>> BEGIN
>> *
>> ERROR at line 1:
>> ORA-13835: invalid attribute name specified
>> ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 7132
>> ORA-06512: at "SYS.DBMS_SQLTUNE", line 5603
>> ORA-06512: at line 2
>>
>
>
Other related posts:
