Bom dia amigos...meu banco travou..ficou tudo preso..tive que reiniciar o banco...uma M...
Resultado do Alert.log Fri Apr 24 10:12:49 2009 kkjcre1p: unable to spawn jobq slave process PMON failed to acquire latch, see PMON dump Fri Apr 24 10:14:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:15:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:16:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:17:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:18:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:19:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:20:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:21:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:22:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:23:48 2009 PMON failed to acquire latch, see PMON dump Fri Apr 24 10:24:48 2009 PMON failed to acquire latch, see PMON dump Aumentei a memoria RAM do servidor, desabilitei o gerenciamento automatico da SGA...pelo que pesquisei inicialmente, este problema pode estar relacionado as configurações de Kernell. Algum parametro mal ajustado.. Seria isso mesmo ? Temos o seguinte cenário: tenho 32 GB de memória. Separei 24 GB para a SGA. Destes 24 24GB, tenho o seguinte cenário: 10421 GB para Shared pool 92102 GB para o Buffer chache E o restante para o Java Pool, Large Pool e demais processos. Alguem poderia me ajudar ?