1.查看shared pool共享池合适的配置参数：
select 'Shared Pool' component,
       shared_pool_size_for_estimate estd_sp_size,
       estd_lc_time_saved_factor parse_time_factor,
       case
         when current_parse_time_elapsed_s + adiustment_s < 0 then
          0
         else
          current_parse_time_elapsed_s + adiustment_s
       end response_time
  from (select shared_pool_size_for_estimate,
               shared_pool_size_factor,
               estd_lc_time_saved_factor,
               a.estd_lc_time_saved,
               e.VALUE / 100 current_parse_time_elapsed_s,
               c.estd_lc_time_saved - a.estd_lc_time_saved adiustment_s
          from v$shared_pool_advice a,
               (select * from v$sysstat where NAME = 'parse time elapsed') e,
               (select estd_lc_time_saved
                  from v$shared_pool_advice
                 where shared_pool_size_factor = 1) c);
2.