2.1.4 Columnar Cache on Exadata RDMA Memory (XRMEM)

First introduced in Oracle Exadata System Software release 12.2.1.1.0, the storage server columnar cache is a portion of Exadata Smart Flash Cache containing data in columnar format, typically used to accelerate complex analytical queries. Based on query and data profiles, Exadata software automatically identifies and converts selected data in Exadata Smart Flash Cache to columnar format and writes it in the columnar cache, transparently aiding query performance.

Oracle Exadata System Software release 24.1.0 extends the storage server columnar cache to leverage Exadata RDMA Memory (XRMEM) on Exadata storage server models starting with Exadata X10M. With this capability, the most active columnar data regions in the flash cache are automatically replicated into the XRMEM cache, providing substantially quicker columnar read performance and improved query performance.