행위

오라클 12c 파라미터(aws)

DB CAFE

thumb_up 추천메뉴 바로가기


rtis-oracle-dev12c-parameter-group

Name
Values
Allowed values
Modifiable
Source
Apply type
Data type
Description

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

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

utl_file_dir			false	engine-default	static	string	utl_file accessible directories list

user_dump_dest			false	engine-default	dynamic	string	User process dump directory

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

use_dedicated_broker		TRUE, FALSE	false	engine-default	static	boolean	determines how dedicated servers are spawned when using threaded_execution

unified_audit_sga_queue_size		1048576-31457280	true	engine-default	static	integer	specify the size of SGA queue for unified auditing.

undo_tablespace	UNDO_T1		true	system	dynamic	string	use/switch undo tablespace

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

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

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

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

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

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

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

threaded_execution		TRUE, FALSE	false	engine-default	static	boolean	enables or disables multithreaded model

thread			false	engine-default	dynamic	integer	Redo thread to mount

temp_undo_enabled		TRUE, FALSE	true	system	static	string	determine whether transactions within a particular session can have a temporary undo log.

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

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

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

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

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

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

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.

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.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.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.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.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.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.allowed_logon_version_server		8, 9, 10, 11, 12, 12a	false	engine-default	dynamic	string	To set the minimum authentication protocol allowed when connecting to Oracle Database instances.

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.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.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.default_sdu_size		512-2097152	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.

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

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

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

spatial_vector_acceleration		TRUE, FALSE	false	engine-default	dynamic	boolean	enables or disables spatial vector acceleration

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

rollback_segments			false	engine-default	static	string	undo segment list

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

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

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

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

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

resource_manager_plan			false	engine-default	dynamic	string	resource mgr top plan

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

resource_manage_goldengate		TRUE, FALSE	true	engine-default	dynamic	boolean	determines whether Oracle GoldenGate apply processes in the database are resource managed

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

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

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

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

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

remote_listener			false	engine-default	dynamic	string	remote listener

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

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

recyclebin	ON	ON, OFF	true	user	static	string	recyclebin processing

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

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

rdbms_server_dn			false	engine-default	static	string	RDBMSs Distinguished Name

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

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

processor_group_name			false	engine-default	static	string	specifies the name of the processor group that the instance should run in

processes	2000	80-20000	true	user	static	integer	user processes

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

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

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

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

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

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

plsql_ccflags			true	engine-default	dynamic	string	PL/SQL ccflags

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.

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

pga_aggregate_limit		0-2199023255552	true	engine-default	static	integer	specifies a limit on the aggregate PGA memory consumed by the instance

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

pdb_file_name_convert			false	engine-default	dynamic	string	maps names of existing files to new file names when creating a pluggable database

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

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

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

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

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

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

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

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

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

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

outbound_dblink_protocols			false	engine-default	dynamic	string	specifies the network protocols allowed for communicating for outbound database links in the database

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

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

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

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

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

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

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_index_cost_adj		1-10000	true	engine-default	dynamic	integer	optimizer index cost adjustment

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

optimizer_features_enable		12.2.0.1.1, 12.2.0.1, 12.1.0.2, 12.1.0.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_dynamic_sampling		0-11	true	engine-default	dynamic	integer	optimizer dynamic sampling

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

optimizer_adaptive_statistics		TRUE, FALSE	true	engine-default	dynamic	boolean	controls adaptive statistics

optimizer_adaptive_reporting_only		TRUE, FALSE	true	system	static	string	control reporting-only mode for adaptive optimizatons

optimizer_adaptive_plans		TRUE, FALSE	true	engine-default	dynamic	boolean	controls adaptive plans

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

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

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

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

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

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

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

noncdb_compatible		TRUE, FALSE	false	system	static	string	enables you to get behavior similar to a non-CDB when issuing SQL commands inside a PDB in a CDB.

nls_timestamp_tz_format			true	engine-default	static	string	nls_timestamp_tz_format

nls_timestamp_format			true	engine-default	static	string	nls_timestamp_format

nls_time_tz_format			true	engine-default	static	string	nls_time_tz_format

nls_time_format			true	engine-default	static	string	nls_time_format

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

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

nls_date_format			true	engine-default	static	string	NLS Date Format

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

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

max_string_size	STANDARD	STANDARD, EXTENDED	true	system	dynamic	string	control the maximum size of VARCHAR2, NVARCHAR2, and RAW.

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

max_idle_time		0-2147483647	true	engine-default	dynamic	integer	specifies the maximum number of minutes that a session can be idle

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

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

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

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_checkpoint_interval		0-2147483647	true	engine-default	dynamic	integer	# redo blocks checkpoint threshold

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

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

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

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

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

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

log_archive_dest_state_1		ENABLE, DEFER, RESET, ALTERNATE	false	engine-default	dynamic	string	archival destination #1 state 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			false	engine-default	dynamic	string	archival destination text string

log_archive_config			false	engine-default	dynamic	string	log archive config parameter

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

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

local_listener	(address=(protocol=tcp)(host=)(port={EndPointPort}))		false	engine-default	dynamic	string	local listener

listener_networks			false	engine-default	dynamic	string	listener registration networks

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

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

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

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

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

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

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

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

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

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

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

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

inmemory_virtual_columns		ENABLE, MANUAL, DISABLE	true	engine-default	dynamic	string	controls which user-defined virtual columns are stored as In-Memory virtual columns (IM columns)

inmemory_expressions_usage		STATIC_ONLY, DYNAMIC_ONLY, ENABLE, DISABLE	true	engine-default	dynamic	string	controls which In-Memory Expressions (IM expressions) are populated into the In-Memory Column Store (IM column store) and are available for queries

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

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

heat_map	OFF	ON, OFF	true	system	static	string	enable database to track read and write access of all segments, as well as modification of database blocks, due to DMLs and DDLs.

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

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

gcs_server_processes		0-36	false	engine-default	static	integer	gcs_server_processes

fixed_date			false	engine-default	dynamic	string	fixed SYSDATE value

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

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

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

fal_server			false	engine-default	dynamic	string	FAL server list

fal_client			false	engine-default	dynamic	string	FAL client

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

enable_pluggable_database	FALSE	TRUE, FALSE	false	engine-default	static	string	bootstrap initialization parameter to create a CDB.

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

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

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

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

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

dispatchers			true	engine-default	dynamic	string	specifications of dispatchers

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

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

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

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

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

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

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

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

dbfips_140	FALSE	TRUE, FALSE	true	engine-default	static	boolean	Enable use of crypographic libraries in FIPS mode, public

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

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

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

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

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

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

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

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

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

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

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

db_index_compression_inheritance		TABLESPACE, TABLE, ALL, NONE	true	engine-default	dynamic	string	options for table or tablespace level compression inheritance

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

db_big_table_cache_percent_target		0-90	true	engine-default	dynamic	integer	target percentage of the buffer cache used for automatic big table caching

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

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

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

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

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

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

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

cursor_invalidation		DEFERRED, IMMEDIATE	true	engine-default	dynamic	string	controls whether deferred cursor invalidation or immediate cursor invalidation is used for DDL statements by default

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

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

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

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

core_dump_dest			false	engine-default	dynamic	string	Core dump directory

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

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

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

connection_brokers			false	engine-default	dynamic	string	used to specify connection broker types, numbers of connections, and maximum number of connections per broker

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

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

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

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

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

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

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

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

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

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

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

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

background_dump_dest			false	engine-default	dynamic	string	Detached process dump directory

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

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

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_file_dest	/rdsdbdata/admin/{dbName}/adump		false	system	dynamic	string	Directory in which auditing files are to reside

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

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

approx_for_percentile		NONE, PERCENTILE_CONT, PERCENTILE_CONT DETERMINISTIC, PERCENTILE_DISC, PERCENTILE_DISC DETERMINISTIC, ALL, ALL DETERMINISTIC	true	engine-default	dynamic	string	converts exact percentile functions to their approximate percentile function counterparts

approx_for_count_distinct		TRUE, FALSE	true	engine-default	dynamic	boolean	automatically replaces COUNT (DISTINCT expr) queries with APPROX_COUNT_DISTINCT queries

approx_for_aggregation		TRUE, FALSE	true	engine-default	dynamic	boolean	replaces exact query processing for aggregation queries with approximate query processing

allow_global_dblinks		TRUE, FALSE	true	engine-default	dynamic	boolean	specifies whether LDAP lookup for database links is allowed for the database

_use_single_log_writer		ADAPTIVE, FALSE, TRUE	true	engine-default	static	string	_use_single_log_writer

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

_unnest_subquery		TRUE, FALSE	true	engine-default	dynamic	boolean	_unnest_subquery

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

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

_suppress_identifiers_on_dupkey		TRUE, FALSE	true	engine-default	dynamic	boolean	supress owner index name err msg

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

_sqlexec_progression_cost		0-2147483647	true	engine-default	dynamic	integer	_sqlexec_progression_cost

_sql_plan_directive_mgmt_control		0-65535	true	engine-default	dynamic	integer	controls internal SQL Plan Directive management activities

_sort_elimination_cost_ratio		0-2147483647	true	engine-default	dynamic	integer	_sort_elimination_cost_ratio

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

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

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

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

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

_rowsets_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	enable/disable rowsets

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

_report_capture_cycle_time		0-2147483647	true	engine-default	dynamic	integer	_report_capture_cycle_time

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

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

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


_partition_view_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_partition_view_enabled

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

_orph_cln_interval		60-86400	true	engine-default	static	integer	qmon periodic interval for removed subscriber messages cleanup

_optimizer_use_feedback		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_use_feedback

_optimizer_sortmerge_join_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_sortmerge_join_enabled

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

_optimizer_reduce_groupby_key		TRUE, FALSE	true	engine-default	dynamic	boolean	group-by key reduction

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

_optimizer_partial_join_eval		TRUE, FALSE	true	engine-default	dynamic	boolean	Partial join evaluation parameter

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

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

_optimizer_mjc_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_mjc_enabled

_optimizer_max_permutations		4-80000	true	engine-default	dynamic	integer	_optimizer_max_permutations

_optimizer_join_sel_sanity_check		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_join_sel_sanity_check

_optimizer_join_elimination_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_join_elimination_enabled

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

_optimizer_gather_feedback		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_gather_feedback

_optimizer_extended_cursor_sharing_rel		SIMPLE, NONE	true	engine-default	dynamic	string	_optimizer_extended_cursor_sharing_rel

_optimizer_extended_cursor_sharing		UDO, NONE	true	engine-default	dynamic	string	_optimizer_extended_cursor_sharing

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

_optimizer_dsdir_usage_control		0-126	true	engine-default	dynamic	integer	controls optimizer usage of dynamic sampling directives

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

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

_optimizer_cbqt_or_expansion		TWO_PASS, GREEDY, LINEAR, ON, OFF	true	engine-default	dynamic	string	enables cost based OR expansion

_optimizer_cartesian_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_cartesian_enabled

_optimizer_batch_table_access_by_rowid		TRUE, FALSE	true	engine-default	dynamic	boolean	enable table access by ROWID IO batching

_optimizer_autostats_job		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_autostats_job

_optimizer_aggr_groupby_elim		TRUE, FALSE	true	engine-default	dynamic	boolean	group-by and aggregation elimination

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

_optimizer_adaptive_cursor_sharing		TRUE, FALSE	true	engine-default	dynamic	boolean	_optimizer_adaptive_cursor_sharing

_optim_peek_user_binds		TRUE, FALSE	true	engine-default	dynamic	boolean	_optim_peek_user_binds

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

_no_or_expansion		TRUE, FALSE	true	engine-default	dynamic	boolean	_no_or_expansion

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

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

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

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

_like_with_bind_as_equality		TRUE, FALSE	true	engine-default	dynamic	boolean	_like_with_bind_as_equality

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

_kks_obsolete_dump_threshold		0-8	true	engine-default	dynamic	integer	_kks_obsolete_dump_threshold

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

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

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

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

_ignore_desc_in_index		TRUE, FALSE	true	engine-default	dynamic	boolean	_ignore_desc_in_index

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

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

_gc_defer_time		0-100	false	engine-default	dynamic	integer	_gc_defer_time

_gby_hash_aggregation_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_gby_hash_aggregation_enabled

_fix_control			true	engine-default	static	string	_fix_control

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

_fast_full_scan_enabled		TRUE, FALSE	true	engine-default	dynamic	boolean	_fast_full_scan_enabled

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

_enable_shared_pool_durations		TRUE, FALSE	true	engine-default	static	boolean	Hidden parameter to work around bug 13914613

_enable_secure_sub_role		TRUE, FALSE	true	engine-default	static	boolean	Disallow enabling of secure sub roles

_disable_function_based_index		TRUE, FALSE	true	engine-default	dynamic	boolean	_disable_function_based_index

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

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

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

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

_cursor_obsolete_threshold		0-2147483647	true	engine-default	static	integer	_cursor_obsolete_threshold

_cursor_features_enabled		0-2147483647	true	engine-default	static	integer	_cursor_features_enabled

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

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

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

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

_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

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

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

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

_allow_level_without_connect_by		TRUE, FALSE	true	engine-default	dynamic	boolean	_allow_level_without_connect_by

_allow_insert_with_update_check		TRUE, FALSE	true	engine-default	dynamic	boolean	Allow INSERT as statement_types when update_check is FALSE

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