List of valid enumerated values of Oracle 11gr2: 40 initialization parameters

 

Name	Ordinal	Value	Isdefault
Audit_trail	1	DB
	2	OS
	3	None
	4	True
	5	False
	6	Db_extended
	7	XML
	8	Extended
Background_core_dump	1	Full
	2	Partial
Cell_offload_compaction	1	Low
	2	Medium
	3	High
	4	Adaptive	True
Cell_offload_plan_display	1	Never
	2	Always
	3	Auto	True
Cell_partition_large_extents	1	Default	True
	2	True
	3	Always
Control_management_pack_access	1	None
	2	Diagnostic
	3	Diagnostic + Tuning	True
Cursor_sharing	1	Force
	2	Exact	True
	3	Similar
Db_block_checking	1	False	True
	2	Off
	3	Low
	4	Medium
	5	True
	6	Full
Db_block_checksum	1	Off
	2	False
	3	Typical	True
	4	True
	5	Full
Db_cache_advice	1	Off	True
	2	Ready
	3	On
Db_lost_write_protect	1	None	True
	2	Typical
	3	Full
Db_securefile	1	Never
	2	Permitted	True
	3	Always
	4	Ignore
	5	Force
Db_ultra_safe	1	Off	True
	2	Data_only
	3	Data_and_index
Fast_start_parallel_rollback	1	False
	2	Low	True
	3	High
Filesystemio_options	1	Asynch
	2	Directio
	3	Setall
	4	None
Instance_type	1	RDBMS	True
	2	ASM
Ldap_directory_access	1	None	True
	2	Password
	3	SSL
Ldap_directory_sysauth	1	Yes
	2	No
Log_archive_dest_state_x	1	Enable
	2	Defer
	3	Reset
	4	Alternate
Nls_comp	1	Binary	True
	2	Linguistic
	3	ANSI
Nls_length_semantics	1	Byte	True
	2	Char
Nls_nchar_conv_excp	1	False	True
	2	True
Optimizer_features_enable	1	8.0.0
	2	8.0.3
	3	8.0.4
	4	8.0.5
	5	8.0.6
	6	8.0.7
	7	8.1.0
	8	8.1.3
	9	8.1.4
	10	8.1.5
	11	8.1.6
	12	8.1.7
	13	9.0.0
	14	9.0.1
	15	9.2.0
	16	9.2.0.8
	17	10.1.0
	18	10.1.0.3
	19	10.1.0.4
	20	10.1.0.5
	21	10.2.0.1
	22	10.2.0.2
	23	10.2.0.3
	24	10.2.0.4
	25	10.2.0.5
	26	11.1.0.6
	27	11.1.0.7
	28	11.2.0.1	True
	29	11.2.0.1.1
Optimizer_mode	1	Rule
	2	Choose
	3	All_rows
	4	First_rows
	5	First_rows_1
	6	First_rows_10
	7	First_rows_100
	8	First_rows_1000
Parallel_degree_policy	1	Manual	True
	2	Limited
	3	Auto
Plscope_settings	1	Identifiers: None	True
	2	Identifiers: All
Plsql_code_type	1	Interpreted	True
	2	Native
Query_rewrite_enabled	1	False
	2	True
	3	Force
Query_rewrite_integrity	1	Enforced
	2	Trusted
	3	Stale_tolerated
Recyclebin	1	On
	2	Off
Remote_dependencies_mode	1	Timestamp
	2	Signature
Remote_login_passwordfile	1	Shared
	2	Exclusive
	3	None
Result_cache_mode	1	Auto
	2	Manual	True
	3	Force
Sec_protocol_error_trace_action	1	None
	2	Trace	True
	3	Log
	4	Alert
Serial_reuse	1	Disable
	2	All
	3	Select
	4	DML
	5	PLSQL
	6	Force
Shadow_core_dump	1	None
	2	Full
	3	Partial
Standby_file_management	1	Auto
	2	Manual	True
Star_transformation_enabled	1	False	True
	2	True
	3	Temp_disable
Statistics_level	1	Basic
	2	Typical	True
	3	All
Workarea_size_policy	1	Manual
	2	Auto	True
Xml_db_events	1	Enable
	2	Disable