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.