比较缓冲池的应用程序命中率。
将 WWEC添加到池的输入队列。
推荐:请调整连接池的最大值和最小值。
Recommendation: Adjust the maximum and minimum sizes of the connection pool.
推荐:请调整ORB线程池的大小。
对xa事务和连接池的支持。
有效使用线程池的准则。
要解决这个问题,可以减少主缓冲池的大小。
To resolve this problem, reduce the size of main buffer pools.
下面给出了关于分配多个缓冲池的一般建议。
The general recommendations for allocating multiple buffer pools include the following.
使用缓冲池的表空间数
可以通过这些类检索和更改系统池的名称和大小。
Using these classes, the name and size of the pool can be retrieved and changed.
它包含表、索引、表空间和缓冲池的控制块信息。
It contains control block information for tables, indexes, table Spaces, and buffer pools.
这时,应该连接到数据库,并减少主缓冲池的大小。
When this happens, you should connect to the database and reduce the size of the main buffer pools.
LPAR工作集偶尔会增长,略微超过池的大小。
There were rare occasions where the LPARs working set would grow and be slightly larger than the size of the pool.
所以,可能需要提高连接池的平均大小或连接数量。
As a result, you might need to increase the average size of the connection pool or number of connections.
前面已提到,ESTORE是用于扩展缓冲池的大小。
It is mentioned earlier that ESTORE is used to extend the size of a buffer pool.
清单3将示范如何利用JDBC对预备语句池的支持。
Listing 3 demonstrates how to take advantage of JDBC's prepared statement pooling support.
将所有数据库缓冲池的大小设置为AUTOMATIC。
具有大型缓冲池的环境也可能需要配置更多页面清洗器。
Environments with large buffer pools might also require more page cleaners to be configured.
连接成功之后,下一个屏幕提供这个数据库池的部署选项。
Once the connection is successful, the next screen provides the deployment option for this database pool.
它创建的分页设备的大小等于共享内存池的最大内存值。
It creates a paging device of equal size to that of the maximum memory value of the Shared memory pool.
应当根据取自测试环境的快照信息来决定缓冲池的大小。
The buffer pool sizes should be determined based on snapshot information taken from the test environment.
然而,这也使得数据池的最大容量依赖于可用的内存总量。
However, it also makes the maximum size of the data pool dependent on the amount of available RAM.
您可能会想到:可以配置消息传递引擎可用的线程池的大小。
And, you guessed it: you can configure the size of the thread pool that is available to a messaging engine.
您还可以研究池的一些属性,如清单3所示,其代表默认值。
You can also investigate some of the attributes of your pool, as shown in Listing 3, which represent the defaults.
目标服务器上共享内存池的大小不必与源服务器上的相同。
The size of the Shared memory pool on the target server does not have to be the same as on the source server.
关于系统配置的信息包括缓冲池的大小、排序堆的大小等等。
Information about system configuration can include the size of the buffer pool, the sort heap, and more.
表3列出了最常调优的线程池的默认线程池大小和静止超时。
Table 3 shows the default thread pool sizes and inactivity timeouts for the most commonly tuned thread pools.
在具有大缓冲池的环境下,也可能需要配置较多的页清除程序。
Environments with large buffer pools may also require more page cleaners to be configured.
由这个结果可知,当磁盘的负载较小时,缓冲池的效率就越高。
This result leads us to believe that the buffer pool was more effective when the disks were less taxed.
由这个结果可知,当磁盘的负载较小时,缓冲池的效率就越高。
This result leads us to believe that the buffer pool was more effective when the disks were less taxed.
应用推荐