OPT_PARAM Hint

Applies to:
Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 10.2.0.3 – Release: 10.2 to 10.2
Information in this document applies to any platform.
Goal
This article is explains the new optimizer hint “OPT_PARAM” introduced in 10g R2.
Solution
“OPT_PARAM” is a new optimizer hint introduced in 10g Release 2. This hint behaves the same way as
setting a parameter (e.g, using alter session) except that the effect is for the statement only. The hint only works for optimizer parameters. Global parameters such as optimizer_features_enable are not covered but optimizer_features_enable specifically has its own hint:

Comments

Hi SlavikThis has come up on Twitter (and in private emlais before as well). UKOUG last tweet on the matter .@alexgorbachev – We are aware of the issues with the current system and are in the processing of sourcing a new tool for next year. You probably know this but the error you got (and the page extension!) only tells you the front end technology. You have to get database error message to know it’s not an Oracle DB. Unfortunately I’ve had one of those as well.