Result_cache Hint Is Not Being Enforced (Doc ID 874022.1)

Last updated on OCTOBER 26, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [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***

Symptoms

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

SQL> connect scott/tiger 
Connected. 
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  | 
-----------------------------------

Changes

Testing with the result_cache hint for the first time.

Cause

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