МенюКонтакты
Обучение
Москва

+7 (495) 913-75-75 доб.221

+7 (495) 668-08-42

Санкт-Петербург

+7 (812) 441-33-15

+7 (901) 374-07-97

Почта

edu@fors.ru

Изменения значений параметров инициализации SPFILE в Oracle 12 R2

Изменения значений параметров инициализации SPFILE в Oracle 12 R2

1.jpg
Докучаев Дмитрий
Руководитель Центра Компетенции по базам данных УКЦ ФОРС
OCP                               


Изменения значений параметров инициализации  SPFILE  в Oracle 12 R2

Данный небольшой справочник, составленный нами на основе документации Oracle,  поможет  вам быстрее сориентироваться в новых, устаревших и неподдерживаемых параметрах инициализации в новом релизе БД, а также с изменениями значений «по умолчанию» в  Oracle  12 R2

1. Изменения значений параметров инициализации  «по умолчанию» в различных версиях Oracle  по сравнению с 12 R2.

Параметр инициализации

Oracle 11.2.0.4

Oracle 12.1.0.2

Oracle. 12.2.0.1

audit_sys_operations

FALSE

TRUE

TRUE

compatible

11.2.0.4

12.1.0.2.0

12.02.2000

control_file_record_keep_time

7

7

30

db_securefile

PERMITTED

PREFERRED

PREFERRED

dml_locks

616

1416

2076

filesystemio_options

NONE

NONE

setall

job_queue_processes

1000

1000

4000

object_cache_optimal_size

102400

102400

10240000

optimizer_features_enable

11.2.0.4

12.1.0.2

12.2.0.1

parallel_max_servers

48

80

80

parallel_min_servers

0

8

8

parallel_servers_target

64

32

32

parallel_adaptive_multi_user

TRUE

TRUE

FALSE

pre_page_sga

FALSE

TRUE

TRUE

resource_limit

FALSE

TRUE

TRUE

sec_max_failed_login_attempts

10

3

4

sec_protocol_error_trace_action

CONTINUE

TRACE

LOG

spatial_vector_acceleration

FALSE

FALSE

TRUE

sql92_security

FALSE

FALSE

TRUE


2. Новые  SPFILE параметры в Oracle Database 12.2.0.1

Параметр инициализации

Описание

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_locat ion

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

3.Deprecated ( устаревшие) параметры  инициализации  в Oracle 12 R2

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

4.Obsolete (более не используемые) параметры  инициализации  в Oracle 12 R2


_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


Возврат к списку

Поделиться
Отправьте другу или начальнику ссылку на почту
Заявка на обучение

Заявка на обучение

Записаться на курс:

Выберите дату начала курса: