oracle upgrade & archiving

[VWR Admin]

after upgrading oracle from 8.1.6.2 to 8.1.7 on a V2500 the archive processes are taking forever and sar shows sys% anywhere from 50% to 90%. writes to the arch logs are going so slow that multiple arch processes start which further burdens the system. after a reboot things run fine for a while but then back into the same long archive processes! Anyone have this before or any ideas? Thanks Tom, tom_erickson@vwrsp.com

[R. Allan Hicks]

Are the archive logs switching more often? If so, why?

Could there be some tablespaces in hot backup causing the redo logs to fill more quickly?

What are the statuses of the tablespaces from V$BACKUP?

I'm at 8.1.6.0 and thinking about going to 8.1.7 so I'm real interested in what this turns out to be.

[VWR Admin]

This occurs during a purge process. We're still switching as many logs ans we we're under 8.1.6. The difference is the archive or multiple archivers slow down as time progresses. Normally the archive offloads a log in 30 seconds, we've seen it take up to 48 minutes in the wrose case situation. The tablespaces are not in backup mode during the purge process.
Go Sixers!!