[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP
来源:互联网 发布:linux脚本启动程序 编辑:程序博客网 时间:2024/05/18 01:00
原文网址: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_diskgroupNUMBER_KFFXP file number for the extent ASM file number. Join with v$asm_file and v$asm_aliasCOMPOUND_KFFXP (group_kffxp << 24) + file # File identifier. Join with compound_index in v$asm_fileINCARN_KFFXP file incarnation number File incarnation id. Join with incarnation in v$asm_filePXN_KFFXP physical extent number Extent number per fileXNUM_KFFXP extent number bit 31 set if indirect Logical extentnumber 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 thatwe 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 1400col "FILE NAME" format a40set head onselect 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;
0 0
- [转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP
- Oracle内部视图:X$BH
- Oracle内部视图:X$BH
- 【转】oracle自带视图和表
- oracle ace
- oracle数据字典详解,内部RDBMS(X$)表、数据字典表、动态性能(v$)视图、数据字典视图
- oracle数据字典详解:内部RDBMS(X$)表、数据字典表、动态性能(v$)视图、数据字典视图
- oracle数据字典详解:内部RDBMS(X$)表、数据字典表、动态性能(v$)视图、数据字典视图
- 【转自Oracle ACE --杨廷琨】sqlplus注释导致语句重复执行
- ORACLE内部培训资料(转)
- 【转】Oracle 数据字典视图(V$,GV$,X$)
- Oracle自带的表和视图
- 【转自Oracle ACE-盖国强】Oracle 11g全表扫描以Direct Path Read方式执行
- Oracle 数据字典视图(V$,GV$,X$)
- Oracle 数据字典视图(V$,GV$,X$)
- Oracle 数据字典视图(V$,GV$,X$) #
- Oracle 数据字典视图(V$,GV$,X$)
- Oracle 数据字典视图(V$,GV$,X$)
- LeetCode之反转数组
- HDU - 2855 Fibonacci Check-up 斐波那契矩阵
- SQLite数据库表字段修改与删除
- 【hihocoder】hiho密码(水题)
- Python学习笔记-初级(二):模块与函数
- [转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP
- Comsol Multiphysics 声场仿真模块…
- 事件驱动框架(二)——状态机
- WIN8.1下MSVC2013调用MATLAB engin…
- WIN8.1下Qt调用MATLAB engine
- Win10+Qt5.6+MSVC2015环境配置
- Win10+Qt5.6+MSVC2015+OSG3.4.0环…
- window下装ubuntu虚拟机
- 【DP】 摆花