DBA_AUTO_MV_VERIFICATION_STATUS
DBA_AUTO_MV_VERIFICATION_STATUS displays the status of verifications associated with automatic materialized views.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TASK_NAME |
VARCHAR2(128) |
Name of the task | |
EXECUTION_NAME |
VARCHAR2(128) |
NOT NULL |
The name of the task execution with which this entry (row) is associated |
STS_NAME_FOR_SRS |
VARCHAR2(256) |
Name of the SQL tuning set used for simple random sampling | |
STS_OWNER_NAME_FOR_SRS |
CHAR(3) |
Owner of the SQL tuning set used for simple random sampling | |
SPA_TASK_NAME_FOR_SRS |
VARCHAR2(256) |
Name of the SQL Performance Analyzer task used for simple random sampling | |
SPA_OWNER_NAME_FOR_SRS |
CHAR(3) |
Owner of the SQL Performance Analyzer task used for simple random sampling | |
STS_NAME_FOR_VERIFICATION |
VARCHAR2(256) |
Name of the SQL tuning set used for verification on sampled queries | |
STS_OWNER_NAME_FOR_VERIFICATION |
CHAR(3) |
Owner of the SQL tuning set used for verification on sampled queries | |
SPA_TASK_NAME_FOR_VERIFICATION |
VARCHAR2(256) |
Name of the SQL Performance Analyzer task used for for verification on sampled queries | |
SPA_OWNER_NAME_FOR_VERIFICATION |
CHAR(3) |
Owner of the SQL Performance Analyzer task used for for verification on sampled queries | |
START_TIME |
TIMESTAMP(6) |
Date and time the verification started | |
END_TIME |
TIMESTAMP(6) |
Date and time the verification ended | |
STATUS |
VARCHAR2(128) |
Verification status |