[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP

大佬教程收集整理的这篇文章主要介绍了[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

原文网址:http://www.askmaclean.com/archives/oracle%E5%86%85%E9%83%A8%E8%A7%86%E5%9B%BExkffxp.html

X$KFFXP是ASM(automatic Storage Management)自动存储管理特性的重要内部视图，该视图反应了file Extent Map映射关系，ASM会将文件split成多个多个pIEce分片，这些分片被称为Extents。 在disk上存放这些Extent的位置，就是我们常说的”Allocation Unit”。

KFF意为Kernel file，X$KFFXP即Kernel file Extent Maps， 该内部视图的一条记录代表一个Extent。

其字段含义如下：

GROUP_KFFXP diskgroup number (1 - 63) ASM disk group number. Join with v$asm_disk and v$asm_diskgroup

NUMBER_KFFXP file number for the extent ASM file number. Join with v$asm_file and v$asm_alias

COMPOUND_KFFXP (group_kffxp << 24) + file # file IDentifIEr. Join with compound_index in v$asm_file

INCARN_KFFXP file incarnation number file incarnation ID. Join with incarnation in v$asm_file

PXN_KFFXP physical extent number Extent number per file

xnuM_KFFXP extent number bit 31 set if indirect Logical extent
number per file (mirrored extents have the same value)

LXN_KFFXP logical extent number 0,1 used to IDentify primary/mirror extent,2 IDentifIEs file header allocation unit (hypothesis) used in the query such that
we go after only the primary extents,not secondary extents 

disK_KFFXP disk on which AU is located disk number where the extent is allocated.
Join with v$asm_disk relative position of the allocation unit from the beginning of the disk. 

AU_KFFXP AU number on disk of AU allocation unit size (1 MB) in v$asm_diskgroup

从11g开始加入了CHK_KFFXP SIZE_KFFXP 2个新的字段

CHK_KFFXP 未知 可能是范围为[0-256]的某种校验值

SIZE_KFFXP size_kffxp is used such that we account for variable sized extents.
sum(size_kffxp) provIDes the number of AUs that are on that disk.

在实例级别控制ASM diskgroup AU 和 stripe size的是2个隐藏参数 _asm_ausize 1048576 以及 _asm_stripesize 131072。从11g开始一个Extent可能包含多个AU。

可以通过以下脚本查询文件与Extent等ASM属性的映射关系:

set linesize 140 pagesize 1400 col "file name" format a40 set head on select name "file name",NUMBER_KFFXP "file NUMBER",xnuM_KFFXP "EXTENT NUMBER",disK_KFFXP "disK NUMBER",AU_KFFXP "AU NUMBER",SIZE_KFFXP "NUMBER of AUs" from x$kffxp,v$asm_alias where GROUP_KFFXP = GROUP_NUMBER and NUMBER_KFFXP = file_NUMBER and system_created = 'Y' and lxn_kffxp = 0 order by name;

大佬总结

以上是大佬教程为你收集整理的[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP全部内容，希望文章能够帮你解决[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。