Re: Oracle performance on large loads

In article <32ACAAE7.211E_at_ix.netcom.com>, thielm <thielm_at_ix.netcom.com> writes
>We have several 250 MB Asci Text Files with snapshots of weekly data
>from another system
>that we would like to load into an oracle database. Each Text File
>contains around 800,000
>records and each record represents a fairly complicated relation
>betweenabout 8 entities.
>Several records can also relate to each other.
>

.
.
>The actual loading of the 1 file take's about 140 Hours on a 133Mhz
>pentium with 128 MB of
>memory and 3 4GB harddrives running NT 3.51. Datafiles are spread out as
>good as possible
>to minimize contention. All the obvious parameters like
>db_block_buffers, shared pool size
>etc seem to be set ok.
>

One possibility is that your redo logs are too small and/or your archive process is too slow, resulting in lots of waits for log switches,

Look in your alert log for messages related to log switches.

-- 
Jim Smith