大池(Large pool size),是1个可选的内存区要是选择可对数据库象备份/恢复这些个大的操作提高机能要是不选择此参量,则体系会施用同享池ITPUB小我私人空...
基于12个网页-相关网页
However, if the total buffer size is too large, and there is not enough storage to allocate them, a minimum system buffer pool for each page size is allocated, and performance is sharply reduced.
但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
You might also have a query that runs against a very large table that USES the same buffer pool and involves reading more pages than the total buffer size.
假设有一个针对非常大的表运行的查询,它使用同一个缓冲池并且需要读取比总的缓存区大小还多的页。
On the other hand, if your minimum pool size is too large, you may have allocated unnecessary connections.
相反,如果最小池大小太大,又会分配不需要的连接。
应用推荐