VIEW: SYS.DBA_SR_OBJ

Source

View Text - Preformatted

select OWNER, NAME, TYPE, GROUP_ID,
STAGING_LOG_NAME from dba_sr_obj_all
where current_group = 'Y'

View Text - HTML Formatted

SELECT OWNER
, NAME
, TYPE
, GROUP_ID
, STAGING_LOG_NAME
FROM DBA_SR_OBJ_ALL WHERE CURRENT_GROUP = 'Y'