My Oracle Support Banner

After Compressing A Table With More Than 255 Columns Then Its Size Is Lager (Doc ID 989484.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.2 to 11.2
Information in this document applies to any platform.


Once that a table with more than 255 columns has been compressed, then its size is more than when it was
an uncompressed table. This happens even when there are duplicate values.

Reviewed the information by commands:

SQL> select sum(bytes)/(1024*1024) from dba_segments where SEGMENT_NAME='TABLE_NAME';
SQL> select EXTENT_ID,BLOCKS from dba_extents where SEGMENT_NAME like 'TABLE_NAME';
SQL> select pct_free,pct_used from dba_tables where table_name='TABLE_NAME';


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.