Result cache

Result cache invalidation caused by DML locks

By Franck Pachot . In a previous post about Result Cache, I was using 'set autotrace on' in my session to see when the result cache hit saves the logical reads. I got a comment, by(…)

Result Cache: when *not* to use it

By Franck Pachot . I encountered recently a case where result cache was incorrectly used, leading to high contention when the application encountered a peak of load. It was not a surprise when I've seen that the function was called(…)

Result cache side effects on number of calls

By Franck Pachot . During the execution of a SQL statement, you cannot guess how many times an operation, a predicate, or a function will be executed. This depends on the execution plan, on some caching at execution, and some(…)

Result Cache and 12c ‘fetch first n rows’

By Franck Pachot . At our bi-annual dbiXchange I was talking with Nicolas Jardot about his presentation on Result Cache (don't forget Jérome witt session about RC at DOAG) where he has shown an unexpected behavior on(…)

‘Query result cache’ in Oracle 11g

Oracle has introduced three new caching features in its Oracle 11g release: Query result cache Client OCI result cache PL/SQL function result cache In this posting, I will present the query result cache feature.