Re: Log writter excessive memory usage.

Hi!

First thing that comes into my mind is why have you configured only 4G of swap with 32G of memory?
I'm not sure about AIX, but AFAIK standard Unixes like Solaris and HP-UX do want to map whole memory to pagefile as well, so if you want real paging to occur, you should actually have even more space allocated.

I don't believe it's changed in recent versions...

Btw. linux is different, it handles virtual memory differently & doesn't want to match physical memory with swap space. (On Windows I don't know how it works and do not care much either..)

Tanel.

"VinceM" <vincem_at_nospam.com> wrote in message news:1059168995.647984_at_nnrp1.phx1.gblx.net...
> 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 - 18:27:41 CDT