DBMS_EXT_TABLE_CACHE Views
The DBMS_EXT_TABLE_CACHE package uses the following views.
- DBA_EXTERNAL_TAB_CACHES and USER_EXTERNAL_TAB_CACHES Views
Displays details of all the external table caches created on an Autonomous Database instance.
Parent topic: Autonomous Database Views
DBA_EXTERNAL_TAB_CACHES and USER_EXTERNAL_TAB_CACHES Views
Displays details of all the external table caches created on an Autonomous Database instance.
Only the ADMIN user and users with the PDB_DBA role are privileged to access DBA_EXTERNAL_TAB_CACHES. You cannot grant access to other users.
USER_EXTERNAL_TAB_CACHES columns are the same as those in DBA_EXTERNAL_TAB_CACHES. (except for OWNER).
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of external table cache. |
CACHE_TABLE_NAME |
VARCHAR2(128) |
Name of external table cache. |
EXTERNAL_TABLE_NAME |
VARCHAR2(128) |
Base table on which the cache is created. |
CACHED |
VARCHAR2(3) |
Indicates whether or not the table is cached. |
STALE |
VARCHAR2(3) |
Reserved for future use. |
DISABLED |
VARCHAR2(3) |
Indicates whether or not the cache is disabled for query rewrite. |
TYPE |
NUMBER |
Cache table partition type. |
CACHE_MAX_SIZE |
NUMBER |
Maximum size of the external table cache. |
CACHE_CUR_SIZE |
NUMBER |
Current size of the external table cache. |
LAST_REFRESH_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Last refresh time of the external table cache. |
REFRESH_INTERVAL |
INTERVAL DAY(2) TO SECOND(6) |
Reserved for future use. |
AUTO |
VARCHAR2(3) |
Indicates whether or not the cache is automatically managed. |
Parent topic: DBMS_EXT_TABLE_CACHE Views