руководитель Центра компетенции
по базам данных УКЦ ФОРС,
Oracle Certified Professional
Данный небольшой справочник, составленный нами на основе документации Oracle, поможет сориентироваться в новых, устаревших и неподдерживаемых параметрах инициализации в новом релизе БД, а также с изменениями значений «по умолчанию» в Oracle 12 R2.
| Параметр инициализации | Oracle 11.2.0.4 | Oracle 12.1.0.2 | Oracle 12.2.0.1 |
audit_sys_operations compatible control_file_record_keep_time db_securefile dml_locks filesystemio_options job_queue_processes object_cache_optimal_size optimizer_features_enable parallel_max_servers parallel_min_servers parallel_servers_target parallel_adaptive_multi_user pre_page_sga resource_limit sec_max_failed_login_attempts sec_protocol_error_trace_action spatial_vector_acceleration sql92_security |
FALSE 11.2.0.4 7 PERMITTED 616 NONE 1000 102400 11.2.0.4 48 0 64 TRUE FALSE FALSE 10 CONTINUE FALSE FALSE |
TRUE 12.1.0.2.0 7 PREFERRED 1416 NONE 1000 102400 12.1.0.2 80 8 32 TRUE TRUE TRUE 3 TRACE FALSE FALSE |
TRUE 12.02.2000 30 PREFERRED 2076 setall 4000 10240000 12.2.0.1 80 8 32 FALSE TRUE TRUE 4 LOG TRUE TRUE |
| Параметр инициализации | Описание |
allow_global_dblinks | LDAP lookup for DBLINKS |
allow_group_access_to_sga | Allow read access for SGA to users of Oracle owner group |
approx_for_aggregation | Replace exact aggregation with approximate aggregation |
approx_for_count_distinct | Replace count distinct with approx_count_distinct |
approx_for_percentile | Replace percentile_* with approx_percentile |
asm_io_processes | number of I/O processes per domain in the ASM IOSERVER instance |
autotask_max_active_pdbs | Setting for Autotask Maximum Maintenance PDBs |
awr_pdb_autoflush_enabled | Enable/Disable AWR automatic PDB flushing |
cdb_cluster [undocumented] | if TRUE startup in CDB Cluster mode |
cdb_cluster_name [undocumented] | CDB Cluster name |
clonedb_dir | CloneDB Directory |
containers_parallel_degree | Parallel degree for a CONTAINERS() query |
cursor_invalidation | default for DDL cursor invalidation semantics |
data_guard_sync_latency | Data Guard SYNC latency |
data_transfer_cache_size | Size of data transfer cache |
default_sharing | Default sharing clause |
disable_pdb_feature [undocumented] | Disable features |
enable_automatic_maintenance_pdb | Enable/Disable Automated Maintenance for Non-Root PDB |
enable_dnfs_dispatcher | Enable DNFS Dispatcher |
enabled_PDBs_on_standby | List of Enabled PDB patterns |
encrypt_new_tablespaces | whether to encrypt newly created tablespaces |
exafusion_enabled | Enable Exafusion |
external_keystore_credential_location | external keystore credential location |
inmemory_adg_enabled | Enable IMC support on ADG |
inmemory_expressions_usage | Controls which In-Memory Expressions are populated in-memory |
inmemory_virtual_columns | Controls which user-defined virtual columns are stored in-memory |
instance_abort_delay_time | time to delay an internal initiated abort (in seconds) |
instance_mode | indicates whether the instance read-only or read-write or read-mostly |
long_module_action | Use longer module and action |
max_datapump_jobs_per_pdb | maximum number of concurrent Data Pump Jobs per PDB |
max_idle_time | maximum session idle time in minutes |
max_iops | MAX IO per second |
max_mbps | MAX MB per second |
max_pdbs | max number of pdbs allowed in CDB or Application ROOT |
ofs_threads | Number of OFS threads |
one_step_plugin_for_pdb_with_tde [undocumented] | Facilitate one-step plugin for PDB with TDE encrypted data |
optimizer_adaptive_plans | controls all types of adaptive plans |
optimizer_adaptive_statistics | controls all types of adaptive statistics |
outbound_dblink_protocols | Outbound DBLINK Protocols allowed |
remote_recovery_file_dest | default remote database recovery file location for refresh/relocate |
resource_manage_goldengate | Goldengate resource manager enabled |
sga_min_size | Minimum, guaranteed size of PDB’s SGA |
shrd_dupl_table_refresh_rate | duplicated table refresh rate (in seconds) |
standby_db_preserve_states | Preserve state cross standby role transition |
target_pdbs [undocumented] | Parameter is a hint to adjust certain attributes of the CDB |
uniform_log_timestamp_format | use uniform timestamp formats vs pre-12.2 formats |
O7_DICTIONARY_ACCESSIBILITY active_instance_count asm_preferred_read_failure_groups background_dump_dest buffer_pool_keep buffer_pool_recycle commit_write cursor_space_for_time db_block_buffers fast_start_io_target instance_groups lock_name_space log_archive_start parallel_adaptive_multi_user plsql_debug plsql_v2_compatibility rdbms_server_dn remote_os_authent resource_manager_cpu_allocation sec_case_sensitive_logon serial_reuse sql_trace standby_archive_dest unified_audit_sga_queue_size user_dump_dest utl_file_dir
_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