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.
