Re: OLTP compression slow update

From: Michael Dinh <mdinh235_at_gmail.com>
Date: Tue, 25 Dec 2012 09:02:13 -0800
Message-ID: <CAENwkM4gZW7Z4M26R+XraSygiR-4yPhoVEUcRQ5byvGJz5A2FQ_at_mail.gmail.com>

Thanks Jared.
Think we got bit by marketing bug. Back to basic and it does not get any easier than that.

CREATE TABLE md_fct_oltp PCTFREE 20 COMPRESS FOR OLTP AS SELECT Elapsed: 00:19:38.28

CREATE TABLE md_fct_nocp PCTFREE 20 AS SELECT Elapsed: 00:04:40.25

runstat here I come.

On Tue, Dec 25, 2012 at 8:34 AM, Jared Still <jkstill_at_gmail.com> wrote:

>
> 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 - 18:02:13 CET