OraFAQ Forum: Performance Tuning » DBMS_OUTLINE to override HINTS [Merged]

Home » RDBMS Server » Performance Tuning » DBMS_OUTLINE to override HINTS [Merged] (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS_OUTLINE to override HINTS [Merged] [message #432031]

Fri, 20 November 2009 09:32

spur230
Messages: 25
Registered: April 2009
Location: US

Junior Member

Hi Experts,

I need to override a HINTS in front end application code. If I do not remove hints from code itself , is there any way I can override it.

I was suggested to use SQL profile that comes in 10g. My question is it SQL profile extra cost option.

Can I use DBMS_OUTLINE or DBMS_SQLTUNE? I would greatly appreciate if someone could be me pointers for this matter.

Report message to a moderator

Re: DBMS_OUTLINE to override HINTS [Merged] [message #432041 is a reply to message #432031]

Fri, 20 November 2009 11:29

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

I am not sure this is what you want. Check this link.

http://tonguc.wordpress.com/2008/01/23/_optimizer_ignore_hints-please-optimizer-ignore-all-hints-inside-my-applications/

Regards

Raj

P.S : Aware of the disclaimer mentioned in the site. It's an underscore parameter. Also there is an known bug with outline in 10.2.0.4 with multibyte characterset. Outline won't work and it is fixed in 11.1 onwards.

Report message to a moderator