Oracle教程 2023-02-24

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

Oracle视图V$MAP_LIBRARY提供的的数据是系统在使用的映射库的信息。这个视图允许使用者查看映射库的名称，版本，平台和SID。

使用这个视图来观察在某一时刻，数据库中所采用的映射库，以及检查系统设置是否正确。

使用方法：

1. 首先根据所需的查询结果，构造完整的查询语句，例如：

SELECT NAME, VERSION, PLATFORM_ID, ORACLE_SID FROM V$MAP_LIBRARY;

2. 然后进入Oracle数据库客户端，输入上面构造的查询语句：

SQL> SELECT NAME, VERSION, PLATFORM_ID, ORACLE_SID FROM V$MAP_LIBRARY;

3. 结果将会列出在当前数据库中采用的映射库的相关信息。

V$MAP_LIBRARY displays a list of all mapping libraries dynamically loaded by the external process.

Column	Datatype	Description
`LIB_IDX`	`NUMBER`	Index corresponding to the library
`LIB_NAME`	`VARCHAR2(256)`	Absolute library name
`VENDOR_NAME`	`VARCHAR2(64)`	Name of the vendor implementing the library
`PROTOCOL_NUM`	`NUMBER`	Mapping protocol that the library supports
`VERSION_NUM`	`VARCHAR2(32)`	Version number
`PATH_NAME`	`VARCHAR2(4000)`	Path name
`MAP_FILE`	`VARCHAR2(1)`	Indicates whether the library supports mapping files (`Y`) or not (`N`)
`FILE_CFGID`	`VARCHAR2(13)`	Type of configuration ID supported for files: `NONE` – Not supported `PERSISTENT` `NONPERSISTENT`
`MAP_ELEM`	`VARCHAR2(1)`	Indicates whether the library supports mapping elements (`Y`) or not (`N`)
`ELEM_CFGID`	`VARCHAR2(13)`	Type of configuration id supported for elements: `NONE` – Not supported `PERSISTENT` `NONPERSISTENT`
`MAP_SYNC`	`VARCHAR2(1)`	Indicates whether the library needs to be explicitly synchronized so that future mappings reflect the most recent changes (`Y`) or not (`N`). Note that configuration IDs cannot be supported if the library needs to be explicitly synced.
`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

分享到：