caching - Why is the result cache always disabled in Oracle 11g -
i'm trying enable result cache in oracle 11g. have used enterprise manager change result_cache_max_size , result_cache_max_result values '1m' , '100' respectively (maybe these aren't optimal settings, i'm trying work!). after make these changes use following query see if changes have been made: select * v$parameter lower("name") '%result_cache%'; i can see both have been set correctly. however, when run queries result_cache hint, can see autotrace cache isn't being used. if run following query: select dbms_result_cache.status() dual; i can see it's status 'disabled'. restarting database makes result_cache_max_size parameter go 0 (disabled). how can enable result cache? as can see comments, it's because result cache enterprise edition feature , have standard edition.