DBA Data[Home] [Help]

VIEW: SYS.USER_SR_GRP_STATUS

Source

View Text - Preformatted

select GROUP_ID, OPERATION, STATUS,
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 dba_sr_grp_status
where owner = SYS_CONTEXT ('USERENV', 'SESSION_USER')
View Text - HTML Formatted

SELECT GROUP_ID
, OPERATION
, STATUS
, 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 DBA_SR_GRP_STATUS WHERE OWNER = SYS_CONTEXT ('USERENV'
, 'SESSION_USER')