My Oracle Support Banner

How to Identify if a Parameter Setting is Being Run via OPT_PARAM Hint or Alter Session Parameter Change for Sql Plan Outlines (Doc ID 2432644.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.


This document lists situations which will cause sql plan outlines to show OPT_PARM outline hints.



OPT_PARAM hint was introduced in Oracle version 10g release 2 onwards.

The OPT_PARAM hint lets you set an initialization parameter for the duration of the current query only.

SELECT /*+ OPT_PARAM('star_transformation_enabled' 'true') */ *
FROM ... ;

Parameter values that are strings are enclosed in single quotation marks and numeric parameter values are specified without quotation marks.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.