Result_cache Hint Is Not Being Enforced
(Doc ID 874022.1)
Last updated on AUGUST 09, 2018
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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |