oracle服务器优化代码和服务器备份代码
oracle服务器优化 2G内存
alter system set sga_max_size=1353388680 scope=spfile;
alter system set db_cache_size=800m scope=spfile;====================
alter system set db_file_multiblock_read_count=32 scope=spfile;
alter system set large_pool_size=100m scope=spfile;================
alter system set log_buffer=1048576 scope=spfile;
alter system set open_cursors=600 scope=spfile;
alter system set sessions=300 scope=spfile;
alter system set processes=300 scope=spfile;
alter system set shared_pool_size=400m scope=spfile;==================
alter system set sort_area_size=1048576 scope=spfile;
==================
服务器备份代码
backup.bat
exp 'sys/7502 as sysdba' full=y file=E:\oracle_b\full.dmp
alter system set sga_max_size=1353388680 scope=spfile;
alter system set db_cache_size=800m scope=spfile;====================
alter system set db_file_multiblock_read_count=32 scope=spfile;
alter system set large_pool_size=100m scope=spfile;================
alter system set log_buffer=1048576 scope=spfile;
alter system set open_cursors=600 scope=spfile;
alter system set sessions=300 scope=spfile;
alter system set processes=300 scope=spfile;
alter system set shared_pool_size=400m scope=spfile;==================
alter system set sort_area_size=1048576 scope=spfile;
==================
服务器备份代码
backup.bat
exp 'sys/7502 as sysdba' full=y file=E:\oracle_b\full.dmp

浙公网安备 33010602011771号