Re: Tested 11g OLTP compression and found rather serious issue
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 10 Aug 2009 07:10:44 +0100
Message-ID: <n7GdnSG23-x_JOLXnZ2dnUVZ8ladnZ2d_at_bt.com>
Date: Mon, 10 Aug 2009 07:10:44 +0100
Message-ID: <n7GdnSG23-x_JOLXnZ2dnUVZ8ladnZ2d_at_bt.com>
"Tamkatten_at_gmail.com" <tamkatten_at_gmail.com> wrote in message news:c3c48bcf-640d-4351-801c-9b6f13267069_at_j9g2000vbp.googlegroups.com...
>Hi again,
>
>Further findings on OLTP compression :
>
But this is just like your previous test. You are testing an OLTP feature with a DSS type of update.
General point with Oracle - understand what a feature is for, and then use it when it is supposed to be used, and think carefully before using it where it is not supposed to be used.
Congratulations, by the way, on thinking up a couple of good test demonstrations of the types of scenario where online compression is not appropriate.
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Mon Aug 10 2009 - 01:10:44 CDT