JavaScript must be enabled to correctly display this content

ALL_AVTUNE_AV_AGG_CACHES

ALL_AVTUNE_AV_AGG_CACHES displays aggregation caches for the auto-cache enabled analytic views accessible to the current user.

DBA_AVTUNE_AV_AGG_CACHES displays aggregation caches for all auto-cache enabled analytic views in the database.
USER_AVTUNE_AV_AGG_CACHES displays aggregation caches for 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
`TABLE_NAME`	`VARCHAR2(128)`		Name of the aggregation table
`NUM_ROWS`	`NUMBER`		Number of rows of the aggregation table created for the cache
`CREATED_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	`NOT NULL`	Time of the cache creation
`LAST_QUERY_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The last time the cache was used
`CACHE_ID`	`NUMBER(38)`	`NOT NULL`	ID of the cache

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.7.

See Also:

“DBA_AVTUNE_AV_AGG_CACHES”
“USER_AVTUNE_AV_AGG_CACHES”