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.
In the [Licensing document|http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm#CJACGHEB] , in the 'performance' section of the table, the result cache is only available on Enterprise and not Standard, so I wouldn't expect it to work in Express Edition