Re: Early 11g Advanced Table Compression #'s

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.

Rgds

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
>
>
>

--
http://www.freelists.org/webpage/oracle-l