Re: Loading data usng External Tables

  • From: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
  • To: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • Date: Mon, 11 Sep 2006 17:38:42 +0200

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).

On 9/11/06, Kevin Closson <kevinc@xxxxxxxxxxxxx> 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@xxxxxxxxx] *Sent:* Wednesday, August 30, 2006 12:49 AM *To:* kevinc@xxxxxxxxxxxxx *Cc:* oracle-l@xxxxxxxxxxxxx

*Subject:* Re: Loading data usng External Tables


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.


On 8/29/06, Kevin Closson <kevinc@xxxxxxxxxxxxx> 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.



Other related posts: