2.1.2 Immediate Reuse of Flash Cache for Temporary Data
Oracle Database uses temporary (TEMP) segments to store intermediate results during various operations such as table joins and data sorting. On Exadata, TEMP data is primarily written to Exadata Smart Flash Cache to maximize performance.
Historically, like other data, TEMP data is written to disk when 'hotter' data requires the flash cache space. However, in many cases, the data written to disk is never reused because the database has completed the associated operation.
Oracle Exadata System Software release 25.2.0 introduces optimizations that enable a storage server to discard TEMP data from the flash cache immediately after Oracle Database completes the operation using it. This capability, which is unique to Exadata, optimizes flash cache space utilization and improves overall system performance by avoiding unnecessary disk I/Os and immediately freeing up valuable flash cache resources for reuse by other clients.
This capability also requires Oracle Database with patch 38068007.