3.124 ALL_AVTUNE_ENABLED_AV_DIMENSIONS

ALL_AVTUNE_ENABLED_AV_DIMENSIONS displays the enabled attribute dimensions for the auto-cache enabled analytic views accessible to the current user.

Related Views

  • DBA_AVTUNE_ENABLED_AV_DIMENSIONS displays the enabled attribute dimensions for all auto-cache enabled analytic views in the database.

  • USER_AVTUNE_ENABLED_AV_DIMENSIONS displays the enabled attribute dimensions 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)

Owner of the analytic view

DIMENSION_OWNER

VARCHAR2(128)

NOT NULL

Owner of the attribute dimension

DIMENSION_NAME

VARCHAR2(128)

NOT NULL

Name of the attribute dimension

AV_NAME

VARCHAR2(128)

Name of the analytic view

TABLE_NAME

VARCHAR2(128)

Name of the aggregation table

LAST_REFRESH_TIME

TIMESTAMP(6) WITH TIME ZONE

Timestamp of the last refresh

Note:

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

See Also: