Amazon RDSのパラメータグループのパラメータの変更可否
Amazon RDSのパラメータグループの各パラメータは、AWS マネージメントコンソールにログインして確認可能ですが、本日時点(2018/12/13)での主なパラメータグループを貼り付けておきます。以下のAWS CLIとjq、columnコマンドを使って抽出しています。mysql 5.7, postgresql 9.5, oracle ee 12.1のdefaultのパラメータグループについて取得できたものを載せています。正確な値については、AWSマネージメントコンソールにログイン、あるいはAWS CLIやAWS SDKを使って確認します。
aws rds describe-db-parameters --db-parameter-group-name default.mysql5.7 \ | jq -r '.Parameters[] | [.ParameterName, .IsModifiable, .ApplyMethod] \ | @tsv' | column -t
上記コマンドを実行して得られた結果は以下です。Parameter NameとIsModifiable, ApplyMethodのみ表示しています。
default.mysql5.7
IsModifiableが変更可能かどうか？、ApplyMethodが変更の適用タイミングです。
Parameter Name IsModifiable ApplyMethod allow-suspicious-udfs false pending-reboot auto_generate_certs false pending-reboot auto_increment_increment true pending-reboot auto_increment_offset true pending-reboot autocommit true pending-reboot automatic_sp_privileges true pending-reboot avoid_temporal_upgrade true pending-reboot back_log true pending-reboot basedir false pending-reboot binlog_cache_size true pending-reboot binlog_checksum true pending-reboot binlog_error_action true pending-reboot binlog_format true pending-reboot binlog_group_commit_sync_delay true pending-reboot binlog_group_commit_sync_no_delay_count true pending-reboot binlog_gtid_simple_recovery true pending-reboot binlog_max_flush_queue_time true pending-reboot binlog_order_commits true pending-reboot binlog_row_image true pending-reboot binlog_rows_query_log_events true pending-reboot binlog_stmt_cache_size true pending-reboot block_encryption_mode true pending-reboot bulk_insert_buffer_size true pending-reboot character-set-client-handshake true pending-reboot character_set_client true pending-reboot character_set_connection true pending-reboot character_set_database true pending-reboot character_set_filesystem true pending-reboot character_set_results true pending-reboot character_set_server true pending-reboot check_proxy_users true pending-reboot collation_connection true pending-reboot collation_server true pending-reboot completion_type true pending-reboot concurrent_insert true pending-reboot connect_timeout true pending-reboot core-file false pending-reboot datadir false pending-reboot default_authentication_plugin false pending-reboot default_password_lifetime true pending-reboot default_storage_engine false pending-reboot default_time_zone false pending-reboot default_tmp_storage_engine false pending-reboot default_week_format true pending-reboot delay_key_write true pending-reboot delayed_insert_limit true pending-reboot delayed_insert_timeout true pending-reboot delayed_queue_size true pending-reboot disabled_storage_engines false pending-reboot disconnect_on_expired_password true pending-reboot div_precision_increment true pending-reboot end_markers_in_json true pending-reboot enforce_gtid_consistency true pending-reboot eq_range_index_dive_limit true pending-reboot event_scheduler true pending-reboot explicit_defaults_for_timestamp true pending-reboot flush false pending-reboot flush_time true pending-reboot ft_boolean_syntax false pending-reboot ft_max_word_len true pending-reboot ft_min_word_len true pending-reboot ft_query_expansion_limit true pending-reboot ft_stopword_file true pending-reboot general_log true pending-reboot general_log_file false pending-reboot group_concat_max_len true pending-reboot gtid-mode true pending-reboot gtid_executed_compression_period true pending-reboot gtid_purged false pending-reboot host_cache_size true pending-reboot init_connect true pending-reboot innodb_adaptive_flushing true pending-reboot innodb_adaptive_flushing_lwm true pending-reboot innodb_adaptive_hash_index true pending-reboot innodb_adaptive_hash_index_parts true pending-reboot innodb_adaptive_max_sleep_delay true pending-reboot innodb_autoextend_increment true pending-reboot innodb_autoinc_lock_mode true pending-reboot innodb_buffer_pool_chunk_size true pending-reboot innodb_buffer_pool_dump_at_shutdown true pending-reboot innodb_buffer_pool_dump_now false pending-reboot innodb_buffer_pool_dump_pct true pending-reboot innodb_buffer_pool_filename false pending-reboot innodb_buffer_pool_instances true pending-reboot innodb_buffer_pool_load_abort false pending-reboot innodb_buffer_pool_load_at_startup true pending-reboot innodb_buffer_pool_load_now false pending-reboot innodb_buffer_pool_size true pending-reboot innodb_change_buffer_max_size true pending-reboot innodb_change_buffering true pending-reboot innodb_checksum_algorithm true pending-reboot innodb_cmp_per_index_enabled true pending-reboot innodb_commit_concurrency true pending-reboot innodb_compression_failure_threshold_pct true pending-reboot innodb_compression_level true pending-reboot innodb_compression_pad_pct_max true pending-reboot innodb_concurrency_tickets true pending-reboot innodb_data_home_dir false pending-reboot innodb_deadlock_detect true pending-reboot innodb_default_row_format true pending-reboot innodb_disable_sort_file_cache true pending-reboot innodb_fast_shutdown true pending-reboot innodb_file_format true pending-reboot innodb_file_per_table true pending-reboot innodb_fill_factor true pending-reboot innodb_flush_log_at_timeout false pending-reboot innodb_flush_log_at_trx_commit true pending-reboot innodb_flush_method true pending-reboot innodb_flush_neighbors true pending-reboot innodb_flush_sync true pending-reboot innodb_flushing_avg_loops false pending-reboot innodb_force_load_corrupted false pending-reboot innodb_ft_aux_table true pending-reboot innodb_ft_cache_size true pending-reboot innodb_ft_enable_diag_print true pending-reboot innodb_ft_enable_stopword true pending-reboot innodb_ft_max_token_size true pending-reboot innodb_ft_min_token_size true pending-reboot innodb_ft_num_word_optimize true pending-reboot innodb_ft_result_cache_limit true pending-reboot innodb_ft_server_stopword_table true pending-reboot innodb_ft_sort_pll_degree true pending-reboot innodb_ft_total_cache_size true pending-reboot innodb_ft_user_stopword_table true pending-reboot innodb_io_capacity true pending-reboot innodb_io_capacity_max true pending-reboot innodb_large_prefix true pending-reboot innodb_lock_wait_timeout true pending-reboot innodb_log_buffer_size true pending-reboot innodb_log_checksums true pending-reboot innodb_log_compressed_pages true pending-reboot innodb_log_file_size true pending-reboot innodb_log_group_home_dir false pending-reboot innodb_log_write_ahead_size true pending-reboot innodb_lru_scan_depth true pending-reboot innodb_max_dirty_pages_pct true pending-reboot innodb_max_dirty_pages_pct_lwm true pending-reboot innodb_max_purge_lag true pending-reboot innodb_max_purge_lag_delay true pending-reboot innodb_max_undo_log_size true pending-reboot innodb_monitor_disable true pending-reboot innodb_monitor_enable true pending-reboot innodb_monitor_reset true pending-reboot innodb_monitor_reset_all true pending-reboot innodb_old_blocks_pct true pending-reboot innodb_old_blocks_time true pending-reboot innodb_online_alter_log_max_size true pending-reboot innodb_open_files true pending-reboot innodb_optimize_fulltext_only true pending-reboot innodb_page_cleaners true pending-reboot innodb_page_size false pending-reboot innodb_print_all_deadlocks true pending-reboot innodb_purge_batch_size true pending-reboot innodb_purge_rseg_truncate_frequency true pending-reboot innodb_purge_threads true pending-reboot innodb_random_read_ahead true pending-reboot innodb_read_ahead_threshold true pending-reboot innodb_read_io_threads true pending-reboot innodb_read_only false pending-reboot innodb_replication_delay true pending-reboot innodb_rollback_on_timeout true pending-reboot innodb_rollback_segments true pending-reboot innodb_sort_buffer_size true pending-reboot innodb_spin_wait_delay true pending-reboot innodb_stats_auto_recalc true pending-reboot innodb_stats_method true pending-reboot innodb_stats_on_metadata true pending-reboot innodb_stats_persistent true pending-reboot innodb_stats_persistent_sample_pages true pending-reboot innodb_stats_transient_sample_pages true pending-reboot innodb_status_output true pending-reboot innodb_status_output_locks true pending-reboot innodb_strict_mode true pending-reboot innodb_support_xa true pending-reboot innodb_sync_array_size true pending-reboot innodb_sync_spin_loops true pending-reboot innodb_table_locks true pending-reboot innodb_temp_data_file_path false pending-reboot innodb_thread_concurrency true pending-reboot innodb_thread_sleep_delay true pending-reboot innodb_undo_directory false pending-reboot innodb_undo_log_truncate true pending-reboot innodb_undo_logs true pending-reboot innodb_undo_tablespaces false pending-reboot innodb_use_native_aio true pending-reboot innodb_write_io_threads true pending-reboot interactive_timeout true pending-reboot internal_tmp_disk_storage_engine true pending-reboot join_buffer_size true pending-reboot keep_files_on_create true pending-reboot key_buffer_size true pending-reboot key_cache_age_threshold true pending-reboot key_cache_block_size true pending-reboot key_cache_division_limit true pending-reboot lc_time_names true pending-reboot local_infile true pending-reboot lock_wait_timeout true pending-reboot log-bin false pending-reboot log_bin_trust_function_creators true pending-reboot log_bin_use_v1_row_events true pending-reboot log_builtin_as_identified_by_password true pending-reboot log_error false pending-reboot log_error_verbosity true pending-reboot log_output true pending-reboot log_queries_not_using_indexes true pending-reboot log_slave_updates false pending-reboot log_slow_admin_statements true pending-reboot log_slow_slave_statements true pending-reboot log_statements_unsafe_for_binlog false pending-reboot log_syslog false pending-reboot log_syslog_facility false pending-reboot log_syslog_include_pid false pending-reboot log_syslog_tag false pending-reboot log_throttle_queries_not_using_indexes true pending-reboot log_timestamps true pending-reboot log_warnings true pending-reboot long_query_time true pending-reboot low_priority_updates true pending-reboot lower_case_table_names true pending-reboot master-info-repository true pending-reboot master_verify_checksum true pending-reboot max_allowed_packet true pending-reboot max_binlog_cache_size true pending-reboot max_binlog_size false pending-reboot max_binlog_stmt_cache_size true pending-reboot max_connect_errors true pending-reboot max_connections true pending-reboot max_delayed_threads true pending-reboot max_digest_length false pending-reboot max_error_count true pending-reboot max_execution_time true pending-reboot max_heap_table_size true pending-reboot max_insert_delayed_threads true pending-reboot max_join_size true pending-reboot max_length_for_sort_data true pending-reboot max_points_in_geometry true pending-reboot max_prepared_stmt_count true pending-reboot max_seeks_for_key true pending-reboot max_sort_length true pending-reboot max_sp_recursion_depth true pending-reboot max_tmp_tables true pending-reboot max_user_connections true pending-reboot max_write_lock_count true pending-reboot mecab_rc_file false pending-reboot metadata_locks_cache_size true pending-reboot min_examined_row_limit true pending-reboot myisam_data_pointer_size true pending-reboot myisam_max_sort_file_size true pending-reboot myisam_mmap_size true pending-reboot myisam_sort_buffer_size true pending-reboot myisam_stats_method true pending-reboot myisam_use_mmap true pending-reboot mysql_native_password_proxy_users true pending-reboot net_buffer_length true pending-reboot net_read_timeout true pending-reboot net_retry_count true pending-reboot net_write_timeout true pending-reboot ngram_token_size true pending-reboot offline_mode false pending-reboot old-style-user-limits true pending-reboot old_passwords true pending-reboot optimizer_prune_level true pending-reboot optimizer_search_depth true pending-reboot optimizer_switch true pending-reboot optimizer_trace true pending-reboot optimizer_trace_features true pending-reboot optimizer_trace_limit true pending-reboot optimizer_trace_max_mem_size true pending-reboot optimizer_trace_offset true pending-reboot performance_schema true pending-reboot performance_schema_accounts_size true pending-reboot performance_schema_digests_size true pending-reboot performance_schema_events_stages_history_long_size true pending-reboot performance_schema_events_stages_history_size true pending-reboot performance_schema_events_statements_history_long_size true pending-reboot performance_schema_events_statements_history_size true pending-reboot performance_schema_events_transactions_history_long_size true pending-reboot performance_schema_events_transactions_history_size true pending-reboot performance_schema_events_waits_history_long_size true pending-reboot performance_schema_events_waits_history_size true pending-reboot performance_schema_hosts_size true pending-reboot performance_schema_max_cond_classes true pending-reboot performance_schema_max_cond_instances true pending-reboot performance_schema_max_digest_length true pending-reboot performance_schema_max_file_classes true pending-reboot performance_schema_max_file_handles true pending-reboot performance_schema_max_file_instances true pending-reboot performance_schema_max_index_stat true pending-reboot performance_schema_max_memory_classes true pending-reboot performance_schema_max_metadata_locks true pending-reboot performance_schema_max_mutex_classes true pending-reboot performance_schema_max_mutex_instances true pending-reboot performance_schema_max_prepared_statements_instances true pending-reboot performance_schema_max_program_instances true pending-reboot performance_schema_max_rwlock_classes true pending-reboot performance_schema_max_rwlock_instances true pending-reboot performance_schema_max_socket_classes true pending-reboot performance_schema_max_socket_instances true pending-reboot performance_schema_max_sql_text_length true pending-reboot performance_schema_max_stage_classes true pending-reboot performance_schema_max_statement_classes true pending-reboot performance_schema_max_statement_stack true pending-reboot performance_schema_max_table_handles true pending-reboot performance_schema_max_table_instances true pending-reboot performance_schema_max_table_lock_stat true pending-reboot performance_schema_max_thread_classes true pending-reboot performance_schema_max_thread_instances true pending-reboot performance_schema_session_connect_attrs_size true pending-reboot performance_schema_setup_actors_size true pending-reboot performance_schema_setup_objects_size true pending-reboot performance_schema_users_size true pending-reboot pid_file false pending-reboot plugin_dir false pending-reboot port false pending-reboot preload_buffer_size true pending-reboot profiling_history_size true pending-reboot query_alloc_block_size true pending-reboot query_cache_limit true pending-reboot query_cache_min_res_unit true pending-reboot query_cache_size true pending-reboot query_cache_type true pending-reboot query_cache_wlock_invalidate true pending-reboot query_prealloc_size true pending-reboot range_alloc_block_size true pending-reboot range_optimizer_max_mem_size true pending-reboot read_buffer_size true pending-reboot read_only true pending-reboot read_rnd_buffer_size true pending-reboot relay-log false pending-reboot relay_log_info_repository true pending-reboot relay_log_recovery false pending-reboot require_secure_transport false pending-reboot rpl_semi_sync_master_wait_for_slave_count false pending-reboot rpl_semi_sync_master_wait_point false pending-reboot rpl_stop_slave_timeout false pending-reboot safe-user-create true pending-reboot secure_auth false pending-reboot secure_file_priv false pending-reboot server_id false pending-reboot session_track_gtids true pending-reboot session_track_schema true pending-reboot session_track_state_change true pending-reboot session_track_system_variables true pending-reboot session_track_transaction_info true pending-reboot sha256_password_auto_generate_rsa_keys false pending-reboot sha256_password_proxy_users true pending-reboot show_compatibility_56 true pending-reboot show_old_temporals true pending-reboot skip-character-set-client-handshake true pending-reboot skip-slave-start false pending-reboot skip_external_locking false pending-reboot skip_name_resolve true pending-reboot skip_show_database true pending-reboot slave_allow_batching true pending-reboot slave_checkpoint_group true pending-reboot slave_checkpoint_period true pending-reboot slave_compressed_protocol true pending-reboot slave_net_timeout true pending-reboot slave_parallel_type true pending-reboot slave_parallel_workers true pending-reboot slave_pending_jobs_size_max true pending-reboot slave_preserve_commit_order true pending-reboot slave_rows_search_algorithms true pending-reboot slave_sql_verify_checksum true pending-reboot slave_transaction_retries true pending-reboot slave_type_conversions true pending-reboot slow_launch_time true pending-reboot slow_query_log true pending-reboot slow_query_log_file false pending-reboot socket false pending-reboot sort_buffer_size true pending-reboot sql_mode true pending-reboot sql_select_limit true pending-reboot stored_program_cache true pending-reboot super_read_only false pending-reboot sync_binlog true pending-reboot sync_frm true pending-reboot sync_master_info true pending-reboot sync_relay_log true pending-reboot sync_relay_log_info true pending-reboot sysdate-is-now true pending-reboot table_definition_cache true pending-reboot table_open_cache true pending-reboot table_open_cache_instances true pending-reboot temp-pool true pending-reboot thread_cache_size true pending-reboot thread_stack true pending-reboot time_zone true pending-reboot tls_version true pending-reboot tmp_table_size true pending-reboot tmpdir false pending-reboot transaction_alloc_block_size true pending-reboot transaction_prealloc_size true pending-reboot transaction_write_set_extraction false pending-reboot tx_isolation true pending-reboot updatable_views_with_limit true pending-reboot validate-password false pending-reboot validate_password_dictionary_file false pending-reboot validate_password_length false pending-reboot validate_password_mixed_case_count false pending-reboot validate_password_number_count false pending-reboot validate_password_policy false pending-reboot validate_password_special_char_count false pending-reboot wait_timeout true pending-reboot
default.postgres9.5
Parameter Name IsModifiable ApplyMethod application_name true pending-reboot archive_command false pending-reboot archive_timeout false pending-reboot array_nulls true pending-reboot authentication_timeout true pending-reboot auto_explain.log_analyze true pending-reboot auto_explain.log_buffers true pending-reboot auto_explain.log_format true pending-reboot auto_explain.log_min_duration true pending-reboot auto_explain.log_nested_statements true pending-reboot auto_explain.log_timing true pending-reboot auto_explain.log_triggers true pending-reboot auto_explain.log_verbose true pending-reboot autovacuum true pending-reboot autovacuum_analyze_scale_factor true pending-reboot autovacuum_analyze_threshold true pending-reboot autovacuum_freeze_max_age true pending-reboot autovacuum_max_workers true pending-reboot autovacuum_multixact_freeze_max_age true pending-reboot autovacuum_naptime true pending-reboot autovacuum_vacuum_cost_delay true pending-reboot autovacuum_vacuum_cost_limit true pending-reboot autovacuum_vacuum_scale_factor true pending-reboot autovacuum_vacuum_threshold true pending-reboot autovacuum_work_mem true pending-reboot backslash_quote true pending-reboot bgwriter_delay true pending-reboot bgwriter_lru_maxpages true pending-reboot bgwriter_lru_multiplier true pending-reboot bytea_output true pending-reboot check_function_bodies true pending-reboot checkpoint_completion_target true pending-reboot checkpoint_timeout true pending-reboot checkpoint_warning true pending-reboot client_encoding true pending-reboot client_min_messages true pending-reboot commit_delay true pending-reboot commit_siblings true pending-reboot config_file false pending-reboot constraint_exclusion true pending-reboot cpu_index_tuple_cost true pending-reboot cpu_operator_cost true pending-reboot cpu_tuple_cost true pending-reboot cursor_tuple_fraction true pending-reboot data_directory false pending-reboot datestyle true pending-reboot db_user_namespace false pending-reboot deadlock_timeout true pending-reboot debug_pretty_print true pending-reboot debug_print_parse true pending-reboot debug_print_plan true pending-reboot debug_print_rewritten true pending-reboot default_statistics_target true pending-reboot default_tablespace true pending-reboot default_transaction_deferrable true pending-reboot default_transaction_isolation true pending-reboot default_transaction_read_only true pending-reboot default_with_oids true pending-reboot effective_cache_size true pending-reboot effective_io_concurrency true pending-reboot enable_bitmapscan true pending-reboot enable_hashagg true pending-reboot enable_hashjoin true pending-reboot enable_indexonlyscan true pending-reboot enable_indexscan true pending-reboot enable_material true pending-reboot enable_mergejoin true pending-reboot enable_nestloop true pending-reboot enable_seqscan true pending-reboot enable_sort true pending-reboot enable_tidscan true pending-reboot escape_string_warning true pending-reboot exit_on_error false pending-reboot extra_float_digits true pending-reboot from_collapse_limit true pending-reboot fsync false pending-reboot full_page_writes false pending-reboot geqo true pending-reboot geqo_effort true pending-reboot geqo_generations true pending-reboot geqo_pool_size true pending-reboot geqo_seed true pending-reboot geqo_selection_bias true pending-reboot geqo_threshold true pending-reboot gin_fuzzy_search_limit true pending-reboot gin_pending_list_limit true pending-reboot hba_file false pending-reboot hot_standby_feedback true pending-reboot huge_pages true pending-reboot ident_file false pending-reboot intervalstyle true pending-reboot join_collapse_limit true pending-reboot lc_messages true pending-reboot lc_monetary true pending-reboot lc_numeric true pending-reboot lc_time true pending-reboot listen_addresses false pending-reboot lo_compat_privileges false pending-reboot log_autovacuum_min_duration true pending-reboot log_checkpoints true pending-reboot log_connections true pending-reboot log_destination false pending-reboot log_directory false pending-reboot log_disconnections true pending-reboot log_duration true pending-reboot log_error_verbosity true pending-reboot log_executor_stats true pending-reboot log_file_mode false pending-reboot log_filename true pending-reboot log_hostname true pending-reboot log_line_prefix false pending-reboot log_lock_waits true pending-reboot log_min_duration_statement true pending-reboot log_min_error_statement true pending-reboot log_min_messages true pending-reboot log_parser_stats true pending-reboot log_planner_stats true pending-reboot log_replication_commands true pending-reboot log_rotation_age true pending-reboot log_rotation_size true pending-reboot log_statement true pending-reboot log_statement_stats true pending-reboot log_temp_files true pending-reboot log_timezone false pending-reboot log_truncate_on_rotation false pending-reboot logging_collector false pending-reboot maintenance_work_mem true pending-reboot max_connections true pending-reboot max_files_per_process true pending-reboot max_locks_per_transaction true pending-reboot max_pred_locks_per_transaction true pending-reboot max_prepared_transactions true pending-reboot max_replication_slots true pending-reboot max_stack_depth true pending-reboot max_standby_archive_delay true pending-reboot max_standby_streaming_delay true pending-reboot max_wal_senders true pending-reboot max_wal_size true pending-reboot min_wal_size true pending-reboot operator_precedence_warning true pending-reboot password_encryption false pending-reboot pg_hint_plan.debug_print true pending-reboot pg_hint_plan.enable_hint true pending-reboot pg_hint_plan.enable_hint_table true pending-reboot pg_hint_plan.message_level true pending-reboot pg_hint_plan.parse_messages true pending-reboot pg_stat_statements.max true pending-reboot pg_stat_statements.save true pending-reboot pg_stat_statements.track true pending-reboot pg_stat_statements.track_utility true pending-reboot pgaudit.log true pending-reboot pgaudit.log_catalog true pending-reboot pgaudit.log_level true pending-reboot pgaudit.log_parameter true pending-reboot pgaudit.log_relation true pending-reboot pgaudit.log_statement_once true pending-reboot pgaudit.role true pending-reboot port false pending-reboot postgis.gdal_enabled_drivers true pending-reboot quote_all_identifiers true pending-reboot random_page_cost true pending-reboot rds.custom_dns_resolution true pending-reboot rds.extensions false pending-reboot rds.force_admin_logging_level true pending-reboot rds.force_autovacuum_logging_level true pending-reboot rds.force_ssl true pending-reboot rds.log_retention_period true pending-reboot rds.logical_replication true pending-reboot rds.max_tcp_buffers false pending-reboot rds.pg_stat_ramdisk_size true pending-reboot rds.rds_superuser_reserved_connections true pending-reboot rds.superuser_variables false pending-reboot restart_after_crash false pending-reboot row_security true pending-reboot search_path true pending-reboot seq_page_cost true pending-reboot server_encoding false pending-reboot session_replication_role true pending-reboot shared_buffers true pending-reboot shared_preload_libraries true pending-reboot sql_inheritance true pending-reboot ssl true pending-reboot ssl_ca_file false pending-reboot ssl_cert_file false pending-reboot ssl_ciphers false pending-reboot ssl_key_file false pending-reboot standard_conforming_strings true pending-reboot statement_timeout true pending-reboot stats_temp_directory false pending-reboot superuser_reserved_connections false pending-reboot synchronize_seqscans true pending-reboot synchronous_commit true pending-reboot syslog_facility false pending-reboot tcp_keepalives_count true pending-reboot tcp_keepalives_idle true pending-reboot tcp_keepalives_interval true pending-reboot temp_buffers true pending-reboot temp_tablespaces true pending-reboot timezone true pending-reboot track_activities true pending-reboot track_activity_query_size true pending-reboot track_commit_timestamp true pending-reboot track_counts true pending-reboot track_functions true pending-reboot track_io_timing true pending-reboot transaction_deferrable true pending-reboot transaction_read_only true pending-reboot transform_null_equals true pending-reboot unix_socket_directories false pending-reboot unix_socket_group false pending-reboot unix_socket_permissions false pending-reboot update_process_title true pending-reboot vacuum_cost_delay true pending-reboot vacuum_cost_limit true pending-reboot vacuum_cost_page_dirty true pending-reboot vacuum_cost_page_hit true pending-reboot vacuum_cost_page_miss true pending-reboot vacuum_defer_cleanup_age true pending-reboot vacuum_freeze_min_age true pending-reboot vacuum_freeze_table_age true pending-reboot vacuum_multixact_freeze_min_age true pending-reboot vacuum_multixact_freeze_table_age true pending-reboot wal_buffers true pending-reboot wal_compression true pending-reboot wal_keep_segments true pending-reboot wal_receiver_status_interval true pending-reboot wal_receiver_timeout true pending-reboot wal_sender_timeout true pending-reboot wal_sync_method false pending-reboot wal_writer_delay true pending-reboot work_mem true pending-reboot xmlbinary true pending-reboot xmloption true pending-reboot
default.oracle-ee-12.1
Parameter Name IsModifiable ApplyMethod _allow_level_without_connect_by true pending-reboot _always_semi_join true pending-reboot _awr_mmon_deep_purge_all_expired true pending-reboot _b_tree_bitmap_plans true pending-reboot _cursor_features_enabled true pending-reboot _cursor_obsolete_threshold true pending-reboot _db_block_prefetch_limit true pending-reboot _db_block_prefetch_quota true pending-reboot _db_file_noncontig_mblock_read_count true pending-reboot _disable_function_based_index true pending-reboot _enable_shared_pool_durations true pending-reboot _enable_space_preallocation true pending-reboot _fast_full_scan_enabled true pending-reboot _fix_control true pending-reboot _gby_hash_aggregation_enabled true pending-reboot _gc_defer_time false pending-reboot _grant_secure_role true pending-reboot _ignore_desc_in_index true pending-reboot _index_join_enabled true pending-reboot _index_partition_large_extents true pending-reboot _kks_obsolete_dump_threshold true pending-reboot _ktb_debug_flags true pending-reboot _like_with_bind_as_equality true pending-reboot _mutex_wait_scheme true pending-reboot _mutex_wait_time true pending-reboot _mv_refresh_use_hash_sj true pending-reboot _mv_refresh_use_stats true pending-reboot _no_or_expansion true pending-reboot _optim_peek_user_binds true pending-reboot _optimizer_adaptive_cursor_sharing true pending-reboot _optimizer_ads_use_result_cache true pending-reboot _optimizer_aggr_groupby_elim true pending-reboot _optimizer_autostats_job true pending-reboot _optimizer_batch_table_access_by_rowid true pending-reboot _optimizer_cartesian_enabled true pending-reboot _optimizer_cost_based_transformation true pending-reboot _optimizer_dsdir_usage_control true pending-reboot _optimizer_enhanced_filter_push true pending-reboot _optimizer_extended_cursor_sharing true pending-reboot _optimizer_extended_cursor_sharing_rel true pending-reboot _optimizer_gather_feedback true pending-reboot _optimizer_invalidation_period true pending-reboot _optimizer_join_elimination_enabled true pending-reboot _optimizer_join_sel_sanity_check true pending-reboot _optimizer_max_permutations true pending-reboot _optimizer_mjc_enabled true pending-reboot _optimizer_order_by_elimination_enabled true pending-reboot _optimizer_partial_join_eval true pending-reboot _optimizer_reduce_groupby_key true pending-reboot _optimizer_skip_scan_enabled true pending-reboot _optimizer_sortmerge_join_enabled true pending-reboot _optimizer_use_feedback true pending-reboot _orph_cln_interval true pending-reboot _partition_large_extents true pending-reboot _partition_view_enabled true pending-reboot _pred_move_around true pending-reboot _report_capture_cycle_time true pending-reboot _rollback_segment_count true pending-reboot _rowsets_enabled true pending-reboot _securefiles_concurrency_estimate true pending-reboot _smu_debug_mode true pending-reboot _sort_elimination_cost_ratio true pending-reboot _sql_plan_directive_mgmt_control true pending-reboot _sqlexec_progression_cost true pending-reboot _sqlmon_max_planlines true pending-reboot _suppress_identifiers_on_dupkey true pending-reboot _unnest_subquery true pending-reboot _use_single_log_writer true pending-reboot aq_tm_processes true pending-reboot archive_lag_target true pending-reboot audit_file_dest false pending-reboot audit_sys_operations false pending-reboot audit_syslog_level false pending-reboot audit_trail true pending-reboot background_core_dump true pending-reboot background_dump_dest false pending-reboot bitmap_merge_area_size true pending-reboot blank_trimming true pending-reboot buffer_pool_keep true pending-reboot buffer_pool_recycle true pending-reboot circuits true pending-reboot client_result_cache_lag true pending-reboot client_result_cache_size true pending-reboot commit_logging true pending-reboot commit_point_strength true pending-reboot commit_wait true pending-reboot commit_write false pending-reboot compatible true pending-reboot connection_brokers false pending-reboot control_file_record_keep_time true pending-reboot control_files false pending-reboot control_management_pack_access true pending-reboot core_dump_dest false pending-reboot cpu_count true pending-reboot create_bitmap_area_size true pending-reboot create_stored_outlines true pending-reboot cursor_bind_capture_destination true pending-reboot cursor_sharing true pending-reboot cursor_space_for_time true pending-reboot db_16k_cache_size true pending-reboot db_2k_cache_size true pending-reboot db_32k_cache_size true pending-reboot db_4k_cache_size true pending-reboot db_8k_cache_size false pending-reboot db_big_table_cache_percent_target true pending-reboot db_block_buffers true pending-reboot db_block_checking true pending-reboot db_block_checksum true pending-reboot db_block_size false pending-reboot db_cache_advice true pending-reboot db_cache_size true pending-reboot db_create_file_dest false pending-reboot db_create_online_log_dest_1 false pending-reboot db_create_online_log_dest_2 false pending-reboot db_create_online_log_dest_3 false pending-reboot db_create_online_log_dest_4 false pending-reboot db_create_online_log_dest_5 false pending-reboot db_domain true pending-reboot db_file_multiblock_read_count true pending-reboot db_file_name_convert false pending-reboot db_files true pending-reboot db_flashback_retention_target true pending-reboot db_index_compression_inheritance true pending-reboot db_keep_cache_size true pending-reboot db_lost_write_protect true pending-reboot db_name false pending-reboot db_recovery_file_dest false pending-reboot db_recovery_file_dest_size true pending-reboot db_recycle_cache_size true pending-reboot db_securefile true pending-reboot db_ultra_safe true pending-reboot db_unique_name false pending-reboot db_unrecoverable_scn_tracking false pending-reboot db_writer_processes true pending-reboot dbfips_140 true pending-reboot dbwr_io_slaves false pending-reboot ddl_lock_timeout true pending-reboot deferred_segment_creation true pending-reboot dg_broker_config_file1 false pending-reboot dg_broker_config_file2 false pending-reboot dg_broker_start false pending-reboot diagnostic_dest false pending-reboot disk_asynch_io false pending-reboot dispatchers true pending-reboot distributed_lock_timeout true pending-reboot dml_locks true pending-reboot dst_upgrade_insert_conv false pending-reboot enable_ddl_logging true pending-reboot enable_goldengate_replication true pending-reboot enable_pluggable_database false pending-reboot event false pending-reboot fal_client false pending-reboot fal_server false pending-reboot fast_start_mttr_target true pending-reboot fast_start_parallel_rollback true pending-reboot filesystemio_options false pending-reboot fixed_date false pending-reboot gcs_server_processes false pending-reboot global_context_pool_size true pending-reboot global_names true pending-reboot heat_map true pending-reboot hs_autoregister true pending-reboot ifile false pending-reboot inmemory_clause_default true pending-reboot inmemory_clause_default_memcompress true pending-reboot inmemory_clause_default_priority true pending-reboot inmemory_force true pending-reboot inmemory_max_populate_servers false pending-reboot inmemory_query true pending-reboot inmemory_size true pending-reboot inmemory_trickle_repopulate_servers_percent true pending-reboot instance_name false pending-reboot java_jit_enabled false pending-reboot java_max_sessionspace_size false pending-reboot java_pool_size false pending-reboot java_soft_sessionspace_limit false pending-reboot job_queue_processes true pending-reboot large_pool_size true pending-reboot ldap_directory_access false pending-reboot ldap_directory_sysauth false pending-reboot license_max_sessions true pending-reboot license_max_users true pending-reboot license_sessions_warning true pending-reboot listener_networks false pending-reboot local_listener false pending-reboot lock_name_space true pending-reboot lock_sga false pending-reboot log_archive_config false pending-reboot log_archive_dest false pending-reboot log_archive_dest_1 false pending-reboot log_archive_dest_state_1 false pending-reboot log_archive_format false pending-reboot log_archive_local_first false pending-reboot log_archive_max_processes true pending-reboot log_archive_min_succeed_dest true pending-reboot log_archive_trace true pending-reboot log_buffer true pending-reboot log_checkpoint_interval true pending-reboot log_checkpoint_timeout true pending-reboot log_checkpoints_to_alert true pending-reboot log_file_name_convert false pending-reboot max_dispatchers true pending-reboot max_dump_file_size true pending-reboot max_enabled_roles false pending-reboot max_shared_servers true pending-reboot max_string_size false pending-reboot memory_max_target true pending-reboot memory_target true pending-reboot nls_date_format true pending-reboot nls_length_semantics true pending-reboot nls_nchar_conv_excp true pending-reboot nls_time_format true pending-reboot nls_time_tz_format true pending-reboot nls_timestamp_format true pending-reboot nls_timestamp_tz_format true pending-reboot noncdb_compatible true pending-reboot o7_dictionary_accessibility false pending-reboot object_cache_max_size_percent true pending-reboot object_cache_optimal_size true pending-reboot olap_page_pool_size true pending-reboot open_cursors true pending-reboot open_links true pending-reboot open_links_per_instance true pending-reboot optimizer_adaptive_features true pending-reboot optimizer_adaptive_reporting_only true pending-reboot optimizer_capture_sql_plan_baselines true pending-reboot optimizer_dynamic_sampling true pending-reboot optimizer_features_enable true pending-reboot optimizer_index_caching true pending-reboot optimizer_index_cost_adj true pending-reboot optimizer_mode true pending-reboot optimizer_secure_view_merging true pending-reboot optimizer_use_invisible_indexes true pending-reboot optimizer_use_pending_statistics true pending-reboot optimizer_use_sql_plan_baselines true pending-reboot os_authent_prefix false pending-reboot os_roles false pending-reboot parallel_adaptive_multi_user true pending-reboot parallel_automatic_tuning true pending-reboot parallel_degree_level true pending-reboot parallel_degree_limit true pending-reboot parallel_degree_policy true pending-reboot parallel_execution_message_size true pending-reboot parallel_max_servers true pending-reboot parallel_min_servers true pending-reboot parallel_min_time_threshold true pending-reboot parallel_servers_target true pending-reboot parallel_threads_per_cpu true pending-reboot pdb_file_name_convert false pending-reboot permit_92_wrap_format true pending-reboot pga_aggregate_limit true pending-reboot pga_aggregate_target true pending-reboot plscope_settings true pending-reboot plsql_ccflags true pending-reboot plsql_code_type true pending-reboot plsql_debug true pending-reboot plsql_optimize_level true pending-reboot plsql_v2_compatibility true pending-reboot plsql_warnings true pending-reboot processes true pending-reboot processor_group_name false pending-reboot query_rewrite_enabled true pending-reboot query_rewrite_integrity true pending-reboot rdbms_server_dn false pending-reboot read_only_open_delayed false pending-reboot recovery_parallelism false pending-reboot recyclebin true pending-reboot redo_transport_user false pending-reboot remote_dependencies_mode true pending-reboot remote_listener false pending-reboot remote_login_passwordfile false pending-reboot remote_os_authent false pending-reboot remote_os_roles false pending-reboot replication_dependency_tracking true pending-reboot resource_limit true pending-reboot resource_manager_cpu_allocation true pending-reboot resource_manager_plan true pending-reboot result_cache_max_result true pending-reboot result_cache_max_size true pending-reboot result_cache_mode true pending-reboot result_cache_remote_expiration true pending-reboot resumable_timeout true pending-reboot rollback_segments false pending-reboot sec_case_sensitive_logon true pending-reboot sec_max_failed_login_attempts true pending-reboot sec_protocol_error_further_action true pending-reboot sec_protocol_error_trace_action true pending-reboot sec_return_server_release_banner true pending-reboot serial_reuse true pending-reboot service_names false pending-reboot session_cached_cursors true pending-reboot session_max_open_files true pending-reboot sessions true pending-reboot sga_max_size true pending-reboot sga_target true pending-reboot shadow_core_dump true pending-reboot shared_memory_address false pending-reboot shared_pool_reserved_size true pending-reboot shared_pool_size true pending-reboot shared_server_sessions true pending-reboot shared_servers true pending-reboot skip_unusable_indexes true pending-reboot smtp_out_server true pending-reboot sort_area_retained_size true pending-reboot sort_area_size true pending-reboot spatial_vector_acceleration true pending-reboot spfile false pending-reboot sql92_security true pending-reboot sql_trace true pending-reboot sqlnetora.default_sdu_size true pending-reboot sqlnetora.diag_adr_enabled true pending-reboot sqlnetora.recv_buf_size true pending-reboot sqlnetora.send_buf_size true pending-reboot sqlnetora.sqlnet.expire_time true pending-reboot sqlnetora.sqlnet.inbound_connect_timeout true pending-reboot sqlnetora.sqlnet.outbound_connect_timeout true pending-reboot sqlnetora.sqlnet.recv_timeout true pending-reboot sqlnetora.sqlnet.send_timeout true pending-reboot sqlnetora.tcp.connect_timeout true pending-reboot sqlnetora.trace_level_server true pending-reboot sqltune_category true pending-reboot standby_archive_dest false pending-reboot standby_file_management false pending-reboot star_transformation_enabled true pending-reboot statistics_level true pending-reboot streams_pool_size true pending-reboot temp_undo_enabled true pending-reboot thread false pending-reboot threaded_execution false pending-reboot timed_os_statistics true pending-reboot timed_statistics true pending-reboot trace_enabled true pending-reboot transactions true pending-reboot transactions_per_rollback_segment true pending-reboot undo_management false pending-reboot undo_retention true pending-reboot undo_tablespace true pending-reboot unified_audit_sga_queue_size true pending-reboot use_dedicated_broker false pending-reboot use_indirect_data_buffers false pending-reboot use_large_pages true pending-reboot user_dump_dest false pending-reboot utl_file_dir false pending-reboot workarea_size_policy true pending-reboot xml_db_events false pending-reboot
SQL Serverのdefault パラメータグループは、カラム表示が上手くできなかったので、一旦割愛。
