包缓存器设置数据库全局内存的总量以用于缓存程序包的静态和动态sql语句。
The package cache sets the amount of database global memory to be used for caching a package's static and dynamic SQL statements.
内存影响客户端连接的数量、缓冲池的大小,以及服务器分配的数据库缓存的大小。
Memory impacts the number of client connections and the size of the buffer pool and database cache allocated by the server.
将工作分区与它们的数据分区进行匹配,这将增加服务器缓存的命中概率,并减少对数据库的远程访问,后者会引起较大的延迟。
Matching work partitions to their data partitions will increase the probability of a cache hit within the server and decrease remote accesses to the database, which introduces quite a bit of latency.
应用推荐