1.225 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.

Note:

This parameter is available starting with Oracle Database 18c.