exadata的几种压缩方式

SQL> create table my_objs_query_low compress for query low as select * from my_objs;

Table created.

SQL> create table my_objs_query_high compress for query high as select * from my_objs;

Table created.

02:48:00 SQL> create table my_objs_archive_low compress for archive low as select * from my_objs;

Table created.

SQL> create table my_objs_compress_oltp compress for oltp as select * from my_objs;

Table created.

16:09:49 U1::db1::db1::11868>create table my_objs_archive_high compress for archive high as select * from my_objs;

Table created.

02:46:36 SQL> select segment_name,bytes/1024/1024/1024 from dba_segments where segment_name like 'MY_OBJS%';

16:44:40 U1::db1::db1::11868>select segment_name,bytes/1024/1024/1024 from dba_segments where segment_name like 'MY_OBJS%';

SEGMENT_NAME		       BYTES/1024/1024/1024
------------------------------ --------------------
MY_OBJS 				     11.625
MY_OBJS_ARCHIVE_HIGH				 .5
MY_OBJS_ARCHIVE_LOW			       .625
MY_OBJS_COMPRESS_OLTP			      4.375
MY_OBJS_QUERY_HIGH			       .625
MY_OBJS_QUERY_LOW				1.5