sqlplus /nolog
conn / as sysdba
create pfile='...' from spfile;
change the parameter in the pfileshutdown immediatestartup pfile='...'
create spfile from pfile='...'shutdown immediate
startup
conn / as sysdba
create pfile='...' from spfile;
change the parameter in the pfileshutdown immediatestartup pfile='...'
create spfile from pfile='...'shutdown immediate
startup
db_cache_size = 629145600(600M)
shared_pool_size = 209715200 (200M)
large_pool_size = 614400 //如果用的MTS,太小了10M-50M(UGA 放到里面)
java_pool_size = 20971520 //没用java,调小一点
processes = 80 //好象小了些
log_buffer = 5242880 //3M足矣
db_block_size = 8192
db_writer_processes =2 //单CPU设置1就行了
open_cursors = 1000
cursor_sharing = similar
session_cached_cursor = 300
workarea_size_policy = auto
pga_aggregate_target = 250M
pre_page_sga = true(win2000下参数)
lock_sga = true //window下没用
越详细越好,先谢谢了