Dynamic Statements Cache: Everything You Need To Know

Tuesday, 16 lipanj, 2009 - 09:00 - 10:00
Namik Hrle

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

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

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.



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2022

VODICE -  13th - 16th June 2022