What is Exadata

What is Exadata

Exadata Architecture -

ype of Compression -
1. Basic - Only direct path load data is compressed. PCT free set to 0. Create table...compress;
2. OLTP - non-Direct path load data is stored and compressed only when block becomes full. PCT Free set to 10. create table ... compress for OLTP;
3. HCC - Only for Exadata.- HYBRID COLUMNAR COMPRESSION..

Tables may be compressed with HCC using the following syntax:

CREATE TABLE ... COMPRESS FOR QUERY LOW;
CREATE TABLE ... COMPRESS FOR QUERY HIGH;
CREATE TABLE ... COMPRESS FOR ARCHIVE LOW;
CREATE TABLE ... COMPRESS FOR ARCHIVE HIGH;


Difference in V2 - X2-2 and X2-8 models -