V$SESSION_FIX_CONTROL displays information about Fix Control (enabled/disabled) for the current session.
| Column | Datatype | Description |
|---|---|---|
SESSION_ID |
NUMBER |
Session identifier (can be used to join this view with V$SESSION) |
BUGNO |
NUMBER |
Bug number (as fix control identifier) |
VALUE |
NUMBER |
Current value set for the fix control |
SQL_FEATURE |
VARCHAR2(64) |
Feature control ID |
DESCRIPTION |
VARCHAR2(64) |
Description of the fix control |
OPTIMIZER_FEATURE_ENABLE |
VARCHAR2(25) |
Version on (and after) which the fix is enabled by default |
EVENT |
NUMBER |
Event formerly used to control the fix |
IS_DEFAULT |
NUMBER |
Indicates whether the current value is the same as the default (1) or not (0) |