Oracle教程 2023-02-25

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

本站中文解释

Oracle视图 V$LOGMNR_DICTIONARY_LOAD 是由LogMiner收集出来的系统视图，可以查询出所有已经加载到LogMiner字典中的数据库表信息。该视图可以提供关于已经载入LogMiner字典的视图所包含的表的详细信息。例如，可以确定回滚块的表名，字段，数据类型，列名，注释，视图名称，索引，语句列等。

使用此视图时，我们需要确保被LogMiner备份的表有足够的系统权限，以便它可以被备份，并为LogMiner加载字典执行必要的操作。我们还需要确保字典被编译到一个可访问的位置。我们可以使用LogMiner API接口来使用V$LOGMNR_DICTIONARY_LOAD视图来获取以上表和其他受影响的表的信息。借助这个视图，可以更轻松地构建之前的表并使用LogMiner实现复原操作。此外，可以使用LogMiner的表检查功能来检查表的有效性，然后使用V$LOGMNR_DICTIONARY_LOAD视图来显示表的完整信息。

官方英文解释

V$LOGMNR_DICTIONARY_LOAD displays information about LogMiner dictionaries for all active LogMiner sessions on the system.

Each query of this view will return one row for each attached LogMiner session. This view will not show valid information for LogMiner adhoc query clients.

Column	Datatype	Description
`SESSION_ID`	`NUMBER`	LogMiner session ID
`LOGMNR_UID`	`NUMBER`	LogMiner dictionary UID
`ACTION#`	`NUMBER`	Reserved for internal use
`OPCODE`	`NUMBER`	Reserved for internal use
`COMMAND`	`VARCHAR2(161)`	Current command being executed
`CURRENT_STATE`	`VARCHAR2(32)`	Summary information if `LOADED`=`ACTIVE`
`COMPLETED_ACTIONS`	`NUMBER`	The steps completed so far
`TOTAL_ACTIONS`	`NUMBER`	Total steps to complete
`LOADED`	`VARCHAR2(7)`	Status of the dictionary load: `YES` – dictionary has been loaded `NO` – dictionary has not been loaded `ACTIVE` – dictionary is in the process of being loaded
`PERCENT_DONE`	`NUMBER`	Percentage of the dictionary that has been loaded
`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