Thursday, November 13, 2014

Hinting the RESULT_CACHE in 12c

Tonight, we learn from a recent article by Christian Antognini about having a new undocumented parameter for the RESULT_CACHE hint!  While the obvious lessons (the RESULT_CACHE hint, the undocumented parameter) are in front of us, what is less obvious is examining in our own environments the table he investigates: v$result_cache_objects.  Will it solve a problem for you tomorrow?  Not very likely, but we need to keep adding to our toolboxes no?  A few years ago I would not be using v$sqlarea, v$session_longops, or any number of specific v$ objects if it was not for encountering them in one off instances but then revisiting them and learning from what they did or did not tell me.

No comments:

Post a Comment