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
posted @ 2007-01-11 17:11  城市里的鱼  阅读(297)  评论(0)    收藏  举报