11gR2 Result Cache Opportunity
We just recently upgraded to 11gR2 and I've been studying the new result cache available. I've got a situation below where I think the application of the result cache would be ideal and just wanted to get some feedback-confirmation. The snippet of code is from a function and each line you see is a call to another function that returns a constant and fixed value. For instance, get_dec_storage_nbr just returns the number 98 (always has and always will). I'm thinking the result cache could be used in each on of these and used for caching the location within this calling
0