Shared Pool\u7684\u5927\u5c0f\u8bbe\u7f6e\u89c4\u5219\u5982\u4e0b\uff1a<\/p>\n
1.\u67e5\u5230shared pool\u8bbe\u7f6e\u7684\u5408\u7406\u503c\uff0c\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n
select ‘Shared Pool’ component,<\/p>\n
shared_pool_size_for_estimate estd_sp_size,<\/p>\n
estd_lc_time_saved_factor parse_time_factor,<\/p>\n
case<\/p>\n
when current_parse_time_elapsed_s + adjustment_s < 0 THEN<\/p>\n
0<\/p>\n
ELSE<\/p>\n
current_parse_time_elapsed_s + adjustment_s<\/p>\n
END response_time<\/p>\n
FROM (select shared_pool_size_for_estimate,<\/p>\n
shared_pool_size_factor,<\/p>\n
estd_lc_time_saved_factor,<\/p>\n
a.estd_lc_time_saved,<\/p>\n
e.VALUE \/ 100current_parse_time_elapsed_s,<\/p>\n
c.estd_lc_time_saved – a.estd_lc_time_saved adjustment_s<\/p>\n
from v$shared_pool_advice a,<\/p>\n
(select * from v$sysstat where NAME = ‘parse time elapsed’) e,<\/p>\n
(select estd_lc_time_saved<\/p>\n
from v$shared_pool_advice<\/p>\n
where shared_pool_size_factor = 1) c);<\/p>\n
2.\u8bbe\u7f6e\u4e0a\u4e2aSQL\u8bed\u53e5\u4e2d\u67e5\u5230\u7684PARSE_TIME_FACTOR\u9996\u6b21\u7b49\u4e8e1\u7684\u8bb0\u5f55\u6240\u5728\u884c\u7684ESTD_SP_SIZE\u7684\u503c\u4e3ashared pool\u3002<\/p>\n
3.\u8bbe\u7f6e\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n
alter system set shared_pool_size=XXX scope=spfile;\u6216\u8005alter system set shared_pool_size=XXX scope=both;<\/p>\n","protected":false},"excerpt":{"rendered":"
Shared Pool\u7684\u5927\u5c0f\u8bbe\u7f6e\u89c4\u5219\u5982\u4e0b\uff1a 1.\u67e5\u5230shared pool\u8bbe\u7f6e\u7684\u5408\u7406\u503c\uff0c\u8bed\u53e5\u5982\u4e0b\uff1a selec … \u7ee7\u7eed\u9605\u8bfbOracle\u8bbe\u7f6eShared Pool\u7684\u5927\u5c0f<\/span>