Below is a table of recommended Initialization parameters for Oracle when installing the Data Platform:
|
Name |
Display Value |
|
DBFIPS_140 |
FALSE |
|
CO7_DICTIONARY_ACCESSIBILITY |
FALSE |
|
active_instance_count |
|
|
aq_tm_processes |
1 |
|
archive_lag_target |
0 |
|
asm_diskgroups |
|
|
asm_diskstring |
|
|
asm_power_limit |
1 |
|
asm_preferred_read_failure_groups |
|
|
audit_file_dest |
/u01/app/oracle/admin/ora12c/adump |
|
audit_sys_operations |
TRUE |
|
audit_syslog_level |
|
|
audit_trail |
DB |
|
awr_snapshot_time_offset |
0 |
|
background_core_dump |
PARTIALS |
|
background_dump_dest |
/u01/app/oracle/product/12.1.0/rdbms/log |
|
backup_tape_io_slaves |
FALSE |
|
bitmap_merge_area_size |
1048576 |
|
blank_trimming |
FALSE |
|
buffer_pool_keep |
|
|
buffer_pool_recycle |
|
|
cell_offload_compaction |
ADAPTIVE |
|
cell_offload_decryption |
TRUE |
|
cell_offload_parameters |
|
|
cell_offload_plan_display |
AUTO |
|
cell_offload_processing |
TRUE |
|
cell_offloadgroup_name |
|
|
circuits |
|
|
client_result_cache_lag |
3000 |
|
client_result_cache_size |
0 |
|
clonedb |
FALSE |
|
cluster_database |
FALSE |
|
cluster_database_instances |
1 |
|
cluster_interconnects |
|
|
commit_logging |
|
|
commit_point_strength |
1 |
|
commit_wait |
|
|
commit_write |
|
|
common_user_prefix |
C## |
|
compatible |
12.1.0.2.0 |
|
connection_brokers |
((TYPE=EMON)(BROKERS=1)) |
|
connection_brokers |
((TYPE=DEDICATED)(BROKERS=1)) |
|
control_file_record_keep_time |
7 |
|
control_files |
/u01/app/oracle/fast_recovery_area/ora12c/control02.ctl |
|
control_files |
/u01/app/oracle/oradata/ora12c/control01.ctl |
|
control_management_pack_access |
DIAGNOSTIC+TUNING |
|
core_dump_dest |
/u01/app/oracle/diag/rdbms/ora12c/ora12c/cdump |
|
cpu_count |
16 |
|
create_bitmap_area_size |
8388608 |
|
create_stored_outlines |
|
|
cursor_bind_capture_destination |
memory+disk |
|
cursor_sharing |
EXACT |
|
cursor_space_for_time |
FALSE |
|
db_16k_cache_size |
0 |
|
db_2k_cache_size |
0 |
|
db_32k_cache_size |
0 |
|
db_4k_cache_size |
0 |
|
db_8k_cache_size |
0 |
|
db_big_table_cache_percent_target |
0 |
|
db_block_buffers |
0 |
|
db_block_checking |
FALSE |
|
db_block_checksum |
TYPICAL |
|
db_block_size |
8192 |
|
db_cache_advice |
ON |
|
db_cache_size |
0 |
|
db_create_file_dest |
|
|
db_create_online_log_dest_1 |
|
|
db_create_online_log_dest_2 |
|
|
db_create_online_log_dest_3 |
|
|
db_create_online_log_dest_4 |
|
|
db_create_online_log_dest_5 |
|
|
db_domain |
|
|
db_file_multiblock_read_count |
128 |
|
db_file_name_convert |
|
|
db_files |
200 |
|
db_flash_cache_file |
|
|
db_flash_cache_size |
0 |
|
db_flashback_retention_target |
1440 |
|
db_index_compression_inheritance |
NONE |
|
db_keep_cache_size |
0 |
|
db_lost_write_protect |
NONE |
|
db_name |
ora12c |
|
db_performance_profile |
|
|
db_recovery_file_dest |
/u01/app/oracle/fast_recovery_area |
|
db_recovery_file_dest_size |
4560M |
|
db_recycle_cache_size |
0 |
|
db_securefile |
PREFERRED |
|
db_ultra_safe |
OFF |
|
db_unique_name |
ora12c |
|
db_unrecoverable_scn_tracking |
TRUE |
|
db_writer_processes |
2 |
|
dbwr_io_slaves |
0 |
|
ddl_lock_timeout |
0 |
|
deferred_segment_creation |
TRUE |
|
dg_broker_config_file1 |
/u01/app/oracle/product/12.1.0/dbs/dr1ora12c.dat |
|
dg_broker_config_file2 |
/u01/app/oracle/product/12.1.0/dbs/dr2ora12c.dat |
|
dg_broker_start |
FALSE |
|
diagnostic_dest |
/u01/app/oracle |
|
disk_asynch_io |
TRUE |
|
dispatchers |
(PROTOCOL=TCP) (SERVICE=ora12cXDB) |
|
distributed_lock_timeout |
60 |
|
dml_locks |
2112 |
|
dnfs_batch_size |
4096 |
|
dst_upgrade_insert_conv |
TRUE |
|
enable_ddl_logging |
FALSE |
|
enable_goldengate_replication |
FALSE |
|
enable_pluggable_database |
FALSE |
|
event |
|
|
exclude_seed_cdb_view |
TRUE |
|
fal_client |
|
|
fal_server |
|
|
fast_start_io_target |
0 |
|
fast_start_mttr_target |
0 |
|
fast_start_parallel_rollback |
LOW |
|
file_mapping |
FALSE |
|
fileio_network_adapters |
|
|
filesystemio_options |
NONE |
|
fixed_date |
|
|
gcs_server_processes |
0 |
|
global_context_pool_size |
|
|
global_names |
FALSE |
|
global_txn_processes |
1 |
|
hash_area_size |
131072 |
|
heat_map |
OFF |
|
hi_shared_memory_address |
0 |
|
hs_autoregister |
TRUE |
|
ifile |
|
|
inmemory_clause_default |
|
|
inmemory_force |
DEFAULT |
|
inmemory_max_populate_servers |
0 |
|
inmemory_query |
ENABLE |
|
inmemory_size |
0 |
|
inmemory_trickle_repopulate_servers_percent |
1 |
|
instance_groups |
|
|
instance_name |
ora12c |
|
instance_number |
0 |
|
instance_type |
RDBMS |
|
instant_restore |
FALSE |
|
java_jit_enabled |
TRUE |
|
java_max_sessionspace_size |
0 |
|
java_pool_size |
0 |
|
java_restrict |
none |
|
java_soft_sessionspace_limit |
0 |
|
job_queue_processes |
1000 |
|
large_pool_size |
0 |
|
ldap_directory_access |
NONE |
|
ldap_directory_sysauth |
NO |
|
license_max_sessions |
0 |
|
license_max_users |
0 |
|
license_sessions_warning |
0 |
|
listener_networks |
|
|
local_listener |
|
|
lock_name_space |
|
|
lock_sga |
FALSE |
|
log_archive_config |
|
|
log_archive_dest |
|
|
log_archive_dest_1 |
|
|
log_archive_dest_10 |
|
|
log_archive_dest_11 |
|
|
log_archive_dest_12 |
|
|
log_archive_dest_13 |
|
|
log_archive_dest_14 |
|
|
log_archive_dest_15 |
|
|
log_archive_dest_16 |
|
|
log_archive_dest_17 |
|
|
log_archive_dest_18 |
|
|
log_archive_dest_19 |
|
|
log_archive_dest_2 |
|
|
log_archive_dest_20 |
|
|
log_archive_dest_21 |
|
|
log_archive_dest_22 |
|
|
log_archive_dest_23 |
|
|
log_archive_dest_24 |
|
|
log_archive_dest_25 |
|
|
log_archive_dest_26 |
|
|
log_archive_dest_27 |
|
|
log_archive_dest_28 |
|
|
log_archive_dest_29 |
|
|
log_archive_dest_3 |
|
|
log_archive_dest_30 |
|
|
log_archive_dest_31 |
|
|
log_archive_dest_4 |
|
|
log_archive_dest_5 |
|
|
log_archive_dest_6 |
|
|
log_archive_dest_7 |
|
|
log_archive_dest_8 |
|
|
log_archive_dest_9 |
|
|
log_archive_dest_state_1 |
Enable |
|
log_archive_dest_state_10 |
Enable |
|
log_archive_dest_state_11 |
Enable |
|
log_archive_dest_state_12 |
Enable |
|
log_archive_dest_state_13 |
Enable |
|
log_archive_dest_state_14 |
Enable |
|
log_archive_dest_state_15 |
Enable |
|
log_archive_dest_state_16 |
Enable |
|
log_archive_dest_state_17 |
Enable |
|
log_archive_dest_state_18 |
Enable |
|
log_archive_dest_state_19 |
Enable |
|
log_archive_dest_state_2 |
Enable |
|
log_archive_dest_state_20 |
Enable |
|
log_archive_dest_state_21 |
Enable |
|
log_archive_dest_state_22 |
Enable |
|
log_archive_dest_state_23 |
Enable |
|
log_archive_dest_state_24 |
Enable |
|
log_archive_dest_state_25 |
Enable |
|
log_archive_dest_state_26 |
Enable |
|
log_archive_dest_state_27 |
Enable |
|
log_archive_dest_state_28 |
Enable |
|
log_archive_dest_state_29 |
Enable |
|
log_archive_dest_state_3 |
Enable |
|
log_archive_dest_state_30 |
Enable |
|
log_archive_dest_state_31 |
Enable |
|
log_archive_dest_state_4 |
Enable |
|
log_archive_dest_state_5 |
Enable |
|
log_archive_dest_state_6 |
Enable |
|
log_archive_dest_state_7 |
Enable |
|
log_archive_dest_state_8 |
Enable |
|
log_archive_dest_state_9 |
Enable |
|
log_archive_duplex_dest |
|
|
log_archive_format |
%t_%s_%r.dbf |
|
log_archive_max_processes |
4 |
|
log_archive_min_succeed_dest |
1 |
|
log_archive_start |
FALSE |
|
log_archive_trace |
0 |
|
log_buffer |
58432K |
|
log_checkpoint_interval |
0 |
|
log_checkpoint_timeout |
1800 |
|
log_checkpoints_to_alert |
FALSE |
|
log_file_name_convert |
|
|
max_dispatchers |
|
|
max_dump_file_size |
Unlimited |
|
max_enabled_roles |
150 |
|
max_shared_servers |
|
|
max_string_size |
STANDARD |
|
memory_max_target |
19328M |
|
memory_target |
19328M |
|
nls_calendar |
|
|
nls_comp |
BINARY |
|
nls_currency |
|
|
nls_date_format |
DD-MON-RR HH:MI:SS |
|
nls_date_language |
|
|
nls_dual_currency |
|
|
nls_iso_currency |
|
|
nls_language |
AMERICAN |
|
nls_length_semantics |
BYTE |
|
nls_nchar_conv_excp |
FALSE |
|
nls_numeric_characters |
|
|
nls_sort |
|
|
nls_territory |
AMERICA |
|
nls_time_format |
|
|
nls_time_tz_format |
|
|
nls_timestamp_format |
|
|
nls_timestamp_tz_format |
|
|
noncdb_compatible |
FALSE |
|
object_cache_max_size_percent |
10 |
|
object_cache_optimal_size |
102400 |
|
olap_page_pool_size |
0 |
|
open_cursors |
300 |
|
open_links |
4 |
|
open_links_per_instance |
4 |
|
optimizer_adaptive_features |
TRUE |
|
optimizer_adaptive_reporting_only |
FALSE |
|
optimizer_capture_sql_plan_baselines |
FALSE |
|
optimizer_dynamic_sampling |
2 |
|
optimizer_features_enable |
12.1.0.2 |
|
optimizer_index_caching |
0 |
|
optimizer_index_cost_adj |
100 |
|
optimizer_inmemory_aware |
TRUE |
|
optimizer_mode |
ALL_ROWS |
|
optimizer_secure_view_merging |
TRUE |
|
optimizer_use_invisible_indexes |
FALSE |
|
optimizer_use_pending_statistics |
FALSE |
|
optimizer_use_sql_plan_baselines |
TRUE |
|
os_authent_prefix |
ops$$ |
|
os_roles |
FALSE |
|
parallel_adaptive_multi_user |
TRUE |
|
parallel_automatic_tuning |
FALSE |
|
parallel_degree_level |
100 |
|
parallel_degree_limit |
CPU |
|
parallel_degree_policy |
MANUAL |
|
parallel_execution_message_size |
16384 |
|
parallel_force_local |
FALSE |
|
parallel_instance_group |
|
|
parallel_io_cap_enabled |
FALSE |
|
parallel_max_servers |
221 |
|
parallel_min_percent |
0 |
|
parallel_min_servers |
64 |
|
parallel_min_time_threshold |
AUTO |
|
parallel_server |
FALSE |
|
parallel_server_instances |
1 |
|
parallel_servers_target |
256 |
|
parallel_threads_per_cpu |
2 |
|
pdb_file_name_convert |
|
|
pdb_lockdown |
|
|
pdb_os_credential |
|
|
permit_92_wrap_format |
TRUE |
|
pga_aggregate_limit |
24704M |
|
pga_aggregate_target |
0 |
|
plscope_settings |
Identifiers:All |
|
plsql_ccflags |
|
|
plsql_code_type |
INTERPRETED |
|
plsql_debug |
FALSE |
|
plsql_optimize_level |
2 |
|
plsql_v2_compatibility |
false |
|
plsql_warnings |
DISABLE:ALL |
|
pre_page_sga |
TRUE |
|
processes |
300 |
|
processor_group_name |
|
|
query_rewrite_enabled |
TRUE |
|
query_rewrite_integrity |
Enforced |
|
rdbms_server_dn |
|
|
read_only_open_delayed |
FALSE |
|
recovery_parallelism |
0 |
|
recyclebin |
On |
|
redo_transport_user |
|
|
remote_dependencies_mode |
TIMESTAMP |
|
remote_listener |
|
|
remote_login_passwordfile |
EXCLUSIVE |
|
remote_os_authent |
FALSE |
|
remote_os_roles |
FALSE |
|
replication_dependency_tracking |
TRUE |
|
resource_limit |
TRUE |
|
resource_manager_cpu_allocation |
16 |
|
resource_manager_plan |
|
|
result_cache_max_result |
5 |
|
result_cache_max_size |
49504K |
|
result_cache_mode |
MANUAL |
|
result_cache_remote_expiration |
0 |
|
resumable_timeout |
0 |
|
rollback_segments |
|
|
sec_case_sensitive_logon |
TRUE |
|
sec_max_failed_login_attempts |
3 |
|
sec_protocol_error_further_action |
(DROP,3) |
|
sec_protocol_error_trace_action |
TRACE |
|
sec_return_server_release_banner |
FALSE |
|
serial_reuse |
Disable |
|
service_names |
ora12c |
|
session_cached_cursors |
50 |
|
session_max_open_files |
10 |
|
sessions |
480 |
|
sga_max_size |
19328M |
|
sga_target |
0 |
|
shadow_core_dump |
Partial |
|
shared_memory_address |
0 |
|
shared_pool_reserved_size |
57042534 |
|
shared_pool_size |
0 |
|
shared_server_sessions |
|
|
shared_servers |
1 |
|
skip_unusable_indexes |
TRUE |
|
smtp_out_server |
|
|
sort_area_retained_size |
0 |
|
sort_area_size |
65536 |
|
spatial_vector_acceleration |
FALSE |
|
spfile |
/u01/app/oracle/product/12.1.0/dbs/spfileora12c.ora |
|
sql92_security |
FALSE |
|
sql_trace |
FALSE |
|
sqltune_category |
DEFAULT |
|
standby_archive_dest |
?/dbs/arch |
|
standby_file_management |
MANUAL |
|
star_transformation_enabled |
FALSE |
|
statistics_level |
TYPICAL |
|
streams_pool_size |
0 |
|
tape_asynch_io |
TRUE |
|
temp_undo_enabled |
FALSE |
|
thread |
0 |
|
threaded_execution |
FALSE |
|
timed_os_statistics |
0 |
|
timed_statistics |
TRUE |
|
trace_enabled |
TRUE |
|
tracefile_identifier |
|
|
transactions |
528 |
|
transactions_per_rollback_segment |
5 |
|
undo_management |
AUTO |
|
undo_retention |
900 |
|
undo_tablespace |
UNDOTBS1 |
|
unified_audit_sga_queue_size |
1048576 |
|
use_dedicated_broker |
FALSE |
|
use_indirect_data_buffers |
FALSE |
|
use_large_pages |
TRUE |
|
user_dump_dest |
/u01/app/oracle/product/12.1.0/rdbms/log |
|
utl_file_dir |
|
|
workarea_size_policy |
AUTO |
|
xml_db_events |
Enable |
|
FORCE_LOGGING |
NO |
BDNA Data Platform 5.5 Installation Help LibraryJune 2021 |
Copyright Information | Flexera |