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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Speeding up the redo logs

Re: Speeding up the redo logs

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Tue, 23 Jan 2001 01:21:38 GMT
Message-ID: <C05b6.297673$U46.9512439@news1.sttls1.wa.home.com>

Get the redos off RAID 5 and stripe them. Determine what the write IO's per second capacity is of the stripped set you put hte redo's on. That is one of the limits of the import.
Jim

<argosy22_at_my-deja.com> wrote in message news:94hpe6$qof$1_at_nnrp1.deja.com...
> HI Everyone,
>
> Thanks for writing. I've been struggling with this for a while now.
>
> We are running VALinux. 8.1.7.0.0 Enterprise edition.
> Linux 2.2.14-VA.5.1smp #1 SMP Tue Sep 12 21:26:21 PDT 2000 i686
> All configured with RAID 5. 4 CPUs
>
> We initially began testing with sqlloader in parallel. And with
> partitioned tables. However, I soon noticed that the slowest part
> was the redo logs. So, this is what I am concentrating on now.
>
> Any other ideas?
>
> Thanks
>
>
>
> In article <94akes$e02$1_at_nnrp1.deja.com>,
> argosy22_at_my-deja.com wrote:
> > Hi all,
> >
> > I'm currently working on a project where we will eventually
> > want to insert up to a billion rows a day into the database.
> > This is an average of over 11,000 rows per second.
> >
> > To this point, I've just made a table called JUNK:
> >
> > Name Null? Type
> > ----------------------------------------- --------
> > ----------------------------
> > JUNK_ID NUMBER(6)
> > JUNK_DESC VARCHAR2(20)
> >
> > I truncate this, and populate it with 1 million rows with a PLSQL
> > routine. It takes 2 minutes 38 seconds to populate it.
> > About 6,300 inserts per second. Naturally, if I add indexes, it
> > slows the inserts down a lot.
> >
> > The main part that slows everything down is the redo logs.
> > There are five 50 meg redo logs on their own drive.
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 22 2001 - 19:21:38 CST

Original text of this message

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