행위

오라클 11g 파라미터(aws)

DB CAFE

Dbcafe (토론 | 기여)님의 2019년 12월 19일 (목) 12:33 판
(차이) ← 이전 판 | 최신판 (차이) | 다음 판 → (차이)
thumb_up 추천메뉴 바로가기


AWWS 11g rtis-oracle-dev-parameter-group

Name
Values
Allowed values
Modifiable
Source
Apply type
Data type
Description

_add_col_optim_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	Allows new add column optimization

_allow_level_without_connect_by		TRUE, FALSE	true	engine-default	dynamic	boolean	_allow_level_without_connect_by

_always_semi_join		CHOOSE, OFF, NESTED_LOOPS, MERGE, HASH	true	engine-default	dynamic	string	_always_semi_join

aq_tm_processes		0-40	true	engine-default	dynamic	integer	number of AQ Time Managers to start

archive_lag_target	300	60, 120, 180, 240, 300	true	system	dynamic	integer	Maximum number of seconds of redos the standby could lose

audit_file_dest	/rdsdbdata/admin/{dbName}/adump		false	system	dynamic	string	Directory in which auditing files are to reside

audit_syslog_level			false	engine-default	static	string	Syslog facility and level

audit_sys_operations		TRUE, FALSE	true	engine-default	static	boolean	enable sys auditing

audit_trail		DB, OS, NONE, TRUE, FALSE, DB_EXTENDED, XML, EXTENDED	true	engine-default	static	list	enable system auditing

_awr_disabled_flush_tables			true	engine-default	dynamic	string	Disable flushing of specified AWR tables

_awr_mmon_deep_purge_all_expired		TRUE, FALSE	true	engine-default	dynamic	boolean	Allows deep purge to purge AWR data for all expired snapshots

background_core_dump		FULL, PARTIAL	true	engine-default	static	string	Core Size for Background Processes

background_dump_dest			false	engine-default	dynamic	string	Detached process dump directory

bitmap_merge_area_size		0-2199023255552	true	engine-default	static	integer	maximum memory allow for BITMAP MERGE

blank_trimming		TRUE, FALSE	true	engine-default	static	boolean	blank trimming semantics parameter

_bloom_filter_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	enables or disables bloom filter

_b_tree_bitmap_plans		TRUE, FALSE	true	engine-default	dynamic	boolean	_b_tree_bitmap_plans

buffer_pool_keep		0-2199023255552	true	engine-default	static	integer	Number of database blocks/latches in keep buffer pool

buffer_pool_recycle		0-2199023255552	true	engine-default	static	integer	Number of database blocks/latches in recycle buffer pool

circuits		0-3000	true	engine-default	dynamic	integer	max number of circuits

_cleanup_rollback_entries		0-2147483647	true	engine-default	static	integer	no. of undo entries to apply per transaction cleanup

_client_enable_auto_unregister		TRUE, FALSE	true	engine-default	static	boolean	enable automatic unregister after a send fails with timeout

client_result_cache_lag		0-60000	true	engine-default	static	integer	client result cache maximum lag in milliseconds

client_result_cache_size		0-2199023255552	true	engine-default	static	integer	client result cache max size in bytes

commit_logging		IMMEDIATE, BATCH	true	engine-default	dynamic	string	transaction commit log write behaviour

commit_point_strength		0-255	true	engine-default	static	integer	Bias this node has toward not preparing in a two-phase commit

commit_wait		NOWAIT, WAIT, FORCE_WAIT	true	engine-default	dynamic	string	transaction commit log wait behaviour

commit_write			false	engine-default	dynamic	string	transaction commit log write behaviour

compatible			true	engine-default	static	string	Database will be completely compatible with this software version

_complex_view_merging		TRUE, FALSE	true	engine-default	dynamic	boolean	enable complex view merging

_connect_by_use_union_all		OLD_PLAN_MODE, TRUE, FALSE	true	engine-default	dynamic	string	use union all for connect by

control_file_record_keep_time		0-365	true	engine-default	dynamic	integer	control file record keep time in days

control_files	/rdsdbdata/db/{dbName}_{DBUniqueNameSuffix}/controlfile/control-01.ctl		false	system	static	string	control file names list

control_management_pack_access		NONE	true	engine-default	dynamic	string	declares which manageability packs are enabled

core_dump_dest			false	engine-default	dynamic	string	Core dump directory

cpu_count		1-100	true	engine-default	dynamic	integer	number of CPUs for this instance

create_bitmap_area_size		0-2199023255552	true	engine-default	static	integer	size of create bitmap buffer for bitmap index

create_stored_outlines		TRUE, FALSE, category_name [NOOVERRIDE]	true	engine-default	dynamic	string	create stored outlines for DML statements

cursor_bind_capture_destination		OFF, MEMORY, MEMORY+DISK	true	engine-default	dynamic	string	Allowed destination for captured bind variables

_cursor_features_enabled		0-2147483647	true	engine-default	static	integer	_cursor_features_enabled

_cursor_obsolete_threshold		0-2147483647	true	engine-default	static	integer	_cursor_obsolete_threshold

cursor_sharing		FORCE, EXACT, SIMILAR	true	engine-default	dynamic	string	cursor sharing mode

cursor_space_for_time		TRUE, FALSE	true	engine-default	static	boolean	use more memory in order to get faster execution

db_16k_cache_size		0-2199023255552	true	engine-default	dynamic	integer	Size of cache for 16K buffers

db_2k_cache_size		0-2199023255552	true	engine-default	dynamic	integer	Size of cache for 2K buffers

db_32k_cache_size		0-2199023255552	true	engine-default	dynamic	integer	Size of cache for 32K buffers

db_4k_cache_size		0-2199023255552	true	engine-default	dynamic	integer	Size of cache for 4K buffers

db_8k_cache_size		0-2199023255552	false	engine-default	dynamic	integer	Size of cache for 8K buffers

db_block_buffers		0-32768	true	engine-default	static	integer	Number of database blocks cached in memory

db_block_checking	MEDIUM	FALSE, OFF, LOW, MEDIUM, TRUE, FULL	true	system	dynamic	string	header checking and data and index block checking

db_block_checksum		OFF, FALSE, TYPICAL, TRUE, FULL	true	engine-default	dynamic	string	store checksum in db blocks and check during reads

_db_block_prefetch_limit		0-2147483647	true	engine-default	dynamic	integer	Prefetch limit in blocks

_db_block_prefetch_quota		0-2147483647	true	engine-default	dynamic	integer	Prefetch quota as a percent of cache size

db_block_size		2048-32768	false	engine-default	static	integer	Size of database block in bytes

db_cache_advice		OFF, READY, ON	true	engine-default	dynamic	string	Buffer cache sizing advisory

db_cache_size		0-2199023255552	true	engine-default	dynamic	integer	Size of DEFAULT buffer pool for standard block size buffers

db_create_file_dest	/rdsdbdata/db		false	system	dynamic	string	default database location

db_create_online_log_dest_1			false	engine-default	dynamic	string	online log/controlfile destination #1

db_create_online_log_dest_2			false	engine-default	dynamic	string	online log/controlfile destination #2

db_create_online_log_dest_3			false	engine-default	dynamic	string	online log/controlfile destination #3

db_create_online_log_dest_4			false	engine-default	dynamic	string	online log/controlfile destination #4

db_create_online_log_dest_5			false	engine-default	dynamic	string	online log/controlfile destination #5

db_domain			true	engine-default	static	string	directory part of global database name stored with CREATE DATABASE

db_file_multiblock_read_count		0-1024	true	engine-default	dynamic	integer	db block to be read each IO

db_file_name_convert			false	engine-default	dynamic	string	datafile name convert patterns and strings for standby/clone db

_db_file_noncontig_mblock_read_count		0-2147483647	true	engine-default	static	integer	number of noncontiguous db blocks to be prefetched

db_files		200-20000	true	engine-default	static	integer	max allowable # db files

db_flashback_retention_target	1440	30-2147483647	true	user	dynamic	integer	Maximum Flashback Database log retention time in minutes.

db_keep_cache_size		0-2199023255552	true	engine-default	dynamic	integer	Size of KEEP buffer pool for standard block size buffers

db_lost_write_protect		NONE, TYPICAL, FULL	true	engine-default	dynamic	string	enable lost write detection

db_name	{dbName}		false	system	static	string	database name specified in CREATE DATABASE

db_recovery_file_dest		10485760-2147483647	false	engine-default	dynamic	string	default database recovery file location

db_recovery_file_dest_size	1073741824	1-18446744073709551614	true	system	dynamic	integer	database recovery files size limit

db_recycle_cache_size		0-2199023255552	true	engine-default	dynamic	integer	Size of RECYCLE buffer pool for standard block size buffers

db_securefile		NEVER, PERMITTED, ALWAYS, IGNORE, FORCE	true	engine-default	dynamic	string	permit securefile storage during lob creation

db_ultra_safe		OFF, DATA_ONLY, DATA_AND_INDEX	true	engine-default	static	string	Sets defaults for other parameters that control protection levels

db_unique_name	{dbName}_{DBUniqueNameSuffix}		false	system	static	string	Database Unique Name

db_unrecoverable_scn_tracking		TRUE, FALSE	false	engine-default	dynamic	boolean	Track nologging SCN in controlfile

dbwr_io_slaves		0-50	false	engine-default	static	integer	DBWR I/O slaves

db_writer_processes		1-36	true	engine-default	static	integer	number of background database writer processes to start

ddl_lock_timeout		0-1000000	true	engine-default	dynamic	integer	timeout to restrict the time that ddls wait for dml lock

deferred_segment_creation		TRUE, FALSE	true	engine-default	dynamic	boolean	defer segment creation to first insert

dg_broker_config_file1	/rdsdbdata/config/dr1{dbName}.dat		false	system	dynamic	string	data guard broker configuration file #1

dg_broker_config_file2	/rdsdbdata/config/dr2{dbName}.dat		false	system	dynamic	string	data guard broker configuration file #2

dg_broker_start		TRUE, FALSE	false	engine-default	dynamic	boolean	start Data Guard broker (DMON process)

diagnostic_dest	/rdsdbdata/log		false	system	dynamic	string	diagnostic base directory

_direct_read_decision_statistics_driven		TRUE, FALSE	true	engine-default	dynamic	boolean	enable direct read decision based on optimizer statistics

_disable_function_based_index		TRUE, FALSE	true	engine-default	dynamic	boolean	_disable_function_based_index

disk_asynch_io		TRUE, FALSE	false	engine-default	static	boolean	Use asynch I/O for random access devices

dispatchers			true	engine-default	dynamic	string	specifications of dispatchers

distributed_lock_timeout		1-2147483647	true	engine-default	static	integer	number of seconds a distributed transaction waits for a lock

dml_locks		0-2000000	true	engine-default	static	integer	dml locks - one for each table modified in a transaction

dst_upgrade_insert_conv		TRUE, FALSE	false	engine-default	dynamic	boolean	Enables/Disables internal conversions during DST upgrade

enable_ddl_logging		TRUE, FALSE	true	engine-default	dynamic	boolean	enable ddl logging

enable_goldengate_replication		TRUE, FALSE	true	engine-default	dynamic	boolean	Enable GoldenGate replication

_enable_shared_pool_durations		TRUE, FALSE	true	engine-default	static	boolean	_enable_shared_pool_durations

_enable_space_preallocation		0-2147483647	true	engine-default	dynamic	integer	enable space pre-allocation

event			false	engine-default	static	string	debug event control - default null string

fal_client			false	engine-default	dynamic	string	FAL client

fal_server			false	engine-default	dynamic	string	


_fast_full_scan_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_fast_full_scan_enabled

fast_start_mttr_target		0-3600	false	engine-default	dynamic	integer	MTTR target in seconds

fast_start_parallel_rollback		FALSE, LOW, HIGH	true	engine-default	dynamic	string	max number of parallel recovery slaves that may be used

filesystemio_options	setall	ASYNCH, DIRECTIO, SETALL, NONE	false	system	static	string	IO operations on filesystem files

_first_k_rows_dynamic_proration		TRUE, FALSE	true	engine-default	dynamic	boolean	enable the use of dynamic proration of join cardinalities

_fix_control			true	engine-default	static	string	_fix_control

fixed_date			false	engine-default	dynamic	string	fixed SYSDATE value

_gby_hash_aggregation_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_gby_hash_aggregation_enabled

_gc_defer_time		0-100	false	engine-default	dynamic	integer	_gc_defer_time

gcs_server_processes		0-36	false	engine-default	static	integer	gcs_server_processes

global_context_pool_size			true	engine-default	static	string	Global Application Context Pool Size in Bytes

global_names		TRUE, FALSE	true	engine-default	dynamic	boolean	enforce that database links have same name as remote database

_grant_secure_role		TRUE, FALSE	true	engine-default	static	boolean	Disallow granting of SR to NSR

hash_area_size		0-2147483647	true	engine-default	static	integer	size of in-memory hash work area

_hash_join_enabled		TRUE, FALSE	true	engine-default	static	boolean	enable/disable hash join

hs_autoregister		TRUE, FALSE	true	engine-default	dynamic	boolean	enable automatic server DD updates in HS agent self-registration

ifile			false	engine-default	static	string	include file in init.ora

_ignore_desc_in_index		TRUE, FALSE	true	engine-default	dynamic	boolean	_ignore_desc_in_index

_index_join_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	Enable the use of index joins

_index_partition_large_extents		TRUE, FALSE	true	engine-default	dynamic	boolean	Enables large extent allocation for partitioned indices

instance_name			false	engine-default	static	string	instance name supported by the instance

java_jit_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	Java VM JIT enabled

java_max_sessionspace_size		0-2147483647	true	engine-default	static	integer	max allowed size in bytes of a Java sessionspace

java_pool_size		0-17179869184	true	engine-default	dynamic	integer	size in bytes of java pool

java_soft_sessionspace_limit		0-2147483647	true	engine-default	static	integer	warning limit on size in bytes of a Java sessionspace

job_queue_processes		0-1000	true	engine-default	dynamic	integer	maximum number of job queue slave processes

_keep_remote_column_size		TRUE, FALSE	true	engine-default	static	boolean	remote column size does not get modified

_kgl_hot_object_copies		0-2147483647	true	engine-default	static	integer	Number of copies for the hot object

_ktb_debug_flags		0-2147483647	true	engine-default	dynamic	integer	ktb-layer debug flags

large_pool_size		0-68719476736	true	engine-default	dynamic	integer	size in bytes of large pool

ldap_directory_access		NONE, PASSWORD, SSL	false	engine-default	dynamic	string	RDBMSs LDAP access option

ldap_directory_sysauth		YES, NO	false	engine-default	static	string	OID usage parameter

license_max_sessions		0-1000000	true	engine-default	dynamic	integer	maximum number of non-system user sessions allowed

license_max_users		0-1000000	true	engine-default	dynamic	integer	maximum number of named users that can be created in the database

license_sessions_warning		0-1000000	true	engine-default	dynamic	integer	warning level for number of non-system user sessions

_like_with_bind_as_equality		TRUE, FALSE	true	engine-default	dynamic	boolean	_like_with_bind_as_equality

listener_networks			false	engine-default	dynamic	string	listener registration networks

local_listener			false	engine-default	dynamic	string	local listener

lock_name_space			true	engine-default	static	string	lock name space used for generating lock names for standby/clone database

lock_sga		TRUE, FALSE	false	engine-default	static	boolean	Lock entire SGA in physical memory

log_archive_config			false	engine-default	dynamic	string	log archive config parameter

log_archive_dest			false	engine-default	dynamic	string	archival destination text string

log_archive_dest_1	location="/rdsdbdata/db/{dbName}_{DBUniqueNameSuffix}/arch/redolog", valid_for=(ALL_LOGFILES,ALL_ROLES)		false	system	dynamic	string	archival destination #1 text string

log_archive_dest_state_1		ENABLE, DEFER, RESET, ALTERNATE	false	engine-default	dynamic	string	archival destination #1 state text string

log_archive_format	-%s-%t-%r.arc		false	system	static	string	archival destination format

log_archive_local_first		TRUE, FALSE	false	engine-default	dynamic	boolean	Establish EXPEDITE attribute default value

log_archive_max_processes		1-30	true	engine-default	dynamic	integer	maximum number of active ARCH processes

log_archive_min_succeed_dest		1-10	true	engine-default	dynamic	integer	minimum number of archive destinations that must succeed

log_archive_trace		0-65535	true	engine-default	dynamic	integer	Establish archivelog operation tracing level

log_buffer		2097152-268435456	true	engine-default	static	integer	redo circular buffer size

log_checkpoint_interval		0-2147483647	true	engine-default	dynamic	integer	# redo blocks checkpoint threshold

log_checkpoints_to_alert		TRUE, FALSE	true	engine-default	dynamic	boolean	log checkpoint begin/end to alert file

log_checkpoint_timeout		0-2147483647	true	engine-default	dynamic	integer	Maximum time interval between checkpoints in seconds

log_file_name_convert			false	engine-default	static	string	logfile name convert patterns and strings for standby/clone db

max_dispatchers		0-30	true	engine-default	dynamic	integer	max number of dispatchers

max_dump_file_size			true	engine-default	dynamic	string	Maximum size (in bytes) of dump file

max_enabled_roles		1-148	false	engine-default	static	integer	max number of roles a user can have enabled

max_shared_servers		0-2000	true	engine-default	dynamic	integer	max number of shared servers

memory_max_target	IF({DBInstanceClassHugePagesDefault}, 0, {DBInstanceClassMemory*3/4})	0, 159383552-2199023255552	true	system	static	integer	Max size for Memory Target

memory_target	IF({DBInstanceClassHugePagesDefault}, 0, {DBInstanceClassMemory*3/4})	0, 159383552-2199023255552	true	system	dynamic	integer	Target size of Oracle SGA and PGA memory

_mutex_wait_scheme		0-255	true	engine-default	dynamic	integer	Mutex wait scheme

_mutex_wait_time		0-65535	true	engine-default	dynamic	integer	Mutex wait time

_mv_refresh_use_hash_sj		TRUE, FALSE	true	engine-default	dynamic	boolean	Use hash_sj hint in queries

_mv_refresh_use_stats		TRUE, FALSE	true	engine-default	dynamic	boolean	Pass cardinality hints to refresh queries

nls_date_format			true	engine-default	static	string	nls_date_format

nls_length_semantics		BYTE, CHAR	true	engine-default	dynamic	string	create columns using byte or char semantics by default

nls_nchar_conv_excp		FALSE, TRUE	true	engine-default	dynamic	boolean	NLS raise an exception instead of allowing implicit conversion

nls_time_format			true	engine-default	static	string	nls_time_format

nls_timestamp_format			true	engine-default	static	string	nls_timestamp_format

nls_timestamp_tz_format			true	engine-default	static	string	nls_timestamp_tz_format

nls_time_tz_format			true	engine-default	static	string	nls_time_tz_format

_no_or_expansion		TRUE, FALSE	true	engine-default	dynamic	boolean	_no_or_expansion

o7_dictionary_accessibility		TRUE, FALSE	false	engine-default	static	boolean	Version 7 Dictionary Accessibility Support

object_cache_max_size_percent		0-68719476736	true	engine-default	dynamic	integer	percentage of maximum size over optimal of the user sessions object cache

object_cache_optimal_size		0-68719476736	true	engine-default	dynamic	integer	optimal size of the user sessions object cache in bytes

_object_statistics		TRUE, FALSE	true	engine-default	dynamic	boolean	enable the object level statistics collection

olap_page_pool_size		0-2147483648	true	engine-default	dynamic	integer	size of the olap page pool in bytes

open_cursors	300	0-65535	true	system	dynamic	integer	max # cursors per session

open_links		0-255	true	engine-default	static	integer	max # open links per session

open_links_per_instance		0-4294967295	true	engine-default	static	integer	max # open links per instance

_optimizer_adaptive_cursor_sharing		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_adaptive_cursor_sharing

_optimizer_ads_use_result_cache		TRUE, FALSE	true	engine-default	dynamic	boolean	Use result cache for ADS queries

_optimizer_autostats_job		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_autostats_job

optimizer_capture_sql_plan_baselines		TRUE, FALSE	true	engine-default	dynamic	boolean	automatic capture of SQL plan baselines for repeatable statements

_optimizer_cartesian_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_cartesian_enabled

_optimizer_connect_by_cost_based		TRUE, FALSE	true	engine-default	dynamic	boolean	use cost-based transformation for connect by

_optimizer_cost_based_transformation		EXHAUSTIVE, ITERATIVE, LINEAR, OFF, ON, TWO_PASS	true	engine-default	dynamic	string	_optimizer_cost_based_transformation

optimizer_dynamic_sampling		0-11	true	engine-default	dynamic	integer	optimizer dynamic sampling

_optimizer_enhanced_filter_push		TRUE, FALSE	true	engine-default	dynamic	boolean	push filters before trying cost-based query transformation

_optimizer_extended_cursor_sharing		UDO, NONE	true	engine-default	dynamic	string	_optimizer_extended_cursor_sharing

_optimizer_extended_cursor_sharing_rel		SIMPLE, NONE	true	engine-default	dynamic	string	_optimizer_extended_cursor_sharing_rel

optimizer_features_enable		11.2.0.4.1, 11.2.0.4, 11.2.0.3, 11.2.0.2, 11.2.0.1, 11.1.0.7, 11.1.0.6, 10.2.0.5, 10.2.0.4, 10.2.0.3, 10.2.0.2, 10.2.0.1, 10.1.0.5, 10.1.0.4, 10.1.0.3, 10.1.0, 9.2.0.8, 9.2.0, 9.0.1, 9.0.0, 8.1.7, 8.1.6, 8.1.5, 8.1.4, 8.1.3, 8.1.0, 8.0.7, 8.0.6, 8.0.5, 8.0.4, 8.0.3, 8.0.0	true	engine-default	dynamic	string	optimizer plan compatibility parameter

optimizer_index_caching		0-100	true	engine-default	dynamic	integer	optimizer percent index caching

optimizer_index_cost_adj		1-10000	true	engine-default	dynamic	integer	optimizer index cost adjustment

_optimizer_invalidation_period		0-2147483647	true	engine-default	dynamic	integer	time window for invalidation of cursors of analyzed objects

_optimizer_join_elimination_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_join_elimination_enabled

_optimizer_join_sel_sanity_check		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_join_sel_sanity_check

_optimizer_max_permutations		4-80000	true	engine-default	dynamic	integer	_optimizer_max_permutations

_optimizer_mjc_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_mjc_enabled

optimizer_mode		RULE, CHOOSE, ALL_ROWS, FIRST_ROWS, FIRST_ROWS_1, FIRST_ROWS_10, FIRST_ROWS_100, FIRST_ROWS_1000	true	engine-default	dynamic	string	optimizer mode


_optimizer_null_aware_antijoin		TRUE, FALSE	true	engine-default	dynamic	boolean	null-aware antijoin parameter

_optimizer_order_by_elimination_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	Eliminates order bys from views before query transformation

_optimizer_push_pred_cost_based		TRUE, FALSE	true	engine-default	dynamic	boolean	use cost-based query transformation for push pred optimization

optimizer_secure_view_merging		TRUE, FALSE	true	engine-default	dynamic	boolean	optimizer secure view merging and predicate pushdown/movearound

_optimizer_skip_scan_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	Enable/disable index skip scan

_optimizer_sortmerge_join_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_sortmerge_join_enabled

_optimizer_use_feedback		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_use_feedback

optimizer_use_invisible_indexes		TRUE, FALSE	true	engine-default	dynamic	boolean	Usage of invisible indexes (TRUE/FALSE)

optimizer_use_pending_statistics		TRUE, FALSE	true	engine-default	dynamic	boolean	Control whether to use optimizer pending statistics

optimizer_use_sql_plan_baselines		TRUE, FALSE	true	engine-default	dynamic	boolean	use of SQL plan baselines for captured sql statements

_optim_peek_user_binds		TRUE, FALSE	true	engine-default	dynamic	boolean	_optim_peek_user_binds

_orph_cln_interval		0-2147483647	true	engine-default	static	integer	qmon periodic interval for removed subscriber messages cleanup

os_authent_prefix			false	engine-default	static	string	prefix for auto-logon accounts

os_roles		TRUE, FALSE	false	engine-default	static	boolean	retrieve roles from the operating system

parallel_adaptive_multi_user		TRUE, FALSE	true	engine-default	dynamic	boolean	enable adaptive setting of degree for multiple user streams

parallel_automatic_tuning		TRUE, FALSE	true	engine-default	static	boolean	enable intelligent defaults for parallel execution parameters

parallel_degree_limit		CPU, IO, <integer>	true	engine-default	dynamic	string	limit placed on degree of parallelism

parallel_degree_policy		MANUAL, LIMITED, AUTO	true	engine-default	dynamic	string	policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)

parallel_execution_message_size		2148-32768	true	engine-default	static	integer	message buffer size for parallel execution

parallel_force_local		TRUE, FALSE	true	engine-default	dynamic	boolean	force single instance execution

parallel_max_servers		0-3600	true	engine-default	dynamic	integer	maximum parallel query servers per instance

parallel_min_servers		0-2000	true	engine-default	dynamic	integer	minimum parallel query servers per instance

parallel_min_time_threshold		AUTO, <integer>	true	engine-default	dynamic	string	threshold above which a plan is a candidate for parallelization (in seconds)

parallel_servers_target		0-2000	true	engine-default	dynamic	integer	instance target in terms of number of parallel servers

parallel_threads_per_cpu		0-16	true	engine-default	dynamic	integer	number of parallel execution threads per CPU

_partition_large_extents		TRUE, FALSE	true	engine-default	dynamic	boolean	Enables large extent allocation for partitioned tables

_partition_view_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_partition_view_enabled

permit_92_wrap_format		TRUE, FALSE	true	engine-default	static	boolean	allow 9.2 or older wrap format in PL/SQL

pga_aggregate_target	IF({DBInstanceClassHugePagesDefault}, {DBInstanceClassMemory*1/8}, 0)	0-2199023255552	true	engine-default	dynamic	integer	Target size for the aggregate PGA memory consumed by the instance

plscope_settings		IDENTIFIERS:NONE, IDENTIFIERS:ALL	true	engine-default	dynamic	string	plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data.

plsql_ccflags			true	engine-default	dynamic	string	PL/SQL ccflags

plsql_code_type		INTERPRETED, NATIVE	true	engine-default	dynamic	string	PL/SQL code-type

plsql_debug		TRUE, FALSE	true	engine-default	dynamic	boolean	PL/SQL debug

plsql_optimize_level		0-3	true	engine-default	dynamic	integer	PL/SQL optimize level

plsql_v2_compatibility		TRUE, FALSE	true	engine-default	dynamic	boolean	PL/SQL version 2.x compatibility flag

plsql_warnings			true	engine-default	dynamic	string	PL/SQL compiler warnings settings

_pred_move_around		TRUE, FALSE	true	engine-default	dynamic	boolean	enables predicate move-around

pre_page_sga		TRUE, FALSE	true	engine-default	static	boolean	pre-page sga for process

processes	2000	80-20000	true	user	static	integer	user processes

_push_join_predicate		TRUE, FALSE	true	engine-default	dynamic	boolean	enable pushing join predicate inside a view

_px_use_large_pool		TRUE, FALSE	true	engine-default	static	boolean	Use Large Pool as source of PX buffers

query_rewrite_enabled		FALSE, TRUE, FORCE	true	engine-default	dynamic	string	allow rewrite of queries using materialized views if enabled

query_rewrite_integrity		ENFORCED, TRUSTED, STALE_TOLERATED	true	engine-default	dynamic	string	perform rewrite using materialized views with desired integrity

rdbms_server_dn			false	engine-default	static	string	RDBMSs Distinguished Name

read_only_open_delayed		TRUE, FALSE	false	engine-default	static	boolean	if TRUE delay opening of read only files until first access

recovery_parallelism			false	engine-default	static	integer	number of server processes to use for parallel recovery

recyclebin	ON	ON, OFF	true	user	static	string	recyclebin processing

redo_transport_user			false	engine-default	dynamic	string	Data Guard transport user when using password file

remote_dependencies_mode		TIMESTAMP, SIGNATURE	true	engine-default	dynamic	string	remote-procedure-call dependencies mode parameter

remote_listener			false	engine-default	dynamic	string	remote listener

remote_login_passwordfile		SHARED, EXCLUSIVE, NONE	false	engine-default	static	string	password file usage parameter

remote_os_authent		TRUE, FALSE	false	engine-default	static	boolean	allow non-secure remote clients to use auto-logon accounts

remote_os_roles		TRUE, FALSE	false	engine-default	static	boolean	allow non-secure remote clients to use os roles

replication_dependency_tracking		TRUE, FALSE	true	engine-default	static	boolean	tracking dependency for Replication parallel propagation

resource_limit		TRUE, FALSE	true	engine-default	dynamic	boolean	master switch for resource limit

resource_manager_cpu_allocation		0-20	true	engine-default	dynamic	integer	Resource Manager CPU allocation

resource_manager_plan			false	engine-default	dynamic	string	resource mgr top plan

result_cache_max_result		0-100	true	engine-default	dynamic	integer	maximum result size as percent of cache size

result_cache_max_size		0-68719476736	true	engine-default	dynamic	integer	maximum amount of memory to be used by the cache

result_cache_mode		MANUAL, FORCE	true	engine-default	dynamic	string	result cache operator usage mode

result_cache_remote_expiration		0-10000	true	engine-default	dynamic	integer	maximum life time (min) for any result using a remote object

resumable_timeout		0-2147483647	true	engine-default	dynamic	integer	set resumable_timeout

_rollback_segment_count		0-2147483647	true	engine-default	dynamic	integer	Number of undo segments

rollback_segments			false	engine-default	static	string	undo segment list

sec_case_sensitive_logon		TRUE, FALSE	true	engine-default	dynamic	boolean	case sensitive password enabled for logon

sec_max_failed_login_attempts		1-100000	true	engine-default	static	integer	maximum number of failed login attempts on a connection

sec_protocol_error_further_action			true	engine-default	dynamic	string	TTC protocol error continue action

sec_protocol_error_trace_action		NONE, TRACE, LOG, ALERT	true	engine-default	dynamic	string	TTC protocol error action

sec_return_server_release_banner		TRUE, FALSE	true	engine-default	static	boolean	whether the server retruns the complete version information

_securefiles_concurrency_estimate		1-50	true	engine-default	static	integer	securefiles concurrency estimate

_serial_direct_read		FALSE, TRUE, NEVER, AUTO, ALWAYS	true	engine-default	dynamic	string	enable direct read in serial

serial_reuse		DISABLE, ALL, SELECT, DML, PLSQL, FORCE	true	engine-default	static	string	reuse the frame segments

service_names			false	engine-default	dynamic	string	service names supported by the instance

session_cached_cursors		0-65535	true	engine-default	static	integer	number of session cursors to cache

session_max_open_files		1-50	true	engine-default	static	integer	maximum number of open files allowed per session

sessions	2000	100-65532	true	user	static	integer	user and system sessions

sga_max_size		0-2199023255552	true	engine-default	static	integer	max total SGA size

sga_target	IF({DBInstanceClassHugePagesDefault}, {DBInstanceClassMemory*3/4}, 0)	0-2199023255552	true	engine-default	dynamic	integer	Target size of SGA

shadow_core_dump		NONE, FULL, PARTIAL	true	engine-default	static	string	Core Size for Shadow Processes

shared_memory_address			false	engine-default	static	integer	SGA starting address (low order 32-bits on 64-bit platforms)

shared_pool_reserved_size		5000-2147483648	true	engine-default	static	integer	size in bytes of reserved area of shared pool

shared_pool_size		0-68719476736	true	engine-default	dynamic	integer	size in bytes of shared pool

shared_servers		0-2000	true	engine-default	dynamic	integer	number of shared servers to start up

shared_server_sessions		0-20000	true	engine-default	dynamic	integer	max number of shared server sessions

skip_unusable_indexes		TRUE, FALSE	true	engine-default	dynamic	boolean	skip unusable indexes if set to TRUE

_slave_mapping_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	enable slave mapping when TRUE

_small_table_threshold		0-2147483647	true	engine-default	static	integer	lower threshold level of table size for direct reads

smtp_out_server			true	engine-default	dynamic	string	utl_smtp server and port configuration parameter

_smu_debug_mode		0-2147483647	true	engine-default	dynamic	integer	<debug-flag> - set debug event for testing SMU operations

sort_area_retained_size		0-2199023255552	true	engine-default	dynamic	integer	size of in-memory sort work area retained between fetch calls

sort_area_size		0-2147483647	true	engine-default	static	integer	size of in-memory sort work area

_sort_elimination_cost_ratio		0-2147483647	true	engine-default	dynamic	integer	_sort_elimination_cost_ratio

spfile	/rdsdbbin/oracle/dbs/spfile{dbName}.ora		false	system	dynamic	string	server parameter file

sql92_security		TRUE, FALSE	true	engine-default	static	boolean	require select privilege for searched update/delete

_sqlexec_progression_cost		0-2147483647	true	engine-default	dynamic	integer	_sqlexec_progression_cost

_sqlmon_max_planlines		0-2147483647	true	engine-default	dynamic	integer	Number of plan lines beyond which a plan cannot be monitored

sqlnetora.default_sdu_size		512-65535	true	engine-default	dynamic	integer	The session data unit (SDU) size, in bytes. The SDU is the amount of data that is put in a buffer and sent across the network at one time.

sqlnetora.diag_adr_enabled		ON, OFF	true	engine-default	dynamic	string	Enables or disables ADR tracing. ON specifies that ADR file tracing is used. OFF specifies that non-ADR file tracing is used.

sqlnetora.recv_buf_size		8192-268435456	true	engine-default	dynamic	integer	The buffer space limit for receive operations of sessions, supported by TCP/IP, TCP/IP with SSL, and SDP protocols.

sqlnetora.send_buf_size		8192-268435456	true	engine-default	dynamic	integer	The buffer space limit for send operations of sessions, supported by the TCP/IP, TCP/IP with SSL, and SDP protocols.

sqlnetora.sqlnet.expire_time		0-1440	true	engine-default	dynamic	integer	Time interval, in minutes, to send a check to verify that client/server connections are active.

sqlnetora.sqlnet.inbound_connect_timeout		0, 10-7200	true	engine-default	dynamic	integer	Time, in seconds, for a client to connect with the database server and provide the necessary authentication information.

sqlnetora.sqlnet.outbound_connect_timeout		0, 10-7200	true	engine-default	dynamic	integer	Time, in seconds, for a client to establish an Oracle Net connection to the database instance.

sqlnetora.sqlnet.recv_timeout		0, 10-7200	true	engine-default	dynamic	integer	The buffer space limit for receive operations of sessions, supported by TCP/IP, TCP/IP with SSL, and SDP protocols.

sqlnetora.sqlnet.send_timeout		0, 10-7200	true	engine-default	dynamic	integer	Time, in seconds, for a database server to complete a send operation to clients after establishing a connection.

sqlnetora.tcp.connect_timeout		0, 10-7200	true	engine-default	dynamic	integer	Time, in seconds, for a client to establish a TCP connection to the database server.

sqlnetora.trace_level_server		0, 4, 10, 16, OFF, USER, ADMIN, SUPPORT	true	engine-default	dynamic	string	For non-ADR tracing, turns server tracing on at a specified level or turns it off.

sql_trace		TRUE, FALSE	true	engine-default	dynamic	boolean	enable SQL trace

sqltune_category			true	engine-default	dynamic	string	Category qualifier for applying hintsets

standby_archive_dest			false	engine-default	dynamic	string	standby database archivelog destination text string

standby_file_management	AUTO	AUTO, MANUAL	false	system	dynamic	string	if auto then files are created/dropped automatically on standby

star_transformation_enabled		FALSE, TRUE, TEMP_DISABLE	true	engine-default	dynamic	string	enable the use of star transformation

statistics_level		BASIC, TYPICAL, ALL	true	engine-default	dynamic	string	statistics level

streams_pool_size		0-2199023255552	true	engine-default	dynamic	integer	size in bytes of the streams pool

thread			false	engine-default	dynamic	integer	Redo thread to mount

timed_os_statistics		0-1000000	true	engine-default	dynamic	integer	internal os statistic gathering interval in seconds

timed_statistics		TRUE, FALSE	true	engine-default	static	boolean	maintain internal timing statistics

trace_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	enable in memory tracing

_trace_files_public		TRUE, FALSE	true	engine-default	static	boolean	Create publicly accessible trace files

transactions		4-4294967296	true	engine-default	static	integer	max. number of concurrent active transactions

transactions_per_rollback_segment		1-10000	true	engine-default	static	integer	number of active transactions per rollback segment

_undo_autotune		TRUE, FALSE	true	engine-default	dynamic	boolean	enable auto tuning of undo_retention

undo_management		MANUAL, AUTO	false	engine-default	static	string	instance runs in SMU mode if TRUE, else in RBU mode

undo_retention		0-2147483647	true	engine-default	dynamic	integer	undo retention in seconds

undo_tablespace	UNDO_T1		true	system	dynamic	string	use/switch undo tablespace

_unnest_subquery		TRUE, FALSE	true	engine-default	dynamic	boolean	_unnest_subquery

_use_adaptive_log_file_sync		POLLING_ONLY, FALSE, TRUE	true	engine-default	dynamic	string	Adaptively switch between post/wait and polling

use_indirect_data_buffers		TRUE, FALSE	false	engine-default	static	boolean	Enable indirect data buffers (very large SGA on 32-bit platforms)

use_large_pages	{DBInstanceClassHugePagesDefault}	ONLY, FALSE, {DBInstanceClassHugePagesDefault}	true	engine-default	static	string	Use hugepages if available (FALSE, ONLY, or DB Parameter Formula {DBInstanceClassHugePagesDefault})

user_dump_dest			false	engine-default	dynamic	string	User process dump directory

utl_file_dir			false	engine-default	static	string	utl_file accessible directories list

workarea_size_policy		MANUAL, AUTO	true	engine-default	dynamic	string	policy used to size SQL working areas (MANUAL/AUTO)

xml_db_events		ENABLE, DISABLE	false	engine-default	dynamic	string	are XML DB events enabled