The tests were done on a Linux VMWare machine, running on a single CPU pc (a
dell 600), configured with 1G or RAM, and a file-based disk. The DB used
ASM, with around 700M for the DB (SGA+stuff).
rgds
On 9/11/06, Kevin Closson <kevinc_at_polyserve.com> wrote:
>
> Do you plan to update this thread with you current findings? Also,
> what type and config of system did you get that measured 4% out of?
>
>
> ------------------------------
> *From:* Ghassan Salem [mailto:salem.ghassan_at_gmail.com]
> *Sent:* Wednesday, August 30, 2006 12:49 AM
> *To:* kevinc_at_polyserve.com
> *Cc:* oracle-l_at_freelists.org
>
> *Subject:* Re: Loading data usng External Tables
>
> Kevin,
>
>
> I cannot give you any numbers, but I've surely seen much better
> performance when loading from fixed format files.
>
> If I got some time today, I'll do some tests and get back to you.
>
> rgds
>
> On 8/29/06, Kevin Closson <kevinc_at_polyserve.com> wrote:
> >
> >
> > >George,
> > >you can parallel either format (csv or fixed length),
> > >Fixed length is much faster as the system will not have to scan
> > the data to find out the ',' to delimit each field.
> >
> > ...have you measured how much faster, or are you basing this
> > on principle? I perform huge, high end loads from external tables
> > and have achieved as much as 250,000/sec per CPU with variable length.
> >
>
> --
>
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 11 2006 - 10:38:42 CDT
