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