Oracle Securefile and options (compression, deduplication, and encryption)
Oracle has introduced LOBs for managing large unstructured data insite the Oracle database. The introduction of LOBS suffers from several drawbacks in Oracle version before Oracle 11g: The LOBs where created for mostly " write once, read many times" operations and couldn't handle frequent updates LOBs assumed low concurrent usage data Undo retianed by setting the retention and pctversion parameters, addidition management burden LOBs weren't expected to be very large in size LOBs size is uniform, max chunk size could only be 32KB LOBs were not planned with concurrent usage requirements in Oracle RAC in mind The reality has changed en today LOBs are quite large, and comes in all sizes. Oracle 11g introduced a complete new way of handeling unstructured data to address the concerns resulting from the way LOBs are currently implemented. The new introduced LOB data type is called : Oracle Securefiles. The old LOB data type wil be referenced by Oracle as BasicFil...