Result_cache Hint Is Not Being Enforced

(Doc ID 874022.1)

Last updated on OCTOBER 26, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 26-Oct-2016***


The result_cache hint did not produce the expected result cache operation in one specific SQL statement, for example.

SQL> connect scott/tiger 
SQL> set autotrace traceonly 
SQL> select /*+ result_cache */ deptno, avg(sal) 
  2  from emp 
  3  where hiredate > sysdate 
  4  group by deptno; 

no rows selected 
Execution Plan 
Plan hash value: 15469362 

| Id  | Operation          | Name | 
|   0 | SELECT STATEMENT   |      | 
|   1 |  SORT GROUP BY     |      | 
|*  2 |   TABLE ACCESS FULL| EMP  | 


Testing with the result_cache hint for the first time.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms