*.db_cache_size=419430400
*.Db_keep_cache_size=0
*.Db_recycle_cache_size=0
*.db_nk_cache_size=0
今天发现我们的一个正式环境里面 标记为红色的 三个参数 居然为0我不知道会造成什么样的影响?
或者说这4个参数又什么用 又该怎么设置多大为好?
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
# prtdiag -v
System Configuration: Sun Microsystemssun4u Sun Fire V250
System clock frequency: 160 MHZ
Memory size: 8GB