Many customer databases do not use the Oracle partitioning feature. If partitioning is not used, then you can use Oracle catalog queries to identify datafiles that are not very active. Periodically, you can query the catalog tables and identify the least active datafiles and compress those files, as illustrated in the following example procedure.
To identify the least active datafiles and compress those files
SQL> select name, phyrds + phywrts 'TOT_IO' from v$datafile d and v$filestat f where d.file# = f.file# order by TOT_IO;
$ /opt/VRTS/bin/vxcompress file1 file2 file3 ...
$ /opt/VRTS/bin/vxcompress -u file1 file2 file3 ...