Secure File LOBs

From Oracle FAQ
Jump to: navigation, search

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.

Benefits provided[edit]

SecureFiles provides the following benefits:

  • LOB compression
  • LOB encryption
  • Deduplication (detect duplicate LOB data and only store one copy)
  • Faster access to LOB data

Restrictions[edit]

A SecureFile can only be created in an automatic segment space management (ASSM) tablespace.

Creating SecureFile LOBS[edit]

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));

Also see[edit]