JavaScript must be enabled to correctly display this content

ALL_EXTERNAL_TAB_CACHES

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

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
`AUTO`	`VARCHAR2(3)`		Indicates whether the external table cache is enabled for auto caching (`YES`) or not (`NO`)

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.9.

See Also:

“DBA_EXTERNAL_TAB_CACHES”
“USER_EXTERNAL_TAB_CACHES”