Database goes to hung state
one of our database goes to hung state frequently with the below error.
Process W000 died, see its trace file
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
We found out swap utilization was 100% after adding more swap memory it started working fine.
Though there was physical free memory available it was consuming 100% swap memory.
Hugepage is not enabled in our system.
Please suggest if there is any action that can be taken so it consumes physical memory before using swap memory.
Thanks