Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_SR_GRP_STATUS

DBA_SR_GRP_STATUS provides information on the current refresh operations for the current synchronous refresh groups in the database. It has the same columns as the DBA_SR_GRP_STATUS_ALL view.

Refresh operations are controlled using the DBMS_SYNC_REFRESH package.

Related View

USER_SR_GRP_STATUS provides information on the current refresh operations for the current 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.

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

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: