3.214 ALL_EXTERNAL_TAB_CACHES

ALL_EXTERNAL_TAB_CACHES describes the external table caches accessible to the current user.

Related Views

• DBA_EXTERNAL_TAB_CACHES describes all external table caches in the database.

• USER_EXTERNAL_TAB_CACHES describes the external table caches 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 external table cache
CACHE_TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the external table cache
EXTERNAL_TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the external table on which the cache is based
CACHED	VARCHAR2(3)		Indicates whether the external table has been cached (YES) or not (NO)
STALE	VARCHAR2(3)		Indicates whether the cached content is stale (YES) or not (NO)
DISABLED	VARCHAR2(3)		Indicates whether the cached content is disabled (YES) or not (NO)
TYPE	NUMBER	NOT NULL	External table partition type
CACHE_MAX_SIZE	NUMBER		Maximum size of the external table cache (in bytes)
CACHE_CUR_SIZE	NUMBER		Current size of the external table cache (in bytes)
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

Note:

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

See Also:

• "DBA_EXTERNAL_TAB_CACHES"

• "USER_EXTERNAL_TAB_CACHES"