Oracle教程

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

本站中文解释

V$ONLINE_REDEF字典视图显示某个用户发起的online redefinition操作。在online redefinition期间，要重定义的表会被复制为另外一张表，这时，Oracle会将这个操作信息保存在V$ONLINE_REDEF视图中。该视图中包括几个字段：

• SOURCE_OWNER：被重定义表所属的用户。
• SOURCE_TABLE：被重定义的表名。
• DEST_OWNER：目标表所属的用户。
• DEST_TABLE：目标表的名称。
• REDEF_TIMESTAMP：online redefinition的执行时间。
• REDEF_OUTCOME：online redefinition的执行结果。
• REDEF_STATUS：online redefinition的状态。

使用V$ONLINE_REDEF视图来查询当前正在进行的online redefinition操作，或者查询在某个时间段内的活动的online redefinition任务：

SELECT * FROM V$ONLINE_REDEF WHERE REDEF_TIMESTAMP > SYSDATE-1;

官方英文解释

V$ONLINE_REDEF provides information about the status of currently running online redefinitions.

Column Datatype Description

SID

NUMBER

Session identifier

SERIAL#

NUMBER

Session serial number, which is used to uniquely identify a session’s objects

REDEFINITION_ID

NUMBER

Redefinition identifier

TABLE_OWNER

VARCHAR2(129)

Owner of the table currently being redefined. The table resides in this user’s schema.

ORIGINAL_TABLE_NAME

VARCHAR2(129)

Name of the original table

INTERIM_TABLE_NAME

VARCHAR2(1024)

Interim table currently being redefined

PARTITION_NAME

VARCHAR2(1024)

Partition of the table currently being redefined. The table resides in this user’s schema.

OPERATION

VARCHAR2(128)

Operations during the redefining process:

  • start_redef_table

  • sync_interim_table

  • copy_table_dependents

  • finish_redef_table

  • abort_redef_table

SUBOPERATION

VARCHAR2(128)

Sub operation during the redefining process

DETAILED_MESSAGE

VARCHAR2(1024)

Details of operations during redefining process. This can include details such as the number of DML being processed, execution start_time, and partition_name

PROGRESS

VARCHAR2(128)

Percentage of completion of each operation

REFRESH_STATEMENT_SQL_ID

VARCHAR2(128)

The SQL ID for the statement in the REFRESH_STATEMENT column

REFRESH_STATEMENT

VARCHAR2(4000)

A refresh statement executed during a refresh operation in some online redefinition procedures. When refresh is a sub operation in the SUBOPERATION column, there will be a refresh statement in this REFRESH_STATEMENT column.

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$ONLINE_REDEF 官方解释，作用，如何使用详细说明
分享到：

相关推荐