Oracle系统参数调整实操--小记

--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