Detailed References

Topic Official documentation
Lakehouse performance features and feature selection Use Lakehouse with Autonomous AI Database
External data and supported file access Query External Data
Implicit partitioning and strict_column_order Query External Tables with Implicit Partitioning
External table concepts, partitioning, and management Managing External Tables
External-table optimizer statistics Gathering Optimizer Statistics
Executed plans and runtime statistics DBMS_XPLAN
Policy-based Lake Cache APIs DBMS_EXT_TABLE_CACHE
Automatic Lake Cache APIs DBMS_CACHE
Lake Cache inventory views ALL_EXTERNAL_TAB_CACHES and the related DBA and USER views
Lake Cache location views ALL_EXTERNAL_TAB_CACHE_LOCATIONS and the related DBA and USER views
Large external scan acceleration Data Lake Accelerator
Oracle Iceberg external tables and restrictions Query Apache Iceberg Tables
Mounted catalogs and metadata caching DBMS_CATALOG
Native Iceberg DDL and restrictions CREATE ICEBERG TABLE
Iceberg metadata, manifests, snapshots, and pruning Apache Iceberg Specification
Iceberg partition and schema evolution Apache Iceberg Evolution