|
|
原帖由 jj_kin 于 2009-7-28 07:48 发表 ![]()
先透露11gR2的两个新亮点:
1. 11gR2开始将支持列级存储,专门针对DSS类型系统压缩数据,减少IO
2. 使用RAC-one可以在single instance上免费体验rac的部分功能,以支持patching,grid 2.0
... ...
查了资料列级存储无要Exadata Server也可以,但对性能有较大的影响呀.
archive level 有三个选项level=(none,2,3)
none-compress:
CREATE TABLE cust_nocomp
AS SELECT * FROM SH.CUSTOMERS;
comp-level=2:
CREATE TABLE cust_hcc_query
COMPRESS FOR ARCHIVE LEVEL=2
AS SELECT * FROM SH.CUSTOMERS;
comp-level=3:
CREATE TABLE cust_hcc_archive
COMPRESS FOR ARCHIVE LEVEL=3
AS SELECT * FROM SH.CUSTOMERS;
[ 本帖最后由 mkcvictor 于 2009-8-11 08:32 编辑 ] |
|