Oracle Secure Files
Jump to navigation
Jump to search
What is SecureFiles?
- Current solutions to store unstructured or semi-structured data
- LOB – part of database but there is a limitation in sizing, low concurrency of DMLs
- OS Files – ease of access, compressed format, but not part of db backup nor security
- The SecureFiles in 11g gives the best features of database-resident LOBs and OS files.
- Note that traditional LOBs are still available in the form of BasicFiles.
Benefits of the SecureFiles
- Variable chunk size
- De-duplication
- Oracle stores only reference if identical copy of LOB data is already in database. Oracle uses a secure hash index to detect duplication.
alter table contracts_sec modify lob(orig_file)(DEDUPLICATE LOB);
- Main benefit is dramatic reduction in storage usage.