Our AIX 4.3.3 system running Oracle 8.1.7.3 crashed the other day because it
ran out of swap space. The system is memory rich (32G) and our 4G swap
space is usually only 1% utilized. Before the system went down I was able
to determine from svmon that the process with the most swap usage was the
Oracle log writter task. The virtual size of the process was in excess of 3
million pages. Subsequently I have observed that its maximum seems to be
around 1.8 million pages. The alert logs showed no errors and log switching
seemed normal. What conditions might cause the log writter to use excessive
memory?
Received on Fri Jul 25 2003 - 16:37:06 CDT
