| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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 |
