Compressed Blocks en Compressed Segments | ExpoDBA

Compressed Blocks en Compressed Segments

Compressed Blocks en Compressed Segments

set linesize 200
select u.name, o.name, o.subname,s.spare1, decode (BITAND(s.spare1, 4096), 4096, 'COMPRESSED', 'UNCOMPRESSED') Block, 
decode (BITAND(s.spare1, 2048), 2048, 'COMPRESSED', 'UNCOMPRESSED') Segment
from SYS.OBJ$ o, SYS.USER$ u, SYS.SYS_OBJECTS so ,  SYS.SEG$ s
where o.owner# = u.user# 
and o.OBJ# = so.OBJECT_ID 
and s.file#= so.header_file
AND s.block# = so.header_block
and o.name like '%&OBJECT_NAME%';