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 |