오라클 12c 파라미터(aws)
DB CAFE
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
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