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