Oracle设置Shared Pool的大小

在Oracle 10G或者11G版本中，如何合理设置shared pool大小，对Oracle数据库的性能影响很大。Shared Pool的大小设置规则如下：1.查到shared pool设置的合理值，语句如下：select "Shared Pool" component,shared_pool_size_for_estimate estd_sp_size,estd_lc_time_saved_factor parse_time_factor,casewhen current_parse_time_elapsed_s + adjustment_s < 0 THEN0ELSEcurrent_parse_time_elapsed_s + adjustment_sEND response_timeFROM （select shared_pool_size_for_estimate,shared_pool_size_factor,estd_lc_time_saved_factor,a.estd_lc_time_saved,e.VALUE / 100current_parse_time_elapsed_s,c.estd_lc_time_saved - a.estd_lc_time_saved adjustment_sfrom v$shared_pool_advice a,（select * from v$sysstat where NAME = "parse time elapsed"） e,（select estd_lc_time_savedfrom v$shared_pool_advicewhere shared_pool_size_factor = 1） c）;2.设置上个SQL语句中查到的PARSE_TIME_FACTOR首次等于1的记录所在行的ESTD_SP_SIZE的值为shared pool。3.设置语句如下：alter system set shared_pool_size=XXX scope=spfile;或者alter system set shared_pool_size=XXX scope=both;在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htmOracle性能优化之共享池 http://www.linuxidc.com/Linux/2012-02/54062.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址