第1个回答 2013-11-05
不带单位表示单位为 page
以你上面的例子，单位是32k
extentsize 和 prefetchsize都是这样
EXTENTSIZE number-of-pages
Specifies the number of PAGESIZE pages that will be written |to a container before skipping to the next container. |The extent size value can also be specified as an integer value |followed by K (for kilobytes) or M (for megabytes). |If specified in this way, the floor of the number of bytes divided |by the page size is used to determine the value for the extent size. |The database manager cycles repeatedly through the containers as |data is stored.
The default value is provided by the DFT_EXTENT_SZ |database configuration parameter, which has a valid range of 2-256 |pages.
PREFETCHSIZE number-of-pages
Specifies the number of PAGESIZE pages that will be read from the table space when data prefetching is being performed. The prefetch size value can also be specified as an integer value followed by K (for kilobytes), M (for megabytes), or G (for gigabytes). If specified in this way, the floor of the number of bytes divided by the pagesize is used to determine the number of pages value for prefetch size. Prefetching reads in data needed by a query prior to it being referenced by the query, so that the query need not wait for I/O to be performed.本回答被提问者采纳