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: Redo killer

Re: Redo killer

From: John <nytimesjdarrah_at_hotmail.com>
Date: 27 Oct 2004 09:41:51 -0700
Message-ID: <289173ea.0410270841.99da82c@posting.google.com>


What's your commit frequency? Can you direct path load the data nologging?

mmoore_gmp_at_yahoo.com (Mike Moore) wrote in message news:<43c454d1.0410251150.21c990eb_at_posting.google.com>...
> Part of our billing process creates over 1 million inserts into a
> table which kills our redo logs. Then when the process is complete
> the data is extracted and never referenced again. We truncate the
> table each night. In other words the data is semi-temporary.
>
> I'd change the table definition to a temporary table, except that if
> the program crashes it needs to pick up where it left off and not
> start all over again. There has got to be another way to handle this
> process, but I'm at a loss for a solution. Any ideas would be greatly
> appreciated!!!
Received on Wed Oct 27 2004 - 11:41:51 CDT

Original text of this message

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