Re: Early 11g Advanced Table Compression #'s

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 17 Aug 2007 09:27:15 -0700
Message-ID: <bf46380708170927o332f0cd2y93e88b36edd7eedb@mail.gmail.com>

On 8/17/07, Roby Sherman <rxsherm_at_interealm.com> 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.
>
>

You may want to try these on a local machine.

Oracle's test systems are usually virtual systems, enabling fast setup of classroom environments.

The resources allocated to the VM's are probably somewhat restrictive, and yours is competing with the others for resources as well.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Fri Aug 17 2007 - 11:27:15 CDT