Fixed X$ Tables in ASM
From Vinod Haval's <Inside Overview of ASM Metadata>
These Views helps in understanding the following metrics
- Physical Mapping
- Provides Undocumented Information
- 18 X$ Tables (May be more)
| TABLE NAME | DESCRIPTION |
| X$KFALS | This table gives the details about aliases created in ASM |
| X$KFCBH | This is similar to x$kfbh and have same number of rows as x$kfbh |
| X$KFCCE | This table helps to locate the particular block |
| X$KFBH | This table gives more physical block level info |
| X$KFDSK_STAT | This table provides the usage metrics data which can be used for performance analysis |
| X$KFGRP | This table provides the disk groups info in ASM |
| X$KFGRP_STAT | This table gives the usage metrics data for all the disk groups within the ASM |
| X$KFGMG | This table provides the details about ASM operations |
| TABLE NAME | DESCRIPTION |
| X$KFKID | This table provides the info about ASM disks |
| X$KFNCL | This is similar to x$kfbh and have same number of rows as x$kfbh |
| X$KFTMTA | This table provides the info about DB instance connected to ASM instance |
| X$KFFIL | This table gives more physical block level info |
| X$KFFXP | This table provides the physical extent allocation mapping info within ASM files |
| X$KFDAT | |
| X$KFDPARTNER | |
| X$KFCLLE |
posted on 2013-03-19 00:32 Oracle和MySQL 阅读(188) 评论(0) 收藏 举报

2群基础群 适合刚入门的同学,会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群,空位多多,无需面试
浙公网安备 33010602011771号