[Database] Obsolete SPFILE Parameters in Oracle Database 12.2.0.1

原文はこちら。
https://blogs.oracle.com/UPGRADE/entry/obsolete_spfile_parameters_in_oracle

このエントリは、Oracle Database 12.2.0.1のinit.ora/SPFILEパラメータに関する一連のエントリの第2弾です。
廃止されたパラメータは159個です(これらはV$OBSOLETE_PARAMETERSにあります)。
  • _app_ctx_vers
  • _average_dirties_half_life
  • _aw_row_source_enabled
  • _compatible_no_recovery
  • _data_transfer_cache_size
  • _db_no_mount_lock
  • _dlm_send_timeout
  • _dtree_bintest_id
  • _dtree_compressbmp_enabled
  • _evolve_plan_baseline_report_level
  • _fast_start_instance_recovery_target
  • _fic_max_length
  • _fic_outofmem_candidates
  • _idl_conventional_index_maintenance
  • _kgl_latch_count
  • _kks_free_cursor_stat_pct
  • _kspptbl_mem_usage
  • _lm_direct_sends
  • _lm_multiple_receivers
  • _lm_rcv_buffer_size
  • _lm_statistics
  • _log_archive_buffer_size
  • _log_io_size
  • _max_log_write_io_parallelism
  • _module_action_old_length
  • _optimizer_adaptive_plans
  • _optimizer_choose_permutation
  • _oracle_trace_events
  • _oracle_trace_facility_version
  • _plan_verify_local_time_limit
  • _plsql_conditional_compilation
  • _px_async_getgranule
  • _px_slaves_share_cursors
  • _seq_process_cache_const
  • _spr_use_hash_table
  • _sqlexec_progression_cost
  • _use_hidden_partitions
  • _very_large_partitioned_table
  • allow_partial_sn_results
  • always_anti_join
  • always_semi_join
  • arch_io_slaves
  • b_tree_bitmap_plans
  • backup_disk_io_slaves
  • cache_size_threshold
  • cell_partition_large_extents
  • cleanup_rollback_entries
  • close_cached_open_cursors
  • complex_view_merging
  • db_block_checkpoint_batch
  • db_block_lru_extended_statistics
  • db_block_lru_latches
  • db_block_lru_statistics
  • db_block_max_dirty_target
  • db_file_simultaneous_writes
  • dblink_encrypt_login
  • ddl_wait_for_locks
  • delayed_logging_block_cleanouts
  • discrete_transactions_enabled
  • distributed_recovery_connection_hold_time
  • distributed_transactions
  • drs_start
  • enqueue_resources
  • exclude_seed_cdb_view
  • fast_full_scan_enabled
  • freeze_DB_for_fast_instance_recovery
  • gc_defer_time
  • gc_files_to_locks
  • gc_latches
  • gc_lck_procs
  • gc_releasable_locks
  • gc_rollback_locks
  • hash_join_enabled
  • hash_multiblock_io_count
  • instance_nodeset
  • job_queue_interval
  • job_queue_keep_connections
  • large_pool_min_alloc
  • lgwr_io_slaves
  • lm_locks
  • lm_procs
  • lm_procs
  • lm_ress
  • lock_sga_areas
  • log_block_checksum
  • log_files
  • log_parallelism
  • log_simultaneous_copies
  • log_small_entry_max_size
  • logmnr_max_persistent_sessions
  • max_commit_propagation_delay
  • max_rollback_segments
  • max_transaction_branches
  • mts_circuits
  • mts_dispatchers
  • mts_listener_address
  • mts_max_dispatchers
  • mts_max_servers
  • mts_multiple_listeners
  • mts_servers
  • mts_service
  • mts_sessions
  • ogms_home
  • ops_admin_group
  • ops_interconnects
  • optimizer_adaptive_features
  • optimizer_max_permutations
  • optimizer_percent_parallel
  • optimizer_search_limit
  • oracle_trace_collection_name
  • oracle_trace_collection_path
  • oracle_trace_collection_size
  • oracle_trace_enable
  • oracle_trace_facility_name
  • oracle_trace_facility_path
  • parallel_automatic_tuning
  • parallel_broadcast_enabled
  • parallel_default_max_instances
  • parallel_degree_level
  • parallel_io_cap_enabled
  • parallel_min_message_pool
  • parallel_server
  • parallel_server_idle_time
  • parallel_server_instances
  • parallel_transaction_resource_timeout
  • partition_view_enabled
  • plsql_compiler_flags
  • plsql_native_c_compiler
  • plsql_native_library_dir
  • plsql_native_library_subdir_count
  • plsql_native_linker
  • plsql_native_make_file_name
  • plsql_native_make_utility
  • push_join_predicate
  • remote_archive_enable
  • row_cache_cursors
  • row_locking
  • sequence_cache_entries
  • sequence_cache_hash_buckets
  • serializable
  • shared_pool_reserved_min_alloc
  • snapshot_refresh_interval
  • snapshot_refresh_keep_connections
  • snapshot_refresh_processes
  • sort_direct_writes
  • sort_multiblock_read_count
  • sort_read_fac
  • sort_spacemap_size
  • sort_write_buffer_size
  • sort_write_buffers
  • spin_count
  • sql_version
  • standby_preserves_names
  • temporary_table_locks
  • text_enable
  • transaction_auditing
  • undo_suppress_errors
  • use_indirect_data_buffers
  • use_ism

0 件のコメント:

コメントを投稿