Lake Cache for Mounted Catalog Tables

Lake Cache in Oracle Autonomous AI Database supports mounted catalog tables.

You can cache catalog-backed tables accessed through Catalog SQL syntax, such as schema.table@catalog_name, by passing the catalog-qualified reference to DBMS_EXT_TABLE_CACHE.CREATE_CACHE. This enables you to speed up repeated queries on mounted catalog data without changing your application SQL.

This enhancement extends Lake Cache beyond external tables to mounted catalogs, bringing faster local reads, improved query performance, and potential reductions in cross-cloud or cross-region data access costs.

See Cache Mounted Catalog Tables with Lake Cache for more information.