Re: OLTP compression slow update

From: Michael Dinh <mdinh235_at_gmail.com>
Date: Tue, 25 Dec 2012 08:20:17 -0800
Message-ID: <CAENwkM5Wm6aT-L-rghdArSkd4HU-A78wog0MxrfR0OW09-NMNA_at_mail.gmail.com>

Thanks Kevin.
Brain fart for not thinking about database version.

11.2.0.3.4 database version

Index on fact: PK(1 col), AK(3 col), 1 non-unique index(1 col) No Index on staging

Updating 51 columns in fact (33,179,386 rows) using staging (911,861 rows)

pseudo code for update
for x in (staging) loop
update fact where fact.key <http://fact.pk>=x.key <http://x.pk> commit every 10000
end loop

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

Received on Tue Dec 25 2012 - 17:20:17 CET