Tuning the package cache (pckcachesz).
调优包缓存器(pckcachesz)。
Catalog cache, package cache, and log buffer.
目录缓存器、包缓存器和日志缓冲区。
To address the second issue, DB2 USES its package cache.
为了解决第二个问题,DB 2使用了包缓存。
M - Section is obtained from the in-memory package cache.
M—片段是从内存中的包缓存获得的。
Examining frequently used SQL statements from the package cache.
检查来自包缓存的常用sql语句。
Package cache (controlled by the pckcachesz configuration parameter).
包缓存(由pckcachesz配置参数控制)。
Dbrun.snap - This script provides the hit ratio for the package cache.
perl packhitratio . pl dbrun. snap——该脚本提供了包缓存器的命中率。
The package cache hit ratio can be calculated using the following formula.
可使用下列公式计算包缓存器的命中率。
When the statement is compiled, its access plan is stored in the package cache.
在编译语句时,语句的访问计划被存储在包缓存中。
Package and catalog caches, and workspaces (for example, package cache hit ratio)
包与目录缓存,以及工作空间(如包高速缓冲区命中率)。
Package Cache - Memory allocated to store both static and dynamic SQL statements.
包缓存——为存储静态和动态sql语句而分配的内存。
Therefore, the sizes for package cache and catalog can vary depending on the value of maxappls.
因此,包缓存和编目的大小可以随着 maxappls的值而变化。
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 package cache sets the amount of database global memory to be used for caching a package's static and dynamic SQL statements.
包缓存器设置数据库全局内存的总量以用于缓存程序包的静态和动态sql语句。
If the same INSERT statement is executed repeatedly, its access plan will (usually) be found in the package cache and the compilation cost is avoided.
如果重复地执行相同的insert语句,则该语句的访问计划(通常)会进入到包缓存中,这样就免除了编译的开销。
The DB2 optimizer stores the access plan created in the prepare phase in the SQL statement cache (also called package cache in DB2) for reuse purposes.
DB 2优化器将准备阶段中创建的访问计划存储在sql语句缓存(在DB 2中也称为包缓存)中以便重用。
You can also run a report based on the recently executed queries that still reside in the package cache using the following form of the db2advis utility.
还可以使用如下形式的db2advis实用工具基于尚处于包缓存中的最新执行的查询运行一个报告。
Use the FLUSH package command to remove all cached dynamic SQL statements currently in the package cache and force the next request to be implicitly compiled.
使用FLUSHPACKAGE命令来删除包缓存器中当前所有缓存的动态sql语句,并强制隐式地编译下一请求。
Also, because Lotus Domino generates many different unique SQL statements for accessing data in DB2, we increased the package cache specified by database configuration parameter PCKCACHESZ to 400 MB.
此外,因为LotusDomino生成许多不同的惟一sql语句来访问DB 2中的数据,我们将数据库配置参数pckcachesz指定的软件包高速缓存增加为400MB。
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).
其他更改主要针对将可用内存划分出一些必要的缓存,例如包缓存和编目缓存,或者调整短事务的设置(日志记录和排序)。
An opcode cache — and an opcode optimizer, which is often provided in the same package — is a dirt-cheap technique to hasten the responsiveness of your site.
操作码缓存——以及一个操作码优化器,通常由相同的包提供——是一种加快站点响应的低成本技术。
This is a new package added in JAXP 1.3. It defines an API that allows applications to cache schemas (such as W3C XML Schemas) and use them for validation of XML documents.
validation:也是JAXP 1.3中新增的一个包,它定义了用于应用程序缓冲模式(比如W3CSchema)和验证XML 文档的API。
Use RowSet which in JDBC expand package to cache ResultSet;
使用JDBC扩展包中的行集来缓存结果集;
Package discarding is occurred when no backup routings exist in node cache, and a route error message is send to source node, then a new routing discover process will begin.
只有当没有后备路由存在时,才丢弃数据分组,并且向源节点发送一个路由错误信息,这时再由源节点发起一次路由寻找过程。
Package discarding is occurred when no backup routings exist in node cache, and a route error message is send to source node, then a new routing discover process will begin.
只有当没有后备路由存在时,才丢弃数据分组,并且向源节点发送一个路由错误信息,这时再由源节点发起一次路由寻找过程。
应用推荐