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