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')
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')
|
|
|