RETENTION与LOB

RETENTION：The RETENTION parameter is designed for use with UNDO features of the database, such as Flashback Versions Query. When a LOB column has the RETENTION property set, old versions of the LOB data are retained for the amount of time specified by the UNDO_RETENTIONparameter.就像是UNDO_RETENTION一样，RETENTION用来保存陈旧的LOB数据的。RETENTION在ASSM管理表空间中才对basicfile lob有效，手动管理表空间的retention对此无效。
? Specify MAX if the database is in FLASHBACK mode to limit the size of the LOB UNDOretention in bytes. If you specify MAX, then you must also specify the MAXSIZE clause in the storage_clause.?
? Specify AUTO if you want to retain UNDO sufficient for consistent read purposes only. This is the default.?
? Specify NONE if no UNDO is required for either consistent read or flashback purposes.?
The default RETENTION for SecureFiles is AUTO.


既然retention是针对lob的，我们来看看lob
lob段分为两种存储结构，basicfile lob和securefile lob
If the COMPATIBLE initialization parameter is not set to 11.1.0 or higher, then LOBs are not treated as SecureFiles.
11g后才有cecurefile，securefile是11g新增的lob段存储类型。
A SecureFiles LOB can only be created ina tablespace managed with Automatic Segment Space Management (ASSM)，securefile lob只能在ASSM管理表空间中创建
db_securefile参数指定了log 文件创建时是否是securefile。
11g有以下参数值


? NEVER?Any LOBs that are specified as SecureFiles are created as BasicFiles LOBs. All SecureFiles-specific storage options and features (for example, compress, encrypt, deduplicate) will cause an exception. The BasicFiles LOB defaults will be used for storage options not specified.任何指定LOB为securefile的都只会创建普通lob?
? PERMITTED?LOBs are allowed to be created as SecureFiles.允许指定LOB为securefile
? ? ALWAYS?Attempts to create all LOBs as SecureFiles LOBs but creates any LOBs not in an Automatic Segment Space Managed (ASSM) tablespace as BasicFiles LOBs, unless SECUREFILE is explicitly specified. Any BasicFiles LOB storage options that are specified will be ignored and the SecureFiles LOB defaults will be used for all storage options not specified.在自动段管理表空间中除非指定建立basicfile lob否则将自动创建securefile lob，其他情况都是直接创建securefile lob
? IGNORE?The SECUREFILE keyword and all SecureFiles options are ignored.securefile关键字和选项都失效
12c新增参数值
? PREFERRED?All LOBs are created as SecureFiles unless BASICFILE is explicitly specified in the LOB storage clause or the tablespace is a Manual Segment Space Management tablespace. When PREFERRED is set, cases where BASICFILE would otherwise be inherited from the partition or column level LOB storage are ignored; the LOBs will be created as SecureFiles instead.?在手动管理表空间中，除非指定basicfile否则将建立securefile


If there is a LOB column with two partitions (one that has a tablespace for which ASSM is enabled and one that has a tablespace for which ASSM is not enabled), then LOBs in the partition with the ASSM-enabled tablespace will be treated as SecureFiles and LOBs in the other partition will be treated as BasicFile LOBs.
感觉很奇特，securefile只能在ASSM表空间中存在，所以也能理解

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31461640/viewspace-2141287/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31461640/viewspace-2141287/