ALL_AVTUNE_ENABLED_DIMENSIONS
ALL_AVTUNE_ENABLED_DIMENSIONS displays the enabled attribute dimensions accessible to the current user.
Related Views
-
DBA_AVTUNE_ENABLED_DIMENSIONSdisplays all enabled attribute dimensions in the database. -
USER_AVTUNE_ENABLED_DIMENSIONSdisplays the enabled attribute dimensions owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the attribute dimension |
DIMENSION_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the attribute dimension |
TABLE_NAME |
VARCHAR2(128) |
Name of the aggregation table | |
REFRESH_INTVL |
NUMBER |
Number of minutes to wait between each cache refresh | |
LAST_REFRESH_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Timestamp of the last refresh | |
LAST_UPDATE_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Timestamp of the last update | |
OBJ_PREFIX |
VARCHAR2(128) |
Naming prefix to be used when creating analytic view objects | |
EDITION |
VARCHAR2(128) |
Name of the edition in which the attribute dimension was enabled | |
CACHE_CREATE_CBK_NAMEFoot 1 |
VARCHAR2(128) |
Name of the callback procedure that will be called in order to create the cache | |
CACHE_CREATE_CBK_PKG_NAMEFoot 1 |
VARCHAR2(128) |
Name of the package that contains the create callback procedure | |
CACHE_REFRESH_CBK_NAMEFoot 1 |
VARCHAR2(128) |
Name of the callback procedure that will be called when performing a cache refresh | |
CACHE_REFRESH_CBK_PKG_NAMEFoot 1 |
VARCHAR2(128) |
Name of the package that contains the refresh callback procedure | |
REFRESH_JOB_CLASSFoot 2 |
VARCHAR2(128) |
NOT NULL |
Scheduler job class assigned to the job that refreshes the cache |
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.8.
Footnote 2 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: