Increase Data Server Database Caches for ECP Control Structures
In addition to buffering the blocks that are served over ECP, data servers use global buffers to store various ECP control structures. There are several factors that go into determining how much memory these structures might require, but the most significant is a function of the aggregate sizes of the clients' caches. To roughly approximate the requirements, so you can adjust the data server’s database caches if needed, use the following guidelines:
| Database Block Size |
Recommendation |
| 8 KB |
50 MB plus 1% of the sum of the sizes of all of the application servers’ 8 KB database caches |
| 16 KB (if enabled) |
0.5% of the sum of the sizes of all of the application servers’ 16 KB database caches |
| 32 KB (if enabled) |
0.25% of the sum of the sizes of all of the application servers’ 32 KB database caches |
| 64 KB (if enabled) |
0.125% of the sum of the sizes of all of the application servers’ 64 KB database caches |
For example, if the 16 KB block size is enabled in addition to the default 8 KB block size, and there are six application servers, each with an 8 KB database cache of 2 GB and a 16 KB database cache of 4 GB, you should adjust the data server’s 8 KB database cache to ensure that 52 MB (50MB + [12 GB * .01]) is available for control structures, and the 16 KB cache to ensure that 2 MB (24 GB * .005) is available for control structures (rounding up in both cases).
For information about allocating memory to database caches, see Memory and Startup Settings.
