ALL_AVTUNE_ENABLED_AVS
ALL_AVTUNE_ENABLED_AVS displays the auto-cache enabled analytic views accessible to the current user.
Related Views
-
DBA_AVTUNE_ENABLED_AVSdisplays all auto-cache enabled analytic views in the database. -
USER_AVTUNE_ENABLED_AVSdisplays the auto-cache enabled analytic views owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the analytic view |
AV_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the analytic view |
TOTAL_CACHE_PCT |
NUMBER |
NOT NULL |
Maximum size (number of rows) of all caches as a percentage of the fact table size |
REFRESH_INTVL |
NUMBER |
NOT NULL |
Number of minutes to wait between each cache refresh |
LAST_REFRESH_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Timestamp of the last refresh | |
NUM_QUERIES |
NUMBER |
NOT NULL |
Minimum number of queries on a level group before being considered for a cache |
AVG_QUERY_TIME |
NUMBER |
NOT NULL |
Average number of seconds each query should take on a level group before being considered for a cache |
LAST_UPDATE_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Timestamp of the last update | |
MAX_NUM_CACHES |
NUMBER(38) |
NOT NULL |
Maximum number of caches for the analytic view |
TUNING_INTVL |
NUMBER |
NOT NULL |
Number of minutes to wait between each tuning operation |
PURGE_ARCHIVE_INTVL |
INTERVAL DAY(2) TO SECOND(6) |
NOT NULL |
Number of days, hours, minutes or seconds to wait between purging queries |
SINGLE_CACHE_PCT |
NUMBER |
NOT NULL |
Maximum ratio in percentage between the size (number of rows) of the cache and the fact table |
CACHE_MODE |
VARCHAR2(11) |
NOT NULL |
Cache mode (FLOOR or QUERY_MATCH) |
ARCHIVE_INTVL |
NUMBER |
NOT NULL |
Number of minutes to wait between each archive operation |
NUM_TUNES |
NUMBER(38) |
NOT NULL |
Number of caches to create in each tuning operation |
CACHE_CREATE_CBK_NAME |
VARCHAR2(128) |
Name of the callback procedure that will be called in order to create the cache | |
CACHE_CREATE_CBK_PKG_NAME |
VARCHAR2(128) |
Name of the package that contains the create callback procedure | |
CACHE_REFRESH_CBK_NAME |
VARCHAR2(128) |
Name of the callback procedure that will be called when performing a refresh | |
CACHE_REFRESH_CBK_PKG_NAME |
VARCHAR2(128) |
Name of the package that contains the refresh callback procedure | |
FACT_ROWS |
NUMBER(38) |
Size (number of rows) of the fact table | |
LAST_SYNC_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The last time the analytic view was synced with the DDL | |
OBJ_PREFIX |
VARCHAR2(128) |
Naming prefix to be used when creating analytic view objects | |
EDITION |
VARCHAR2(128) |
Name of the edition in which the analytic view was enabled | |
REFRESH_JOB_CLASSFoot 1 |
VARCHAR2(128) |
NOT NULL |
Scheduler job class assigned to the job that refreshes the cache |
TUNING_JOB_CLASSFoot 1 |
VARCHAR2(128) |
NOT NULL |
Scheduler job class assigned to the job that tunes the cache |
ARCHIVE_JOB_CLASSFoot 1 |
VARCHAR2(128) |
NOT NULL |
Scheduler job class assigned to the job that archives queries on the analytic view |
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.2.
Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.7.
See Also: