compress

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 17 May 2005 00:38:14 +0200
Message-ID: <d6b7ck$7md$02$1@news.t-online.com>

Hi, list,
did somebody experienced that behaviour? (there are no concurrent sessions)
mmm_at_APPL> select count(*) from t_noc;

COUNT(*)

4506664

mmm_at_APPL> alter table t_noc move compress;

Tabelle wurde geändert.

mmm_at_APPL> select count(*) from t_noc;

COUNT(*)

4506722

I could reproduce this on 9.2.0.6 as well 9.2.0.4 on linux, i'd searched Metalink on this issue, but found nothing similar. I'll open an iTAR tomorrow, but, maybe, its a known bug, so any expirience will be appreciated. The only thing i can suspict at the moment - there are 2 columns with varchar2(4000) and the blocksize is 8k, so maybe this is the row chaining that cause compress algorithm to fail...

Best regards

Maxim Received on Mon May 16 2005 - 17:38:14 CDT