Pessoal, não sei se vocês passam por isso, mas tenho um oracle rac (11g R2) e de tempos em tempos (coisa de 15 dias) preciso reiniciá-los para liberar memória, já apliquei alguns patches mas sem solução, alguém já passou por isso?
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Solaris: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production Oracle Interim Patch Installer version 11.2.0.3.4 OPatch version : 11.2.0.3.4 OUI version : 11.2.0.3.0 Oracle Database 11g 11.2.0.3.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 16902043 : applied on Tue Oct 29 17:59:40 GMT-03:00 2013 Unique Patch ID: 16755734 Patch description: "Database Patch Set Update : 11.2.0.3.8 (16902043)" Created on 26 Sep 2013, 22:45:39 hrs PST8PDT Patch 17076717 : applied on Tue Oct 29 17:55:51 GMT-03:00 2013 Unique Patch ID: 16788431 Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.8 (HAS Components)" Created on 11 Oct 2013, 08:43:06 hrs UTC Rac system comprising of multiple nodes Local node = t4-rac1 Remote node = t4-rac2 Máquina após reiniciar last pid: 27371; load avg: 2.45, 2.41, 2.25; up 0+00:46:54 09:31:39 407 processes: 402 sleeping, 5 on cpu CPU states: 96.6% idle, 2.4% user, 0.9% kernel, 0.0% iowait, 0.0% swap Kernel: 27662 ctxsw, 22187 trap, 41650 intr, 42282 syscall, 320 flt Memory: 32G phys mem, 5849M free mem, 32G total swap, 32G free swap Máquina depois de 16 dias load averages: 4.01, 4.03, 4.14; up 16+17:59:12 07:16:39 390 processes: 385 sleeping, 5 on cpu CPU states: 93.9% idle, 4.3% user, 1.7% kernel, 0.0% iowait, 0.0% swap Kernel: 21231 ctxsw, 13670 trap, 21134 intr, 32224 syscall, 713 flt, 32 pgin Memory: 32G phys mem, 1171M free mem, 32G total swap, 28G free swap aparentemente este processo vai consumindo cada vez mais memória 2982 root 11 100 -20 6497M 1188M sleep 770:15 0.05% osysmond.bin chegando a 500MB livres o sistema operacional (Solaris) fica sem memória e preciso reiniciar o banco de dados.