As part of the 12c release of the database and cellos Oracle introduced the ability to perform Smart Scans on inline LOBs. The enhancement is certainly for Secure Files only. And as always, if you would like to read up about Secure Files you can head over to Tim Hall’s website for the details.
To demonstrate the new behaviour I have used an 126.96.36.199 BP 22 database on Exadata 188.8.131.52.1 and 184.108.40.206.2 database on Exadata 220.127.116.11.0. The test case evolves around the following table:
CREATE TABLE loboffload (
id number primary key,
enable row movement
lob (comments) store as securefile (
enable storage in row
This is the short version, Oracle fills in the blanks and converts the table DDL to