Oracle 11gR2：40几个初始化参数的有效枚举值list

 

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