Листинг 3: Сравнение количества блоков в не сжатой и сжатой таблице

ANALYZE TABLE SALES_HISTORY COMPUTE STATISTICS;
ANALYZE TABLE SALES_HISTORY_COMP COMPUTE STATISTICS;

SELECT TABLE_NAME, BLOCKS, NUM_ROWS, COMPRESSION
FROM USER_TABLES
WHERE TABLE_NAME LIKE 'SALES_HIST%';

TABLE_NAME                BLOCKS   NUM_ROWS   COMPRESSION
------------------        ------  --------   -----------
SALES_HISTORY              12137    1000000   DISABLED
SALES_HISTORY_COMP          6188    1000000   ENABLED