How to check compression enabled on partition table

 

How to check compression enabled on partition table

=======================================

select

a.partition_name, a.tablespace_name, a.compression, a.compress_for , round(sum(a.num_rows / a.blocks),0) rows_per_block,

sum(a.num_rows) num_rows, sum(a.blocks) blocks , sum(b.bytes) /(1024*1024) mb

from dba_tab_partitions a, dba_segments b

where

a.table_name = 'TESTCOMP' and

a.partition_name = b.partition_name and

a.table_name = b.segment_name

group by a.partition_name, a.tablespace_name, a.compression, a.compress_for

order by 1;