DBA_SR_OBJ

DBA_SR_OBJ provides information on the objects registered for synchronous refresh for current groups.

Related View

USER_SR_OBJ provides information on the objects registered for synchronous refresh for current groups for the current user. Its columns are the same as those in DBA_SR_OBJ.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the synchronous refresh object
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the synchronous refresh object
`TYPE`	`VARCHAR2(5)`		Type of synchronous refresh object: `MVIEW` `TABLE`
`GROUP_ID`	`NUMBER`	`NOT NULL`	Group ID of the synchronous refresh group to which this object belongs
`STAGING_LOG_NAME`	`VARCHAR2(128)`		Name of the staging log for tables. This column has a value of NULL for materialized views.