03.08.2012 10:30
OlegON
 
Код:
declare
cmp_ratio number;
comptype_str varchar2(300);
blkcnt_cmt number;
blkcnt_uncmp number;
row_cmt number;
row_uncmp number;
begin
dbms_compression.GET_COMPRESSION_RATIO(
SCRATCHTBSNAME=>'USERS',
OWNNAME=>'FDC_DWH',
TABNAME=>'FDC_PAYMENT_FACT',
PARTNAME =>null,
COMPTYPE =>4,
BLKCNT_CMP=>blkcnt_cmt,
BLKCNT_UNCMP=>blkcnt_uncmp,
ROW_CMP =>row_cmt,
ROW_UNCMP =>row_uncmp,
CMP_RATIO=>cmp_ratio,
COMPTYPE_STR=>comptype_str);
dbms_output.put_line('====================================================');
dbms_output.put_line('1. Compression Ratio :'||cmp_ratio);
dbms_output.put_line('2. Block Count :'||blkcnt_cmt);
dbms_output.put_line('3. Compression Type :'||comptype_str);
dbms_output.put_line('4. Blk Count Compressed :'||blkcnt_cmt);
dbms_output.put_line('5. Blk Count Un-compressed:'||blkcnt_uncmp);
dbms_output.put_line('6. Row Count Compressed :'||row_cmt);
dbms_output.put_line('4. Row Count Un-Compressed:'||row_uncmp);
dbms_output.put_line('===================================================='); 
end;
Цитата:
1 - No compression
2 - OLTP compression
4 - High compression level for query operations
8 - Low compression level for query operations
16 - High compression level for archive operations
32 - Low compression level for archive operations
Часовой пояс GMT +3, время: 09:26.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.