Oracle教程 2023-02-24

Oracle 视图 V$MAP_ELEMENT 官方解释，作用，如何使用详细说明

V$MAP_ELEMENT是Oracle数据库中常用的一个视图，它显示了ASM每一个磁盘组中每一个磁盘的映射关系。

V$MAP_ELEMENT有四列记录，分别是Disk_Group_Number（磁盘组编号）、Disk_Number（磁盘编号）、Path（磁盘路径）、Mode（磁盘状态）。

使用V$MAP_ELEMENT，可以查看ASM中每一个磁盘组的所有磁盘的磁盘编号、磁盘路径以及磁盘状态。此外，还可以使用该视图查看ASM磁盘组内磁盘的情况，如磁盘是否正常工作，以及那些磁盘处于OFF状态。

V$MAP_ELEMENT displays a list of all element mapping structures in the SGA of the instance.

Column	Datatype	Description
`ELEM_NAME`	`VARCHAR2(256)`	Element name
`ELEM_IDX`	`NUMBER`	Index corresponding to the element
`ELEM_CFGID`	`VARCHAR2(256)`	Configuration ID (N/A if configuration ID is not supported)
`ELEM_TYPE`	`VARCHAR2(12)`	Element type: `MIRROR` `STRIPE` `RAID5` `CONCATENATED` `PARTITION` `DISK` `NONE`
`ELEM_SIZE`	`NUMBER`	Element Size in HKB
`ELEM_NSUBELEM`	`NUMBER`	Number of Subelements
`ELEM_DESCR`	`VARCHAR2(256)`	Element Description
`STRIPE_SIZE`	`NUMBER`	Stripe Size in HKB for RAID-5 and STRIPE elements, `0` for the remaining types
`LIB_IDX`	`NUMBER`	Index of the library which claims ownership of the element
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：