Hi Stefan,
that one seems tough . Any idea? Need to do some tests ...
Regards
Lothar
----Ursprüngliche Nachricht----
Von : contact@xxxxxxxx
Datum : 11/10/2016 - 17:14 (UTC)
An : l.flatz@xxxxxxxxxx, martin.a.berger@xxxxxxxxx
Cc : oracle-l@xxxxxxxxxxxxx, Christian.Antognini@xxxxxxxxxxxx
Betreff : Re: Re: Re: Recursive statements slowing down batch processing
Hey Martin and Lothar,
well the issue that the result_cache hint was not considered via SQL patch was
fixed by patch for bug #16974854. There are one-off patches and it is
already included in 12.1.0.2. However in this special case another result cache
limitation kicks in:
http://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm#TGDBA646
Results cannot be cached when the following objects or functions are in a query:
* Temporary tables and tables in the SYS or SYSTEM schemas
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
"l.flatz@xxxxxxxxxx" <l.flatz@xxxxxxxxxx> hat am 11. Oktober 2016 um 17:00
geschrieben:
Hi Martin,
the result cache hint is a differnt kind of beast though. Chris can sheed
some light on it.
Regards
Lothar