Problem Statement: Problem Statement

Thru onstat –g ckp utility:

• Look for a “Trigger” of “Llog” with “Block Time” > 0.0

Dynamic Buffer pools have been requested for a while by our users.

• Dynamic Buffer pools have been requested for a while by our users.

• We will therefore add the ability to dynamically extend a buffer pool and do so automatically, which will allow us to start with relatively small pools and increase the size of the pools only as needed.

• This will improve performance in many cases by getting the memory resources necessary to the database server it needs, if available, to increase application transaction performance much sooner, in near real-time, rather than after the fact, which has been the norm.

Three goals:

•