Oracle教程 2023-02-24

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

Oracle 视图 V$MAP_COMP_LIST 用于查看与具体实例关联的组件信息。

它非常有用，因为当可能存在多个实例时，您可以查询每个实例占用的资源。

使用该视图可以查看具体实例关联的组件，其中包括应用程序和数据库（如服务，模块和表空间）等。该视图还显示与实例关联的每个组件的备用和校验站点。

语法为：

SELECT * FROM V$MAP_COMP_LIST;

V$MAP_COMP_LIST displays supplementary information for all element mapping structures.

Column	Datatype	Description
`ELEM_IDX`	`NUMBER`	Index corresponding to the element
`NUM_COMP`	`NUMBER`	Number of components (maximum is 5)
`COMP1_NAME`	`VARCHAR2(256)`	Name of the first component
`COMP1_VAL`	`VARCHAR2(256)`	Value of the first component
`COMP2_NAME`	`VARCHAR2(256)`	Name of the second component
`COMP2_VAL`	`VARCHAR2(256)`	Value of the second component
`COMP3_NAME`	`VARCHAR2(256)`	Name of the third component
`COMP3_VAL`	`VARCHAR2(256)`	Value of the third component
`COMP4_NAME`	`VARCHAR2(256)`	Name of the fourth component
`COMP4_VAL`	`VARCHAR2(256)`	Value of the fourth component
`COMP5_NAME`	`VARCHAR2(256)`	Name of the fifth component
`COMP5_VAL`	`VARCHAR2(256)`	Value of the fifth component
`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

分享到：