Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 389 invoked from network); 17 Aug 2007 12:44:17 -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 12:44:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2DA0272B521; Fri, 17 Aug 2007 13:41: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 04680-04-4; Fri, 17 Aug 2007 13:41:56 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8D36F72B356; Fri, 17 Aug 2007 13:41:55 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 17 Aug 2007 12:59:19 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 761E172B891 for ; Fri, 17 Aug 2007 12:59:19 -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 21360-02-2 for ; Fri, 17 Aug 2007 12:59:19 -0400 (EDT) Received: from plmler9.mail.eds.com (plmler9.mail.eds.com [199.228.142.117]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40F0472B7E0 for ; Fri, 17 Aug 2007 12:59:16 -0400 (EDT) Received: from plmlir4.mail.eds.com (plmlir4-2.mail.eds.com [199.228.142.134]) by plmler9.mail.eds.com (8.13.8/8.13.8) with ESMTP id l7HH1ao1004023 for ; Fri, 17 Aug 2007 12:01:37 -0500 Received: from plmlir4.mail.eds.com (localhost [127.0.0.1]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id l7HH1S8f001536 for ; Fri, 17 Aug 2007 12:01:28 -0500 Received: from usplm014.amer.corp.eds.com ([148.94.166.7]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id l7HH1SmG001531 for ; Fri, 17 Aug 2007 12:01:28 -0500 Received: from usahm208.amer.corp.eds.com ([130.175.198.40]) by usplm014.amer.corp.eds.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 17 Aug 2007 12:01:28 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7E0F0.400C5933" Subject: RE: Early 11g Advanced Table Compression #'s Date: Fri, 17 Aug 2007 13:01:23 -0400 Message-ID: In-Reply-To: <411d50f60708170747s1c42bf20r16f618f3c2a73209@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Early 11g Advanced Table Compression #'s From: "Powell, Mark D" To: "oracle-l" X-OriginalArrivalTime: 17 Aug 2007 17:01:28.0462 (UTC) FILETIME=[40A422E0:01C7E0F0] X-archive-position: 722 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-to: mark.powell@eds.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 ------_=_NextPart_001_01C7E0F0.400C5933 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable We have an OLTP and insert select * where is often used. Data quantities of 10M are not uncommon for the size of the transaction data though most of our operations work on just a few rows at a time. Then again we do have a significant batch cycle where entire tables get processed usually using loops that commit after every row or every few rows. In many cases the commits are necessary because the same rows we are updating are needed in other concurrent transactions and in some cases the commit is just left over from the days when the size of the rollback segments needed to support a transaction had to be kept small (application over 12 years old now).=20 =20 I think good set of tests would run the gambit from single row operations, small set operations, to large set operations, and to row by row processing of the entire table because all of this can exist in one real-world system. =20 -- Mark D Powell --=20 Phone (313) 592-5148=20 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ghassan Salem Sent: Friday, August 17, 2007 10:47 AM To: rxsherm@interealm.com Cc: oracle-l Subject: Re: Early 11g Advanced Table Compression #'s =09 =09 Roby, what do you mean by 'bulk insert' and 'bulk update'? To simulate an OLTP, you can you a loop inserting a row and commiting each time, as OLTP means simple small transactions. =09 Rgds =09 =09 On 8/17/07, Roby Sherman wrote:=20 Seems my mailer has cut off the apostrophe from the URL... It should be:=20 =09 http://web.mac.com/tikimac/iWeb/silicon/Roby_Sherman/Oracle_Certifiable/ Entries/2007/8/16_11G_TABLE_COMPRESSION_-_Don%E2%80%99t_Believe_the_Hype .html =09 On Aug 17, 2007, at 7:14 AM, 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.=20 The results are here: =09 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 ------_=_NextPart_001_01C7E0F0.400C5933 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
We have an OLTP and insert select * where is = often=20 used.  Data quantities of 10M are not uncommon for the size of the=20 transaction data though most of our operations work on just a few = rows=20 at a time.  Then again we do have a significant batch = cycle=20 where entire tables get processed usually using loops that commit = after=20 every row or every few rows.  In many cases the commits are = necessary=20 because the same rows we are updating are needed in other concurrent=20 transactions and in some cases the commit is just left over from the = days when=20 the size of the rollback segments needed to support a = transaction had to=20 be kept small (application over 12 years old=20 now). 
 
I think good set of tests would run the = gambit from=20 single row operations, small set operations, to large set operations, = and to row=20 by row processing of the entire table because all of this can exist in = one=20 real-world system.
 

-- Mark D Powell = --=20
Phone (313) = 592-5148=20

 
From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ghassan=20 Salem
Sent: Friday, August 17, 2007 10:47 AM
To:=20 rxsherm@interealm.com
Cc: oracle-l
Subject: Re: = Early 11g=20 Advanced Table Compression #'s

Roby,
what do you mean by 'bulk insert' and 'bulk = update'?
To=20 simulate an OLTP, you can you a loop inserting a row and commiting = each time,=20 as OLTP means simple small transactions.

Rgds

On 8/17/07, Roby=20 Sherman <rxsherm@interealm.com>=20 wrote:
Seems my mailer has cut off the apostrophe from the = URL... It=20 should be:

http://web.mac.com/tikimac/iWeb/silicon/Roby_Sherman/Orac= le_Certifiable/Entries/2007/8/16_11G_TABLE_COMPRESSION_-_Don%E2%80%99t_Be= lieve_the_Hype.html


On Aug 17, 2007, at 7:14 AM, Roby Sherman wrote:

For anyone interested, I ran some very = quick=20 benchmarks on 11g's new Advanced Compression table option COMPRESS = FOR ALL=20 OPERATIONS that Oracle is claiming was "specifically written to = create=20 only the most 'minimal' of performance impacts in OLTP = environments.=20

The results are here:
http://web.mac.com/tikimac/iWeb/silicon/Roby_Sherman/Orac= le_Certifiable/Entries/2007/8/16_11G_TABLE_COMPRESSION_-_Don't_Believ= e_the_Hype.html

I guess their definition of minimal and = my=20 definition of minimal must be different... Anyway, if you're = interested in=20 this feature, feel free to take a quick look!

--Roby



------_=_NextPart_001_01C7E0F0.400C5933-- -- http://www.freelists.org/webpage/oracle-l