ALL_AVTUNE_ENABLED

3.125 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_AVS displays all auto-cache enabled analytic views in the database.
USER_AVTUNE_ENABLED_AVS displays the auto-cache enabled analytic views owned by the current user. This view does not display the OWNER column.

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)`	`NOT NULL`	Name of the edition in which the analytic view was enabled

Note:

This view is available starting with Oracle Database 23ai, Release Update 23.7.