3.213 ALL_EXTERNAL_TAB_CACHE_LOCATIONS

ALL_EXTERNAL_TAB_CACHE_LOCATIONS describes the files in cloud storage that are accessible to the current user and belong to cached external tables.

Related Views

• DBA_EXTERNAL_TAB_CACHE_LOCATIONS describes all files in cloud storage that belong to cached external tables.

• USER_EXTERNAL_TAB_CACHE_LOCATIONS describes the files in cloud storage that are owned by the current user and belong to cached external tables. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)	NOT NULL	Owner of the file
CACHE_NAME	VARCHAR2(128)	NOT NULL	Name of the external table cache to which the file belongs
TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the external table on which the cache is based
PATH	VARCHAR2(3000)	NOT NULL	Cloud storage path of the file
FILE_NAME	VARCHAR2(3000)	NOT NULL	Name of the file
CACHED	VARCHAR2(3)		Indicates whether the file has been cached (YES) or not (NO)
STALE	VARCHAR2(3)		Indicates whether the cached content is stale (YES) or not (NO)
CACHE_SIZE	NUMBER		Amount of tablespace consumed by the file (in bytes)
FILE_SIZE	NUMBER		Size of the file (in bytes)
USAGE_COUNT	NUMBER		Number of times the file is used in queries
ETAG	VARCHAR2(4000)		ETAG of the file
FILE_LAST_MODIFIED	TIMESTAMP(6) WITH TIME ZONE		Time at which the file was last modified
LAST_REFRESHED	TIMESTAMP(6) WITH TIME ZONE		Last refresh time of the external table cache
LAST_ACCESSED	TIMESTAMP(6) WITH TIME ZONE		Last access time of the file or external table cache

Note:

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

See Also:

• "DBA_EXTERNAL_TAB_CACHE_LOCATIONS"

• "USER_EXTERNAL_TAB_CACHE_LOCATIONS"