然而,过多地分配空余空间可能会产生浪费的 DASD 空间,导致每次 I/O 只能传输更少的数据,缓冲池的利用效率更低,并且要扫描更多的页。
However, over-allocating free space may result in wasted DASD space, less data transferred per I/O, less efficient use of buffer pools and more pages to scan.
另一个极大影响性能的配置参数是数据库缓冲池大小。
Another configuration parameter that dramatically affects performance is the database buffer pool size.
拥有多个缓冲池可以将数据保存在缓冲区中。
Having more than one buffer pool can preserve data in the buffers.
应用推荐