Redo Logfile and Archiving Problem
I have an Oracle 9.2.0.6. database running on Solaris in archivelogmode.
For some reason the UNDO tablespace is filling up and doesn't seem to empty, while the redo logfiles (after filling up) don't write to the archivelogs leading to a standstill of the instance. There is still loads of disk space that the archivelogs could be written to and the init ora parameters are set to sensible values.
After restarting the instance, the UNDO tablespace is still pretty full.
Could this have something to do with very large transactions that continue to process data beyond the capacity of the UNDO tablesoace and the redo logfiles, or what could possibly cause this?
Re: Redo Logfile and Archiving Problem
Quote:
Originally posted by Peer Jones
I have an Oracle 9.2.0.6. database running on Solaris in archivelogmode.
For some reason the UNDO tablespace is filling up and doesn't seem to empty, while the redo logfiles (after filling up) don't write to the archivelogs leading to a standstill of the instance. There is still loads of disk space that the archivelogs could be written to and the init ora parameters are set to sensible values.
select * from v$log;
show parameter arch;
archive log all;
select * from v$log;
archive log start;
Any Errors in the alert-log ?
Quote:
After restarting the instance, the UNDO tablespace is still pretty full.
Could this have something to do with very large transactions that continue to process data beyond the capacity of the UNDO tablesoace and the redo logfiles, or what could possibly cause this?
Very likely - You never should run "special" (huge) transactions without ESTIMATING the archivelog-amount and undo-space required, if you don't have sufficient experience, than you need to test it in a fully-sized pre-production environment.
Please read the chapter about "Undo-Segments" in the CONCEPTS-Manual - this manually is REALLY GREAT to achive understanding.
Are you running the new automated undo-management or the old Rollback-Segments (both have advantages ...)
show parameter undo
