Set the catalog cache, package cache, and log buffer size to an appropriate size to improve performance.
要设置大小适当的目录缓存器、包缓存器和日志缓冲区以提高性能。
Identify problems with memory, including low buffer pool hit ratios, catalog cache hit ratios, and package cache hit ratios.
识别内存问题,包括较低的缓冲池命中率、较低的目录缓存命中率和较低的包缓存命中率。
The catalog cache is used to store table descriptor information that is used when the tables, views, or alias have been referenced in previous statements.
目录缓存器用于存储表描述符信息,而在先前的语句中引用表、视图或别名时将使用该信息。
The other changes are primarily due to dividing up the available memory for necessary caches like the package and catalog cache or adjusting the Settings for short transactions (logging and sorting).
其他更改主要针对将可用内存划分出一些必要的缓存,例如包缓存和编目缓存,或者调整短事务的设置(日志记录和排序)。
Catalog cache, package cache, and log buffer.
目录缓存器、包缓存器和日志缓冲区。
Catalog cache hit ratio can be calculated by using the following formula.
可使用下列公式计算目录缓存器的命中率。
Catalog cache hit ratio can be calculated by using the following formula.
可使用下列公式计算目录缓存器的命中率。
应用推荐