Secure File LOBs
Write access to SecureFiles is faster than a standard Linux file system, while read access is about the same. In addition, it features data compression, encryption and data deduplication.
SecureFiles provides the following benefits:
- LOB compression
- LOB encryption
- Deduplication (detect duplicate LOB data and only store one copy)
- Faster access to LOB data
A SecureFile can only be created in an automatic segment space management (ASSM) tablespace.
Creating SecureFile LOBS
By default lobs are created as BASICFILE LOBs. To create a SECUREFILE LOB, specify the STORE AS SECUREFILE clause. Here is an example:
CREATE TABLE lob_tab1 (c1 NUMBER, l CLOB) lob (l) STORE AS SECUREFILE secfile_segment_name (TABLESPACE lobtbs1 RETENTION AUTO CACHE LOGGING STORAGE (MAXEXTENTS 5));