• 缓冲数据物理读数(以表空间单位定义)。

    Buffer pool data physical reads (defined in units of tablespace page size).

    youdao

  • 缓冲索引物理读数(以表空间单位定义)。

    Buffer pool index physical reads (defined in units of tablespace page size).

    youdao

  • 缓冲x da物理读数(以表空间单位定义)。

    Buffer pool xda physical reads (defined in units of tablespace page size).

    youdao

  • 下面例子定义了缓冲两个空间个表空间宽为4KB,另个表空间的宽为32KB(注意,一个表空间总是一个缓冲,且缓冲要有一个匹配) 。

    The following example defines two buffer pools and two table spaces, one each with 4KB and 32KB pages. (Note that a table space always requires a buffer pool with a matching page size.)

    youdao

  • 但是如果总的缓冲区大小并且没有足够的存储器可用分配给它们,那么将每种大小分配最少缓冲性能会急剧下降

    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.

    youdao

  • 如果一些具有不同大小空间那么每种大小必须至少一个缓冲

    If there are table Spaces with different page sizes, there must be at least one buffer pool per page size.

    youdao

  • 相反由相应的缓冲确定的,这个缓冲也就是包含该表的表空间所指定的缓冲

    Rather, the page size for tables is determined by the page size of the buffer pool to which the table space containing the table is assigned.

    youdao

  • 缓冲内存中的一块存储区域,用于临时读入更改数据库(包含索引)。

    A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.

    youdao

  • 对于每个不同大小表空间应该存在一个大小相匹配缓冲

    For every different page size tablespace, there should be a matching page size buffer pool.

    youdao

  • 如果小型拥有自己缓冲,那么它们必须拥有自己的空间因此大型查询不能覆盖它们

    If the small tables have their own buffer pool, thereby making it necessary for them to have their own table space, their pages cannot be overwritten by the large query.

    youdao

  • 如果的确上述情况,那么使用大的缓冲是最好解决办法但是索引增加更多自由空间有所帮助

    If this is the case, a larger buffer pool is the best solution, but adding more free space to index pages may also help.

    youdao

  • 这个恢复进程立即开始集中式缓冲预取自己的本地缓冲

    This recovery process instantly begins to prefetch dirty pages from the centralized buffer pool into its own local buffer pool.

    youdao

  • 在具有缓冲环境下可能需要配置较多的清除程序

    Environments with large buffer pools may also require more page cleaners to be configured.

    youdao

  • 这个计算考虑缓冲高速缓存所有(索引数据)。

    This calculation takes into account all of the pages (index and data) that are cached by the buffer pool.

    youdao

  • 假设一个针对非常运行查询,它使用同一个缓冲并且需要读取总的缓存大小还多

    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.

    youdao

  • 大型审核日志表格中运行查询功能时,您可能会数据库系统不得不向缓冲读入数千进行计算时而结束

    When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.

    youdao

  • 这个变量指定防护例程调用比如存储过程用户定义函数调用所使用大小4KB单位)。

    This variable specifies the size (in 4 KB pages) of the pool used for fenced routine invocations, such as stored procedure or user-defined function calls.

    youdao

  • 缓冲空间以及更少的种类,可以导致更简单物理数据库设计从而容易管理维护调优

    Fewer buffer pools and table Spaces and fewer distinct page sizes lead to a simpler physical database design which is easier to manage, maintain, and tune.

    youdao

  • 而在其他平台上缓冲大小250个大小为4k

    For other platforms, the buffer pool size is 250 pages with a 4k pagesize.

    youdao

  • 注意缓冲空间大小8K,两者是相同的。

    Note that the page sizes of 8K for the buffer pool and table space are the same.

    youdao

  • 然而,过多地分配空余空间可能会产生浪费DASD 空间,导致每次I/O 只能传输少的数据缓冲利用效率,并且扫描更多

    However, over-allocating free space may result in wasted DASD space, less data transferred per I/O, less efficient use of buffer pools and more pages to scan.

    youdao

  • 缓冲数据远远大于异步数据写。

    Buffer pool data writes is much greater than Asynchronous pool data page writes.

    youdao

  • 缓冲索引远远大于异步索引写。

    Buffer pool index writes is much greater than Asynchronous pool index page writes.

    youdao

  • 数据库启动分配4分别为4k8 K、16k32 K小型缓冲

    Four small buffer pools of page size 4k, 8k, 16k and 32k are allocated when a database is started.

    youdao

  • 缓冲索引等于异步索引写。

    Buffer pool index writes is approximately equal to Asynchronous pool index page writes.

    youdao

  • 缓冲数据等于异步数据写。

    Buffer pool data writes is approximately equal to Asynchronous pool data page writes.

    youdao

  • 可以使用新增BUFFER POOL配置参数创建dbspace大小对应缓冲

    You can also use the new BUFFERPOOL configuration parameter to create a buffer pool that corresponds to the page size of the dbspace.

    youdao

  • perl buffhitratio . pl dbrun. snap——脚本提供了每个缓冲数据索引命中率。

    Dbrun.snap - This script provides the hit ratio for the data and index pages of every buffer pool.

    youdao

  • UNIX平台上创建DB 2数据库时,一个默认缓冲IBMDEFAULTBP会被创建,它具有1000个大小为4k

    When you create a DB2 database on UNIX platforms, a default buffer pool called IBMDEFAULTBP is created that is 1000 pages with a 4k pagesize.

    youdao

  • db 2PageCleaner (db2pclnr):相当于Oracle中的DBWR进程进程磁盘上转移BP之前清理缓冲

    Db2 page Cleaner (db2pclnr) : Equivalent to DBWR process in Oracle, this process cleans the buffer pool before pages from the disk are moved into the BP.

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定