Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 27158 invoked from network); 19 Aug 2007 06:30:03 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 19 Aug 2007 06:30:03 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5B7C572B651;
 Sun, 19 Aug 2007 07:27:41 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 08797-06-3; Sun, 19 Aug 2007 07:27:41 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BFB8D72B627;
 Sun, 19 Aug 2007 07:27:40 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 19 Aug 2007 06:45:06 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE5AE72B5D0
 for <oracle-l@freelists.org>; Sun, 19 Aug 2007 06:45:05 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 29606-01-2 for <oracle-l@freelists.org>;
 Sun, 19 Aug 2007 06:45:05 -0400 (EDT)
Received: from heller.inter.net.il (heller.inter.net.il [213.8.233.23])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09FA672B52B
 for <oracle-l@freelists.org>; Sun, 19 Aug 2007 06:45:04 -0400 (EDT)
Received: from [192.168.0.29] ([212.68.138.137])
 by heller.inter.net.il (MOS 3.7.3a-GA)
 with ESMTP id DKE41990 (AUTH adar666);
 Sun, 19 Aug 2007 13:47:23 +0300 (IDT)
Message-ID: <46C81FC0.80909@inter.net.il>
Date: Sun, 19 Aug 2007 13:47:28 +0300
From: Yechiel Adar <adar666@inter.net.il>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: oracle-l <oracle-l@freelists.org>
Subject: Re: Early 11g Advanced Table Compression #'s
References: <39570F79-1349-44B7-8135-213264D0C95B@interealm.com>
In-Reply-To: <39570F79-1349-44B7-8135-213264D0C95B@interealm.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
X-archive-position: 762
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: adar666@inter.net.il
Precedence: normal
Reply-to: adar666@inter.net.il
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain

Hello Roby

The results are interesting and it seems to me that I should test before 
using in production.

One thing that I would like to know is what is the degree of compression 
of the tables?

Adar Yechiel
Rechovot, Israel



Roby Sherman wrote:
> For anyone interested, I ran some very quick benchmarks on 11g's new 
> Advanced Compression table option COMPRESS FOR ALL OPERATIONS that 
> Oracle is claiming was "specifically written to create only the most 
> 'minimal' of performance impacts in OLTP environments.
--
http://www.freelists.org/webpage/oracle-l