오라클 11g 파라미터(aws)
DB CAFE
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
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