Re: Re: Re: Re: Recursive statements slowing down batch processing

From: <l.flatz_at_bluewin.ch>
Date: Tue, 11 Oct 2016 15:29:13 +0000
Message-ID: <21438702.34760.1476199753559.JavaMail.webmail_at_bluewin.ch>


Hi Stefan,

that one seems tough . Any idea? Need to do some tests ...

Regards

Lothar
----Ursprüngliche Nachricht----
Von : contact_at_soocs.de
Datum : 11/10/2016 - 17:14 (UTC)
An : l.flatz_at_bluewin.ch, martin.a.berger_at_gmail.com Cc : oracle-l_at_freelists.org, Christian.Antognini_at_trivadis.com 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: _at_OracleSK  

> "l.flatz_at_bluewin.ch" <l.flatz_at_bluewin.ch> 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
 

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 11 2016 - 17:29:13 CEST

Original text of this message