V$MVREFRESH

V$MVREFRESH displays information about the materialized views currently being refreshed.

Column	Datatype	Description
`SID`	`NUMBER`	Session identifier
`SERIAL#`	`NUMBER`	Session serial number, which is used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends with, and another session begins with, the same session ID.
`CURRMVOWNER`	`VARCHAR2(31)`	Owner of the materialized view currently being refreshed. The materialized view resides in this user's schema.
`CURRMVNAME`	`VARCHAR2(31)`	Name of the materialized view currently being refreshed