This discussion is archived
2 Replies Latest reply: Aug 5, 2011 2:33 PM by 880337 RSS

How to Enable Result Cache in 11g XE ?

880337 Newbie
Currently Being Moderated
Does anyone know how to enable the result cache in 11g XE?

I've tired startup/shut down immediate with various ALTER SYSTEM commands (see below) but result_cache_max_size still defaults to zero when the database comes back up.

ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = SPFILE;

ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = BOTH;

ALTER SYSTEM RESET result_cache_max_size SCOPE = SPFILE SID='*';

Any advice would be helpful.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points