Secure File LOBs
From Oracle FAQ
(Redirected from SecureFiles)
Secure File LOBs (known as "FastFiles" in the beta releases) is an Oracle 11g database feature that provides faster access to unstructured data stored in LOB columns.
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));