[Home] [Help] [Dependency Information]
Object Name: | DBA_SR_GRP_STATUS_ALL |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All synchronous refresh groups in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the synchronous refresh group |
GROUP_ID | NUMBER | Yes | Group ID of the synchronous refresh group | |
OPERATION | VARCHAR2 | (7) | Current operation of the synchronous refresh group: PREPARE, EXECUTE | |
STATUS | VARCHAR2 | (10) | Status of the synchronous refresh group: RUNNING, NOT PROCESSED, COMPLETE, ERROR-SOFT, ERROR-HARD,-ABORT | |
CURRENT_RUN | VARCHAR2 | (1) | Indicates whether the synchronous refresh group is in the current run: Y - YES, N - NO | |
CURRENT_GROUP | VARCHAR2 | (1) | ||
NUM_TBLS | NUMBER | Yes | The number of tables in the synchronous refresh group | |
NUM_MVS | NUMBER | Yes | The number of materialized views in the synchronous refresh group | |
BASE_TBLS_REFR_STATUS | VARCHAR2 | (13) | Indicate the refresh status of base tables in the synchronous refresh group | |
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 view which have aborted refresh in the synchronous refresh group | ||
ERROR_NUMBER | NUMBER | Error number if any of the synchronous refresh group | ||
ERROR_MESSAGE | VARCHAR2 | (4000) | Error message if any of the synchronous refresh group | |
PREPARE_START_TIME | DATE | Start-time of prepare_refresh of the synchronous refresh group | ||
PREPARE_END_TIME | DATE | End-time of prepare_refresh of the synchronous refresh group | ||
EXECUTE_START_TIME | DATE | Start-time of execute_refresh of the synchronous refresh group | ||
EXECUTE_END_TIME | DATE | End-time of execute_refresh of the synchronous refresh group |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, GROUP_ID
, OPERATION
, STATUS
, CURRENT_RUN
, CURRENT_GROUP
, NUM_TBLS
, NUM_MVS
, BASE_TBLS_REFR_STATUS
, NUM_MVS_COMPLETED
, NUM_MVS_ABORTED
, ERROR_NUMBER
, ERROR_MESSAGE
, PREPARE_START_TIME
, PREPARE_END_TIME
, EXECUTE_START_TIME
, EXECUTE_END_TIME
FROM SYS.DBA_SR_GRP_STATUS_ALL;
|
|
|