初始化参数
参数名 值 默认值 动态
----------------------------------------------------------------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY FALSE TRUE FALSE
active_instance_count TRUE FALSE
aq_tm_processes 1 FALSE IMMEDIATE
archive_lag_target 0 TRUE IMMEDIATE
audit_file_dest ?/rdbms/audit TRUE FALSE
audit_sys_operations FALSE TRUE FALSE
audit_trail NONE TRUE FALSE
background_core_dump partial TRUE FALSE
background_dump_dest /oracle/admin/crdsdw/bdump FALSE IMMEDIATE
backup_tape_io_slaves FALSE TRUE DEFERRED
bitmap_merge_area_size 1048576 TRUE FALSE
blank_trimming FALSE TRUE FALSE
buffer_pool_keep TRUE FALSE
buffer_pool_recycle TRUE FALSE
circuits 335 TRUE FALSE
cluster_database FALSE TRUE FALSE
cluster_database_instances 1 TRUE FALSE
cluster_interconnects TRUE FALSE
commit_point_strength 1 TRUE FALSE
compatible 9.2.0.0.0 FALSE FALSE
control_file_record_keep_time 7 TRUE IMMEDIATE
control_files /ora_data/crdsdw/control01.ctl FALSE FALSE
control_files /ora_data/crdsdw/control02.ctl FALSE FALSE
control_files /ora_data/crdsdw/control03.ctl FALSE FALSE
core_dump_dest /oracle/admin/crdsdw/cdump FALSE IMMEDIATE
cpu_count 4 TRUE FALSE
create_bitmap_area_size 8388608 TRUE FALSE
cursor_sharing EXACT TRUE IMMEDIATE
cursor_space_for_time FALSE TRUE FALSE
db_16k_cache_size 0 TRUE IMMEDIATE
db_2k_cache_size 0 TRUE IMMEDIATE
db_32k_cache_size 0 TRUE IMMEDIATE
db_4k_cache_size 0 TRUE IMMEDIATE
db_8k_cache_size 0 TRUE IMMEDIATE
db_block_buffers 0 TRUE FALSE
db_block_checking FALSE TRUE IMMEDIATE
db_block_checksum TRUE TRUE IMMEDIATE
db_block_size 8192 FALSE FALSE
db_cache_advice ON TRUE IMMEDIATE
db_cache_size 1677721600 FALSE IMMEDIATE
db_create_file_dest TRUE IMMEDIATE
db_create_online_log_dest_1 TRUE IMMEDIATE
db_create_online_log_dest_2 TRUE IMMEDIATE
db_create_online_log_dest_3 TRUE IMMEDIATE
db_create_online_log_dest_4 TRUE IMMEDIATE
db_create_online_log_dest_5 TRUE IMMEDIATE
db_domain FALSE FALSE
db_file_multiblock_read_count 32 FALSE IMMEDIATE
db_file_name_convert TRUE FALSE
db_files 200 TRUE FALSE
db_keep_cache_size 0 TRUE IMMEDIATE
db_name crdsdw FALSE FALSE
db_recycle_cache_size 0 TRUE IMMEDIATE
db_writer_processes 1 TRUE FALSE
dblink_encrypt_login FALSE TRUE FALSE
dbwr_io_slaves 4 FALSE FALSE
dg_broker_config_file1 ?/dbs/dr1@.dat TRUE IMMEDIATE
dg_broker_config_file2 ?/dbs/dr2@.dat TRUE IMMEDIATE
dg_broker_start FALSE TRUE IMMEDIATE
disk_asynch_io TRUE TRUE FALSE
dispatchers (PROTOCOL=TCP) (SERVICE=crdsdwXDB) FALSE IMMEDIATE
distributed_lock_timeout 60 TRUE FALSE
dml_locks 1472 TRUE FALSE
drs_start FALSE TRUE IMMEDIATE
enqueue_resources 1692 TRUE FALSE
event TRUE FALSE
fal_client TRUE IMMEDIATE
fal_server TRUE IMMEDIATE
fast_start_io_target 0 TRUE IMMEDIATE
fast_start_mttr_target 300 FALSE IMMEDIATE
fast_start_parallel_rollback LOW TRUE IMMEDIATE
file_mapping FALSE TRUE IMMEDIATE
filesystemio_options asynch TRUE IMMEDIATE
fixed_date TRUE IMMEDIATE
gc_files_to_locks TRUE FALSE
global_context_pool_size TRUE FALSE
global_names FALSE TRUE IMMEDIATE