Re: Early 11g Advanced Table Compression #'s

Could you explain exactly how any these tests reflect any type of OLTP workload? That is the new thing in 11g correct that you are attempting to demonstrate performance on, correct? Rather than commenting that the advanced compression is "quite horrible" I'd comment that your choice of tests are quite horrible.

On 8/17/07, Roby Sherman <rxsherm_at_interealm.com> wrote:
> Seems my mailer has cut off the apostrophe from the URL... It should be:
>
> 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
>
>
>
>
> 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.
>
> 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
>
>
>

-- 
Regards,

Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l