DBA Data[Home] [Help]

VIEW: SYS.USER_SR_OBJ_STATUS_ALL

Source

View Text - Preformatted

select NAME, TYPE, GROUP_ID, STATUS,CURRENT_RUN,
CURRENT_GROUP, ERROR_NUMBER, ERROR_MESSAGE, LAST_MODIFIED_TIME
from dba_sr_obj_status_all
where owner = SYS_CONTEXT ('USERENV', 'SESSION_USER')
View Text - HTML Formatted

SELECT NAME
, TYPE
, GROUP_ID
, STATUS
, CURRENT_RUN
, CURRENT_GROUP
, ERROR_NUMBER
, ERROR_MESSAGE
, LAST_MODIFIED_TIME FROM DBA_SR_OBJ_STATUS_ALL WHERE OWNER = SYS_CONTEXT ('USERENV'
, 'SESSION_USER')