Re: Loading Data into Oracle

In article: <D9wy1L.By5_at_empros.com> ralldaff_at_empros.com (Ronald Alldaffer) writes:
>
> We are trying to insert alot of data into an ORACLE indexed table, and
> want to know what the fastest way to do this is. We are attempting to
> load 16000 records every 10 seconds, each record containing 6 fields, for a
> total of 32 bytes/record.
>
> Right now, to use SQL*Loader without the direct option, this takes us about
> 50 seconds to do. If we use the DIRECT=TRUE option, it takes about 12-15
> seconds. Both of these are on an empty machine. ( unix machine, type unknown )
>
> My questions is, is the DIRECT=TRUE option for SQL*Loader the fastest possible
> way to insert data into an ORACLE table? Are there any other faster ways
> to do this?
>
> Any possible ways to improve the performance of inserting data, while
> maintaining query access would be appreciated.
>
> Thanks for any help that you can provide.
> Ron Alldaffer
> --
> ====================================================================
> ====================================================================
>
>

  You could try running sqlloader in parallel sessions.

	Come, let us retract the foreskin of ignorance, and apply the
	wirebrush of enlightenment

	Tim London			phone :	+44 1753 662393
	Oracle DBA,Trainer and		mobile:	+44 836 287064
	part time OU tutor		Email : tim_at_artemis.demon.co.uk
----------------------------------------------------------------------------