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

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

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

Описание

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