1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. OPTIMIZER_IGNORE_HINTS

1.239 OPTIMIZER_IGNORE_HINTS

OPTIMIZER_IGNORE_HINTS enables embedded hints to be ignored.

Property Description

Parameter type

Boolean

Default value

FALSE

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

true | false

Basic

No

Oracle RAC

Different values can be set on different instances.

When this parameter is set to TRUE, the optimizer ignores embedded hints.

The default value is FALSE. When this parameter’s value is FALSE, the optimizer does not ignore embedded hints.