Dynamic Statements Cache: Everything You Need To Know

Objectives:
Get a detailed understanding on how to get most out of the dynamic statements cache.

Outline:
How dynamic statements cache works
Virtual storage impact
Common access path challenges
Monitoring

Full Abstract:
The use of dynamic SQL continues to grow. Enterprise packaged applications as well as web applications use almost exclusively this flexible way of accessing databases. However, the flexibility is coupled with additional challenges when it comes to resources utilization, performance monitoring and tuning of SQL statements. This presentation focuses on dynamic statements cache – the key factor of a well performing dynamic statements environment. It covers all the relevant aspects of the statements cache: how it works, how to control its CPU and memory utilization, and how to monitor and tune it.