Oracle database 11gr2 的典型参数文件

*._allow_level_without_connect_by=TRUE
*._gc_policy_time=0
*._gc_undo_affinity=FALSE
*.archive_lag_target=600
*.audit_file_dest='/u01/app/oracle/admin/abcdb/adump'
*.audit_sys_operations=TRUE
*.audit_trail='DB_EXTENDED'
*.compatible='11.2.0.4.0'
*.control_file_record_keep_time=100
*.control_files='/u01/app/oracle/abcdb/cont_1.ctl','/u02/abcdb/cont_2.ctl'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_domain=''
*.db_flashback_retention_target=3000
*.db_name='abcdb'
*.db_recovery_file_dest='/oraarchlog/recov'
*.db_recovery_file_dest_size=8489271296
*.db_securefile='ALWAYS'
*.db_unique_name='abcdb'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=abcdbXDB)'
*.event='28401 trace name context forever,level 1','10949 trace name context forever,level 1'
*.java_jit_enabled=TRUE
*.job_queue_processes=50
*.log_archive_dest_1='LOCATION=/oraarchlog/abcdb/'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=4
*.open_cursors=1000
*.open_links=100
*.open_links_per_instance=200
*.optimizer_index_cost_adj=30
*.pga_aggregate_target=10737418240
*.processes=2000
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=false
*.service_names='abc','abcdb'
*.session_cached_cursors=200
*.sessions=1000
*.sga_max_size=34359738368
*.sga_target=34359738368
*.undo_retention=3600
*.undo_tablespace='UNDOTBS'
原文地址:https://www.cnblogs.com/ctypyb2002/p/9793152.html