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
