다른 명령
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