Oracle教程

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

本站中文解释

Oracle在11G中新增的一个V$视图，是用于LogMiner工具，用于查询LogMiner字典中存储的用户对象相关信息，也是用于将Oracle redo日志转换为可读的SQL语句和分析更改后数据库状态的LogMiner工具的重要辅助资源。

使用方法：
首先启动LogMiner，然后通过以下语句来查询特定用户的表和索引：
SELECT dname, tablespace_name, table_name, index_name
FROM v$logmnr_dictionary
WHERE username=’SYS’
ORDER BY TABLESPACE_NAME, table_name, index_name;
返回的结果用于最新的LogMiner分析，或者Target Audience。

官方英文解释

V$LOGMNR_DICTIONARY contains log history information.

Column Datatype Description

DB_NAME

VARCHAR2(9)

Name of the database

DB_ID

NUMBER

Database ID

DB_CREATED

DATE

Creation date of the source database (corresponds to the CREATED column in the V$DATABASE view)

TIMESTAMP

DATE

Date when the dictionary was created

RESET_SCN

NUMBER

Reset log SCN when the dictionary was created

RESET_SCN_TIME

DATE

Timestamp of the reset log SCN when the dictionary was created

DB_VERSION_TIME

DATE

Version time for the source database (corresponds to the VERSION_TIME column in the V$DATABASE view)

DB_CHARACTER_SET

VARCHAR2(30)

Character set of the source database

DB_VERSION

VARCHAR2(64)

This column is deprecated.

DB_STATUS

VARCHAR2(64)

This column is deprecated.

DICTIONARY_SCN

NUMBER

Database checkpoint SCN at which the dictionary was created

ENABLED_THREAD_MAP

RAW(16)

This column is deprecated.

DB_TXN_SCN

NUMBER

SCN at which the dictionary was created

FILENAME

VARCHAR2(512)

Dictionary file name

INFO

VARCHAR2(32)

Informational/Status message

BAD_DATE indicates that the SCN of the dictionary file does not match the SCN range of the log files

STATUS

NUMBER

A NULL indicates a valid dictionary file for the list of log files. A non-NULL value indicates further information is contained in the INFO column as a text string.

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


数据运维技术 » Oracle 视图 V$LOGMNR_DICTIONARY 官方解释，作用，如何使用详细说明
分享到：

相关推荐