Re: SQL*Loader performance - conclusion
From: <genegurevich_at_discover.com>
Date: Mon, 28 Jan 2008 14:26:03 -0600
Message-ID: <OFF6FDADC9.2BFA6AF8-ON862573DE.006FEA9B-862573DE.00703FB1@discover.com>
Date: Mon, 28 Jan 2008 14:26:03 -0600
Message-ID: <OFF6FDADC9.2BFA6AF8-ON862573DE.006FEA9B-862573DE.00703FB1@discover.com>
Hi all:
It turned out that on the days when the performance of the load decreased, there was another process running at the same time (unbeknownst to my application team). After that other process was rescheduled for another time the load performance went back to normal.
Thanks to all who replied to my Emails (Nigel, Jared, Paul, Mark, Mark, Parasad - sorry if I missed anyone). It was very educational for me.
thank you
Gene Gurevich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 28 2008 - 14:26:03 CST