Re: SQL*Loader performance
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 17 Jan 2008 09:42:58 -0800
Message-ID: <bf46380801170942v7b22170mb032b948c29ecad5@mail.gmail.com>
Date: Thu, 17 Jan 2008 09:42:58 -0800
Message-ID: <bf46380801170942v7b22170mb032b948c29ecad5@mail.gmail.com>
On Jan 17, 2008 8:46 AM, <genegurevich_at_discover.com> wrote:
> Jared,
>
> ... think that couple of columns were removed. There were nothing else.
>
>
Try loading just one of the tables and do a 10046 trace on it.
Or if in a database with no users, run before and after statspack snapshots.
Or use ASH/AWR if you have it.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 17 2008 - 11:42:58 CST