1. System Overview
  2. What's New in Oracle Exadata Database Machine
  3. New Features for Oracle Exadata System Software Release 12.x
  4. What's New in Oracle Exadata Database Machine 12.2.1.1.0
  5. New Features in Oracle Database 12c Release 2 (12.2.0.1)
  6. Exadata Smart Scan Offload Enhancements for LOBs

9.1.20.5 Exadata Smart Scan Offload Enhancements for LOBs

In Oracle Exadata Storage Server 12.2.1.1.0, offload support has been extended for the following LOB operators: LENGTH, SUBSTR, INSTRM CONCAT, LPAD, RPAD, LTRIM, RTRIM, LOWER, UPPER, NLS_LOWER, NLS_UPPER, NVL, REPLACE, REGEXP_INSTR, TO_CHAR.

Exadata smart scan offload evaluation is supported only on uncompressed inlined LOBs (less than 4 KB in size).

Minimum software required: Oracle Database 12c release 2 (12.2.0.1.0) and Oracle Exadata Storage Server software release 12.2.1.1.0.

Parent topic: New Features in Oracle Database 12c Release 2 (12.2.0.1)