Re: SQL*Loader performance
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 17 Jan 2008 05:42:32 -0800
Message-ID: <bf46380801170542p7657e90tf6b3f1df6d909668@mail.gmail.com>
Date: Thu, 17 Jan 2008 05:42:32 -0800
Message-ID: <bf46380801170542p7657e90tf6b3f1df6d909668@mail.gmail.com>
On Jan 16, 2008 2:52 PM, Nigel Thomas <nigel_cl_thomas_at_yahoo.com> wrote:
>
> That's all I can think of at this time of night...
>
>
All I can think of is this:
Without knowing the exact structure of the old table, and seeing the DDL for
the new tables, as well as any procedures that may have changed, any attempt at diagnosis is just a guess.
By procedure I mean something like 'We drop index i1 and i2 when we load the table", which would beg the question "Is there now an index i3?"
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 17 2008 - 07:42:32 CST