Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle result cache and functions

rahulrasApr 27 2012 — edited May 1 2012

Hi All,

I am on 11.2 in Linux.

I want to use Oracle's result cache to cache results of (user defined) functions, which we use in SELECT commands.
My question is, does result caching work for deterministic and non-deterministic functions ?

Just curious, how Oracle keeps track of changes being made which affect a function's return value?
Thoughts please.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2012

Added on Apr 27 2012

#general-database-discussions

4 comments

344 views