V$SESSION_FIX_CONTROL

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)

Note:

1.

SELECT * FROM V$SESSION_FIX_CONTROL where session_id = 1480;

SESSION_ID	BUGNO	VALUE	DESCRIPTION	OPTIMIZER_ FEATURE_ ENABLE	EVENT	IS_ DEFAULT
1480	4611850	0	do not clobber predicate during first-k row estimate phase	10.2.0.2	0	1
1480	4663804	0	use smallest table as first table in join card. initial ordering	10.2.0.2	0	1
1480	4663698	0	for cached NL table set tab_cost_io to zero	10.2.0.2	0	1
1480	4545833	0	no selectivity for transitive inequality predicates	10.2.0.2	0	1
1480	3499674	0	enable tiny index improvements: consider small indexes as cachhe		10111	1
1480	4584065	0	do not disable cartesian products if ORDERED hint is used	10.2.0.2	0	1
1480	4602374	0	optimize top-level predicate chain	10.2.0.2	0	1
1480	4569940	0	Use index heuristic for join pred being pushed	10.1.0.5	0	1
1480	4631959	0	Refine criteria for additional phase in JPPD	10.2.0.2	0	1
1480	4519340	0	Generate distinct view in SU if candidate for JPPD	10.2.0.2	0	1
1480	4550003	1	do not consider no sel predicates in join selectivity sanity	10.1.0	0	1
1480	4488689	0	ignore IS NOT NULL predicate as an index filter	10.2.0.2	38077	1
1480	3118776	1	Check for obj# for named view estimated card	9.2.8	38079	1
1480	4519016	1	Pick view card from view qb instead of parent qb	9.2.8	38081	1
1480	4487253	1	make NL comparable to HJ	9.2.8	38081	1
1480	4556762	0	min # of join permutations for starting table, new initial order	10.2.0.2	0	1
1480	4728348	0	consider mjc if equi-joined pred is dropped in kkoipt	10.2.0.2	0	1
1480	4723244	0	CPU cost estimation for unique access	10.2.0.2	0	1
1480	4554846	0	tbl$or$idx$part$num() predicate causing peformance problems	10.2.0.2	0	1
1480	4175830	0	generate transitive predicates across anti join predicates	10.2.0.1	0	1
1480	4722900	0	kkoidc: add SI caching for index branch blocks	10.2.0.1	0	1
1480	4711525	1	Enable code optimization for bitmap access path	9.2.8	38083	1
1480	4273361	0	convert range scan to unique access if possible	10.2.0.2	0	1
1480	4483240	1	Favor unique index in case of cost tie	9.2.8	0	1
1480	4904838	1	allow index skip scan with no index keys	9.2.8	0	1
1480	5084239	0	try for subqueries before forcing in star trans with FACT hint	10.2.0.2	0	1
1480	5449488	0	In bitmap costing use real sel for transitive negated predicates	10.2.0.2	0	1

Oracle data dictionary views

Oracle dynamic performance views