Database Administration (MOSC)

MOSC Banner

Database goes to hung state

edited Dec 5, 2012 11:28PM in Database Administration (MOSC) 5 commentsAnswered
Hi All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center