因为db2缓冲池是系统主内存的一部分,DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
该代理的 Informix 端口中使用的表的实际模式(清单 1)包括分配和使用多少虚拟内存。
The actual schema of the table (Listing 1) used in the Informix port of this agent includes how much virtual memory is allocated and used.
如果无法将排序的数据整个放入排序堆中(排序堆是每次执行排序时分配的一块内存),它就会溢出到该数据库所有的临时表中。
If the sorted data cannot fit entirely into the sort heap, which is a block of memory that is allocated each time a sort is performed, it overflows into a temporary table owned by the database.
应用推荐