Supported Oracle Initialization Parameters
Go Up to Parameters, Arguments, Options, and Variables Appendix
The following parameters are available from the Explorer’s Configuration node. For information on working with these parameters, see Working with Configuration/initialization Parameters.
|
O7_DICTIONARY_ACCESSIBILITY |
active_instance_count |
aq_tm_processes |
|
archive_lag_target |
asm_diskgroups |
asm_diskstring |
|
asm_power_limit |
asm_preferred_read_failure_groups |
audit_file_dest |
|
audit_sys_operations |
audit_trail |
background_core_dump |
|
background_dump_dest |
backup_tape_io_slaves |
bitmap_merge_area_size |
|
blank_trimming |
buffer_pool_keep |
buffer_pool_recycle |
|
circuits |
client_result_cache_lag |
client_result_cache_size |
|
cluster_database |
cluster_database_instances |
cluster_interconnects |
|
commit_logging |
commit_point_strength |
commit_wait |
|
commit_write |
compatible |
control_file_record_keep_time |
|
control_files |
control_management_pack_access |
core_dump_dest |
|
cpu_count |
create_bitmap_area_size |
create_stored_outlines |
|
cursor_sharing |
cursor_space_for_time |
db_16k_cache_size |
|
db_2k_cache_size |
db_32k_cache_size |
db_4k_cache_size |
|
db_8k_cache_size |
db_block_buffers |
db_block_checking |
|
db_block_checksum |
db_block_size |
db_cache_advice |
|
db_cache_size |
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 |
|
db_file_name_convert |
db_files |
db_flashback_retention_target |
|
db_keep_cache_size |
db_lost_write_protect |
db_name |
|
db_recovery_file_dest |
db_recovery_file_dest_size |
db_recycle_cache_size |
|
db_securefile |
db_ultra_safe |
db_unique_name |
|
db_writer_processes |
dbwr_io_slaves |
ddl_lock_timeout |
|
dg_broker_config_file1 |
dg_broker_config_file2 |
dg_broker_start |
|
diagnostic_dest |
disk_asynch_io |
dispatchers |
|
distributed_lock_timeout |
dml_locks |
drs_start |
|
enable_ddl_logging |
event |
fal_client |
|
fal_server |
fast_start_io_target |
fast_start_mttr_target |
|
fast_start_parallel_rollback |
file_mapping |
fileio_network_adapters |
|
filesystemio_options |
fixed_date |
gc_files_to_locks |
|
gcs_server_processes |
global_context_pool_size |
global_names |
|
global_txn_processes |
hash_area_size |
hi_shared_memory_address |
|
hs_autoregister |
ifile |
instance_groups |
|
instance_name |
instance_number |
instance_type |
|
java_jit_enabled |
java_max_sessionspace_size |
java_pool_size |
|
java_soft_sessionspace_limit |
job_queue_processes |
large_pool_size |
|
ldap_directory_access |
ldap_directory_sysauth |
license_max_sessions |
|
license_max_users |
license_sessions_warning |
local_listener |
|
lock_name_space |
lock_sga |
log_archive_config |
|
log_archive_dest |
log_archive_dest_1 |
log_archive_dest_10 |
|
log_archive_dest_2 |
log_archive_dest_3 |
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 |
|
log_archive_dest_state_10 |
log_archive_dest_state_2 |
log_archive_dest_state_3 |
|
log_archive_dest_state_4 |
log_archive_dest_state_5 |
log_archive_dest_state_6 |
|
log_archive_dest_state_7 |
log_archive_dest_state_8 |
log_archive_dest_state_9 |
|
log_archive_duplex_dest |
log_archive_format |
log_archive_local_first |
|
log_archive_max_processes |
log_archive_min_succeed_dest |
log_archive_start |
|
log_archive_trace |
log_buffer |
log_checkpoint_interval |
|
log_checkpoint_timeout |
log_checkpoints_to_alert |
log_file_name_convert |
|
max_commit_propagation_delay |
max_dispatchers |
max_dump_file_size |
|
max_enabled_roles |
max_shared_servers |
memory_max_target |
|
memory_target |
nls_calendar |
nls_comp |
|
nls_currency |
nls_date_format |
nls_date_language |
|
nls_dual_currency |
nls_iso_currency |
nls_language |
|
nls_length_semantics |
nls_nchar_conv_excp |
nls_numeric_characters |
|
nls_sort |
nls_territory |
nls_time_format |
|
nls_time_tz_format |
nls_timestamp_format |
nls_timestamp_tz_format |
|
object_cache_max_size_percent |
object_cache_optimal_size |
olap_page_pool_size |
|
open_cursors |
open_links |
open_links_per_instance |
|
optimizer_capture_sql_plan_baselines |
optimizer_dynamic_sampling |
optimizer_features_enable |
|
optimizer_index_caching |
optimizer_index_cost_adj |
optimizer_mode |
|
optimizer_secure_view_merging |
optimizer_use_invisible_indexes |
optimizer_use_pending_statistics |
|
optimizer_use_sql_plan_baselines |
os_authent_prefix |
os_roles |
|
parallel_adaptive_multi_user |
parallel_automatic_tuning |
parallel_execution_message_size |
|
parallel_instance_group |
parallel_io_cap_enabled |
parallel_max_servers |
|
parallel_min_percent |
parallel_min_servers |
parallel_server |
|
parallel_server_instances |
parallel_threads_per_cpu |
pga_aggregate_target |
|
plscope_settings |
plsql_ccflags |
plsql_code_type |
|
plsql_debug |
plsql_native_library_dir |
plsql_native_library_subdir_count |
|
plsql_optimize_level |
plsql_v2_compatibility |
plsql_warnings |
|
pre_page_sga |
processes |
query_rewrite_enabled |
|
query_rewrite_integrity |
rdbms_server_dn |
read_only_open_delayed |
|
recovery_parallelism |
recyclebin |
redo_transport_user |
|
remote_dependencies_mode |
remote_listener |
remote_login_passwordfile |
|
remote_os_authent |
remote_os_roles |
replication_dependency_tracking |
|
resource_limit |
resource_manager_cpu_allocation |
resource_manager_plan |
|
result_cache_max_result |
result_cache_max_size |
result_cache_mode |
|
result_cache_remote_expiration |
resumable_timeout |
rollback_segments |
|
sec_case_sensitive_logon |
sec_max_failed_login_attempts |
sec_protocol_error_further_action |
|
sec_protocol_error_trace_action |
sec_return_server_release_banner |
serial_reuse |
|
service_names |
session_cached_cursors |
session_max_open_files |
|
sessions |
sga_max_size |
sga_target |
|
shadow_core_dump |
shared_memory_address |
shared_pool_reserved_size |
|
shared_pool_size |
shared_server_sessions |
shared_servers |
|
skip_unusable_indexes |
smtp_out_server |
sort_area_retained_size |
|
sort_area_size |
spfile |
sql92_security |
|
sql_trace |
sql_version |
sqltune_category |
|
standby_archive_dest |
standby_file_management |
star_transformation_enabled |
|
statistics_level |
streams_pool_size |
tape_asynch_io |
|
thread |
timed_os_statistics |
timed_statistics |
|
trace_enabled |
tracefile_identifier |
transactions |
|
transactions_per_rollback_segment |
undo_management |
undo_retention |
|
undo_tablespace |
use_indirect_data_buffers |
user_dump_dest |
|
utl_file_dir |
workarea_size_policy |
xml_db_events |