Tuning the arch process does'nt work
I was doing an import (commit=y)
of a number of tables, some small,
some large. I got the same error
when it imported a table with 500 000 records.
I added a redo log group - no success
I attempted to solve the problem by increasing
LOG_ARCHIVE_BUFFERS and decreasing
LOG_ARCHIVE_BUFFER_SIZE to speed up the
ARCH process - no success.
Luckily, the error does not abort the import - it
just seems to slow it down.
Thanks, but already knew that.
Oracle 8, WIN NT
Archive disk is not full.
Archiving was set to automatic.
I will check the alert log.
My next try will be to make the redo log files
REALLY big.
Why is it I can't increase LOG_ARCHIVE_BUFFERS
greater than 5 ?
More redo log groups, bigger redo logs
Interesting - no ORA ERROR message appears
in the ALERT LOG, just a 'warning' that a log cannot
be allocated.
Adding a few groups of redo logs works
AND/OR
Making your redo logs bigger also helps.