Re: OLTP compression slow update

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 25 Dec 2012 08:34:28 -0800
Message-ID: <CAORjz=NMZiDjMXUVZjWS+unD4Y+i0Kev7RqmPb4URHVG0YM9OA_at_mail.gmail.com>

On Mon, Dec 24, 2012 at 8:52 PM, Michael Dinh <mdinh235_at_gmail.com> wrote:
> Hello,
> Does anyone have any experience with updating compressed table?
>
> The only difference between 2 tables is no compression vs OLTP compression.
>
> PL/SQL using FOR loop updating 1 row and a time and commit every 10,000
> rows.
>

Michael,

This would be an excellent opportunity to use Tom Kyte's runstats<http://appsdba.com/techinfo/runstats.htm> ( modified version and original both available there)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

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

Received on Tue Dec 25 2012 - 17:34:28 CET