玉面飞龙的BLOG

Home
About me
Archives
我的订阅
招揽生意
鸣谢

whether LOB is retention or pctversion based

January 21st, 2008 | Categories: Boring | Tags:

We can use below SQL to check if one lob segment’s consistent read policy is based on retention or pctversion.

select decode(bitand(flags,32), 32, ‘Retention’, ‘Pctversion’) || ‘ policy used’ “LOB CR Policy”
from sys.lob$ where lobj# = (select object_id from dba_objects where object_name =
(select segment_name from dba_lobs where table_name = :1 and owner = :2 ));

Do a simple test

create table testlob (a clob);
alter table testlob modify lob (a) (pctversion 10);
LOB CR Policy
———————–
Pctversion policy used

alter table testlob modify lob (a) (retention);
LOB CR Policy
———————–
Retention policy used