hcc etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster
hcc etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster

12 Mart 2018 Pazartesi

Exadata Lab 3: HCC Performance

TABLE Compress Performance

[oracle@qr01dbadm01 labs]$ sqlplus sh/sh
SQL> set timing on
SQL> alter session force parallel dml;
Session altered.

SQL> alter session force parallel ddl;
Session altered.

SQL> create table mycust_query_low
  2  column store compress for query low
  3  nologging parallel 4
  4  as select * from mycustomers;
Table created.
Elapsed: 00:02:17.89

SQL> create table mycust_query_high
  2  column store compress for query high
  3  nologging parallel 4
  4  as select * from mycustomers;
Table created.
Elapsed: 00:00:28.45

SQL> create table mycust_archive_low
  2  column store compress for archive low
  3  nologging parallel 4
  4  as select * from mycustomers;
Table created.
Elapsed: 00:00:43.35