Oracle 视图 DBA_SR_GRP_STATUS_ALL 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图DBA_SR_GRP_STATUS_ALL是一个数据字典视图,它提供了在实例上定义的资源组的活动状态,该资源组是在启用资源管理时定义的。它包含有关当前活动和GUIDES_TAKEN参数设置的信息。

使用此视图可以在RDBMS中查看哪些资源组处于活动状态,以及这些资源组相应的属性和参数。此外,它还可以检查这些资源组是否已完全配置和正确部署。使用此视图有助于更好地理解资源管理的影响,并辅助实施资源管理。

要使用此视图,需要先启用资源管理,可以使用以下查询:

SELECT * FROM DBA_SR_GRP_STATUS_ALL;

官方英文解释

DBA_SR_GRP_STATUS_ALL provides information on the refresh operations on the synchronous refresh groups in the database.

A refresh operation is also called a run, and it has two phases: PREPARE_REFRESH and EXECUTE_REFRESH. These phases are controlled using the DBMS_SYNC_REFRESH package.

Each row in this view provides information on a run of a group, identified by its GROUP_ID. The view contains information on the status of the objects of both current and past runs of both current and defunct synchronous refresh groups. Therefore, this view can be used to examine the history of synchronous refresh operations.

The current run of a group is the most recent run of a group; a current group is a currently valid group, which is capable of being refreshed. A group becomes defunct when it is unregistered for any reason, either explicitly by the user or implicitly as a side-effect when the user registers materialized views related to the materialized views in the group.

To view the status of refresh operations for the most recent runs of only the current groups, use the DBA_SR_GRP_STATUS view.

Related View

USER_SR_GRP_STATUS_ALL provides information on the refresh operations on the synchronous refresh groups in the database which are owned by the current user. Its columns are the same as those in DBA_SR_GRP_STATUS_ALL.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the refresh operation, which is the user who launched the operation

GROUP_ID

NUMBER

NOT NULL

Group ID of the synchronous refresh group

OPERATION

VARCHAR2(7)

The phase of the refresh operation performed:

  • PREPARE

  • EXECUTE

STATUS

VARCHAR2(10)

The status of the refresh operation:

  • RUNNING

  • NOT PROCESSED

  • COMPLETE

  • ERROR-SOFT

  • ERROR-HARD

  • ABORT

  • PARTIAL

CURRENT_RUN

VARCHAR2(1)

Indicates whether the record is for the most recent refresh-operation on the group:

  • Y – Yes

  • N – No

CURRENT_GROUP

VARCHAR2(1)

Indicates whether the record is for a current group:

  • Y – Yes

  • N – No

NUM_TBLS

NUMBER

NOT NULL

The number of tables in the synchronous refresh group

NUM_MVS

NUMBER

NOT NULL

The number of materialized views in the synchronous refresh group

BASE_TBLS_REFR_STATUS

VARCHAR2(13)

Indicates the refresh status of base tables in the synchronous refresh group. The possible values are:

  • NOT PROCESSED

  • COMPLETE

  • ABORT

NUM_MVS_COMPLETED

NUMBER

The number of materialized views which have completed refresh in the synchronous refresh group

NUM_MVS_ABORTED

NUMBER

The number of materialized views which have aborted refresh in the synchronous refresh group

ERROR_NUMBER

NUMBER

Error number of the run (if any)

ERROR_MESSAGE

VARCHAR2(4000)

Error message of the run (if any)

PREPARE_START_TIME

DATE

Time that the PREPARE_REFRESH phase of the run started

PREPARE_END_TIME

DATE

Time that the PREPARE_REFRESH phase of the run ended

EXECUTE_START_TIME

DATE

Time that the EXECUTE_REFRESH phase of the run started

EXECUTE_END_TIME

DATE

Time that the EXECUTE_REFRESH phase of the run ended

See Also:

  • “USER_SR_GRP_STATUS_ALL”

  • Oracle Database PL/SQL
    Packages and Types Reference
    for more information about the DBMS_SYNC_REFRESH package


数据运维技术 » Oracle 视图 DBA_SR_GRP_STATUS_ALL 官方解释,作用,如何使用详细说明