--alter system set nls_language='SIMPLIFIED CHINESE' scope=spfile
--/
--alter system set nls_territory='CHINA' scope=spfile
--/
alter system set db_16k_cache_size=128M scope=spfile
/
alter system set db_2k_cache_size=208M scope=spfile
/
--SQLNET.INBOUND_CONNECT_TIMEOUT parameter in sqlnet.ora ; default 60 seconds; SNIPED
--SQLNET.INBOUND_CONNECT_TIMEOUT=1000
alter system set resource_limit=true scope=both
/
alter system set processes=2000 scope=spfile
/
--并行
alter system set parallel_degree_policy=auto scope=both
/
alter system set db_recovery_file_dest_size=200G scope=both
/
alter system set db_writer_processes=4 scope=spfile
/
alter system set plsql_optimize_level=3 scope=both
/
alter system set plsql_code_type=native scope=both
/
alter system set result_cache_max_size=50M scope=both
/
alter system set log_buffer=65535000 sc
Oracle系统参数调整实操--小记
最新推荐文章于 2024-07-27 11:28:37 发布