Home » RDBMS Server » Performance Tuning » DBMS_OUTLINE to override HINTS [Merged] (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi)
DBMS_OUTLINE to override HINTS [Merged] [message #432031] Fri, 20 November 2009 09:32 Go to next message
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.

Re: DBMS_OUTLINE to override HINTS [Merged] [message #432041 is a reply to message #432031] Fri, 20 November 2009 11:29 Go to previous messageGo to next message
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.
Re: DBMS_OUTLINE to override HINTS [Merged] [message #432049 is a reply to message #432041] Fri, 20 November 2009 12:27 Go to previous messageGo to next message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
Thank You Raj for the useful information.
Re: DBMS_OUTLINE to override HINTS [Merged] [message #433455 is a reply to message #432031] Wed, 02 December 2009 07:20 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member

And yes, you could use OUTLINEs or SQL Profiler to obviate/replace the original hints.
Shocked
Previous Topic: Nologging Feature in Archivelog mode : strange Results
Next Topic: How to identify table need resequencing.
Goto Forum:
  


Current Time: Sat Sep 24 16:21:17 CDT 2016

Total time taken to generate the page: 0.09738 seconds