Result Cache is not enabled by default but is a such amazing feature that can make your 3 hours query run in less than 1 second after the first call. However, your result set need to be short and the tables involved might not be modified so often.
The Oracle official documentation for Result Caches is short. So read it, practice and you will be ready.
What you need to know:
- How to enable it.
- Using the RESULT_CACHE Hint;
- The 3 Result Cache parameters.
- DBMS_RESULT_CACHE package.
- Result Cache Modes (MANUAL/FORCE)
- Table Annotations.
- Client Result Cache.
- Querying dictionary views to retrieve some information.
- When it is not going to work?
Path to Documentation:
Performance Tuning Guide -> 7.6 Managing the Server and Client Result Caches
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
