The following query Listing 1 shows which table Spaces use which buffer pools.
2
如果小型表拥有自己的缓冲池,那么它们就必须拥有自己的表空间,因此大型查询就不能覆盖它们的页。
If the small tables have their own buffer pool, thereby making it necessary for them to have their own table space, their pages cannot be overwritten by the large query.
3
清单9显示如何查询一个表空间的状态,从而了解CHECK PENDING的状态。
Listing 9 shows how you can query status of a table space to know about CHECK PENDING status.