|Cross-Session PL/SQL Function Result Cache in Oracle Database 11g Release 1 - Improve the performance of PL/SQL functions across the whole database instance by caching return values.|
Ligarius said...Nice note Tim
Thank you very much
Hector Gabriel Ulloa Ligarius
Santiago , Chile
Tapesh said...Nice man, good job
Lesio said...It's very interesting especially last part meaning database can produce wrong, inconsistent data after patching code as default. Looks like very dangerous option.
11.2 automatically track dependencies so the RELIES ON clause is no longer needed. As a result you are less likely to make mistakes and screw stuff up. :)
PS. I made a note of it in the article.
Mansi said...Thanks Tom
It is really helpful.
Mansi said...Thanks Tim
Sorry for misspelling your name