Hi,
I have a bunch of AIX systems which usually have more than enough memory to live happily. Unfortunately we have on a few of our boxes an rman runaway problem - every now and than after restoring from rman backups, the process goes crazy and eats all memory it could possibly get hold off - sometimes 100 gig and more just in a couple of minutes ... and oracle cannot find the root cause for this for months ...
Since this happens to real business critical DB boxes, my question: does anyone know which memory setting is responsible for the behaviour on an AIX 5.3 lpar when paging space runs full?
I have a few boxes that recycle themselves, others start just forking / hanging / killing randomly processes to survive - where is no point as AIX usually thinks killing the DBs is a great idea - so a system restart would be my preferred behaviour as this is anyways what I have to do when the box hangs - and the boxes that do it themselves save me a lot of paperwork / hazzle - and are usually fine for months afterwards
I know I know - solving the problem should be highest priority and we are working on it - but until than ... I want restarts
Kind regards
zxmaus