Database Tuning (MOSC)

MOSC Banner

process

edited May 16, 2012 3:42AM in Database Tuning (MOSC) 2 comments
Hi everyone,
My database is 10.2.0.5.0 standard edition having 4GB RAM.
yesterday my alert log file showing these messages and my database hang for a moment.

Tue May 15 05:36:40  2012
Process q002 died, see its trace file
Tue May 15 05:37:33  2012
ksvcreate: Process(q002) creation failed
Tue May 15 05:52:38  2012
Process q003 died, see its trace file
Tue May 15 05:52:38  2012
ksvcreate: Process(q003) creation failed
Tue May 15 05:53:48  2012
WARNING: inbound connection timed out (ORA-3136)
Tue May 15 06:00:07  2012
Process J001 died, see its trace file
Tue May 15 06:00:07  2012
kkjcre1p: unable to spawn jobq slave process

my parameters is:

job_queue_processes       integer     10
processes                          integer     150
sessions                             integer     200.

plz help me

Best Regards

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