Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle performance on large loads

Re: Oracle performance on large loads

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1996/12/11
Message-ID: <Zb6P4TA+zuryEwrW@jimsmith.demon.co.uk>#1/1

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
Received on Wed Dec 11 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US