Another solution is to create smaller inode extents.
另一种解决方案是创建较小的inode区段。
Extents can be checked and verified for each dbspace.
可以检查每个dbspace的区段。
This indicates that the sales table contains three extents.
这指出了销售表包含三个区段。
The Extents tab lists all the extents associated with the given dbspace.
Extents选项卡列出与给定的dbspace相关联的所有区段。
The parameter zsecondary is used to allocate fixed secondary extents.
zsecondary参数用于分配固定的辅助extent。
However, the REPACK option does not necessarily reduce the number of extents.
然而,REPACK选项不一定减少盘区数量。
Use oncheck -pt to check on the number of partition extents after defragmentation.
可在碎片整理完成后,利用oncheck - pt来检查分区区段的数量。
In this case, you'll call the volume group oraclevg and allocate 256 4-MG extents.
在这里,把卷组命名为oraclevg并分配 256个 4 mg 的区段。
If tables have too many extents, it is very likely that those extents are interleaved.
如果表拥有太多区段,那些区段就很可能是交错的。
There are two problems with tables that have lots of extents, or at least there used to be.
那些有很多盘区、或者至少曾经有过的表,存在两个问题。
Behind the scenes, the LVM system allocates storage in equal-sized "chunks", called extents.
在幕后,LVM系统以大小相等的“块”(称为“范围”)为单位分配存储量。
For maximum efficiency, frequently accessed tables should have as few extents as possible.
为达到效率最大化,频繁访问的表区段应当越少越好。
Modify the entry for LogPrimaryFiles to the required value to change the number of primary extents.
将LogPrimaryFiles条目修改为所需的值,以更改主扩展的数量。
10 primary extents and 10 secondary extents for the log specified with the -lp 10 and -ls 10 flags.
使用- lp10和- ls 10标志为日志指定10个主扩展和10个次扩展。
The number of extents needed depends on the amount of data to be logged and the size of each extent.
所需的扩展数量取决于要记录的数据量和每个扩展的大小。
When using circular logging log file extents are reused once they no longer contain active log data.
使用循环日志记录时,当日志文件扩展不再包括活动数据日志时,会将其进行重新使用。
You can also specify the size of the first extent and of subsequent extents when dbspaces are created
创建dbspace时也可以指定第一个扩展区和后续扩展区的大小
Ideally there is a large enough contiguous block of storage to cover all the extents in the partition.
理想情况下,存在一个足够大的连续存储块来涵盖分区中的全部区段。
It has also been designed to use extents, but if this is used, then compatibility with ext3fs is lost.
它还可以使用分区,但是这样做将失去与ext3fs的兼容性。
When using linear logging on the other hand log file extents will be continually allocated as required.
另一方面,使用线性日志记录时,将根据需要继续分配日志文件扩展。
It is also worth noting that temporary table Spaces and free DMS extents are not part of the backup image.
值得注意的是,临时表空间和空闲dm s盘区(extent)不是备份镜像的一部分。
Secondary log file extents are allocated dynamically by the queue manager when the primary files are exhausted.
次日志文件扩展由队列管理器在主文件耗尽的情况下动态分配。
For instance: does a large number of extents for a table space really have a measurable negative performance impact?
例如:大范围的表空间是否具有可衡量的负面的性能影响?
Ext4 replaces ext3's mechanism with extents to improve allocation and support a more efficient storage structure.
ext4使用区段取代ext3的机制,从而改善了空间的分配,并且支持更加高效的存储结构。
Otherwise, its data or keys will be scattered throughout the extents that have been occupied by the table or index.
否则,其数据或键将分散在该表或索引所占用的所有区段中。
Use the TBLTBLFIRST and TBLTBLNEXT configuration parameters to specify the size of the extents in the root dbspace.
使用TBLTBLFIRST和TBLTBLNEXT配置参数指定根dbspace中扩展区的大小。
If the largest free extent cannot cover two or more partition extents, the defragmenter sets an error code and returns.
如果最大的空闲区段无法涵盖两个或更多分区区段,碎片整理程序会设置错误代码并返回。
Primary extents are allocated and formatted by the queue manager when it is first started or when extra extents are added.
主扩展在首次启动队列管理器时由队列管理器分配和格式化,而其他扩展是以后添加的。
Double click on the LogPrimaryFiles string value and modify the value as required to change the number of primary extents.
双击LogPrimaryFiles字符串值,并根据需要修改此值,以更改主扩展的数量。
Extents determine how data is striped across multiple containers and ensure that the data pages in a container are contiguous.
区段确定如何跨越多个容器进行数据分段,并确保一个容器里的数据页面是连续的。
应用推荐