2 Replies Latest reply: Aug 5, 2011 4:33 PM by 880337 RSS

    How to Enable Result Cache in 11g XE ?

    880337
      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