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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment