Re: SQL*Loader performance
Date: Thu, 17 Jan 2008 10:12:25 -0600
Message-ID: <OF37EDAD82.2D927D1F-ON862573D3.0058E32A-862573D3.0059062E@discover.com>
Jared,
What would you be looking for in the DDLs for old and new tables? I can
post them here, but the are very very
long and I don't think anyone will have time to look over them
thank you
Gene Gurevich
"Jared Still"
<jkstill_at_gmail.co
m> To
nigel_cl_thomas_at_yahoo.com
01/17/2008 07:42 cc
AM genegurevich_at_discover.com, oracle-l
<oracle-l_at_freelists.org>
Subject
Re: SQL*Loader performance
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-l
Received on Thu Jan 17 2008 - 10:12:25 CST