Note
This view is available starting with V4.3.0.
Purpose
The USER_MVIEW_LOGS view displays information about materialized view logs.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| LOG_OWNER | VARCHAR2(128) | YES | The name of the materialized view log owner. |
| MASTER | VARCHAR2(128) | YES | The name of the master table to which the materialized view log belongs. |
| LOG_TABLE | VARCHAR2(128) | YES | The name of the materialized view log table. |
| LOG_TRIGGER | VARCHAR2(128) | YES | The row-level trigger on the master table that inserts rows into the materialized view log.
NoteThis column is compatible only, and its value is NULL by default. |
| ROWIDS | VARCHAR2(3) | NO | Indicates whether to record rowid information
|
| PRIMARY_KEY | VARCHAR2(3) | NO | Indicates whether to record primary key information
|
| OBJECT_ID | VARCHAR2(3) | NO | Indicates whether to record object identifier information in the object table
NoteThis column is compatible only, and its value is NO by default. |
| FILTER_COLUMNS | VARCHAR2(3) | NO | Indicates whether to record filter column information
|
| SEQUENCE | VARCHAR2(3) | NO | Indicates whether to record sequence values that provide additional sorting information
NoteThe value of this column is always YES. |
| INCLUDE_NEW_VALUES | VARCHAR2(3) | NO | Indicates whether to record both the old and new values
NoteThe value of this column is always YES. |
| PURGE_ASYNCHRONOUS | VARCHAR2(3) | NO | Indicates whether the materialized view log is asynchronously purged
|
| PURGE_DEFERRED | VARCHAR2(3) | NO | Indicates whether to purge the materialized view log in a deferred manner
|
| PURGE_START | DATE | YES | The start date of the deferred purge. |
| PURGE_INTERVAL | VARCHAR2(200) | YES | The interval between deferred purges. |
| LAST_PURGE_DATE | DATE | YES | The date when the materialized view log was last purged. |
| LAST_PURGE_STATUS | NUMBER | NO | The status of the last purge of the materialized view log
NoteThe value of this column is always 0. |
| NUM_ROWS_PURGED | NUMBER | YES | The number of rows purged from the materialized view log during the last purge. |
| COMMIT_SCN_BASED | VARCHAR2(3) | NO | Indicates whether the materialized view log is based on commit SCN
NoteThe value of this column is always YES. |
| STAGING_LOG | VARCHAR2(3) | NO | Indicates whether the materialized view log is a staging log for synchronous refresh
NoteThis column is compatible only, and its value is NO by default. |
| PURGE_DOP | NUMBER(38) | NO | The parallelism for purging the materialized view log.
NoteFor OceanBase Database V4.3.5, this column is available starting with V4.3.5 BP2. |
| LAST_PURGE_TIME | NUMBER(38) | YES | The time consumed by the last materialized view log purge task, in seconds.
NoteFor OceanBase Database V4.3.5, this column is available starting with V4.3.5 BP2. |
Sample query
obclient [SYS]> SELECT * FROM SYS.USER_MVIEW_LOGS WHERE ROWNUM = 1;
The query result is as follows:
*************************** 1. row ***************************
LOG_OWNER: SYS
MASTER: TEST_TBL1
LOG_TABLE: MLOG$_TEST_TBL1
LOG_TRIGGER: NULL
ROWIDS: NO
PRIMARY_KEY: YES
OBJECT_ID: NO
FILTER_COLUMNS: YES
SEQUENCE: YES
INCLUDE_NEW_VALUES: YES
PURGE_ASYNCHRONOUS: NO
PURGE_DEFERRED: NO
PURGE_START: NULL
PURGE_INTERVAL: NULL
LAST_PURGE_DATE: 23-APR-25
LAST_PURGE_STATUS: 0
NUM_ROWS_PURGED: 0
COMMIT_SCN_BASED: YES
STAGING_LOG: NO
PURGE_DOP: 1
LAST_PURGE_TIME: 0
1 row in set