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 AUGUST 14, 2018

Applies to:

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

Goal

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

 

Note:

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.

 

Solution

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
Goal
Solution


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