Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 14408 invoked from network); 17 Aug 2007 08:57:53 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 17 Aug 2007 08:57:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A8D4572AE92; Fri, 17 Aug 2007 09:55:32 -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 23478-03-4; Fri, 17 Aug 2007 09:55:32 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 305E472AFBF; Fri, 17 Aug 2007 09:55:32 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 17 Aug 2007 09:12:56 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 749EF72B7AE for ; Fri, 17 Aug 2007 09:12:56 -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 10611-03 for ; Fri, 17 Aug 2007 09:12:56 -0400 (EDT) Received: from s-utl01-sjpop.stsn.net (s-utl01-sjpop.stsn.net [72.254.0.201]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 2BC6572B458 for ; Fri, 17 Aug 2007 09:12:53 -0400 (EDT) Received: from s-utl01-sjpop.stsn.net ([127.0.0.1]) by s-utl01-sjpop.stsn.net (SMSSMTP 4.1.2.20) with SMTP id M2007081706150905681 for ; Fri, 17 Aug 2007 06:15:09 -0700 X-Spam-Status: No, hits=0.0 required=9.9 tests=ALL_TRUSTED: -2.867,AWL: 1.037,BAYES_00: -1.665 X-Spam-Level: Received: from [10.5.139.82] ([10.5.139.82]) by s-utl01-sjpop.stsn.net for oracle-l@freelists.org; Fri, 17 Aug 2007 06:15:08 -0700 Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Message-Id: <39570F79-1349-44B7-8135-213264D0C95B@interealm.com> Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed To: oracle-l From: Roby Sherman Subject: Early 11g Advanced Table Compression #'s Date: Fri, 17 Aug 2007 07:14:57 -0600 X-archive-position: 700 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: rxsherm@interealm.com Precedence: normal Reply-to: rxsherm@interealm.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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. The results are here: http://web.mac.com/tikimac/iWeb/silicon/Roby_Sherman/ Oracle_Certifiable/Entries/2007/8/16_11G_TABLE_COMPRESSION_- _Don’t_Believe_the_Hype.html I guess their definition of minimal and my definition of minimal must be different... Anyway, if you're interested in this feature, feel free to take a quick look! --Roby -- http://www.freelists.org/webpage/oracle-l