Saturday, 28 December 2013

kkjcre1p: unable to spawn jobq slave process,TNS-12514,TNS-12523,TNS-12502,TNS-12520,TNS-12528

This problem occurred due to resource allocation on the db side .

Here is the solution approach :-

1.check the kernel parameter and see if it configured at optimum level.
2.Check the swap space and their usage and re-config them if it is needed .
3.It may be your JOB_QUEUE_PROCESSES is too low comparison to processes parameter , increase it upto  
  32 and decrease the  processes parameter upto 800 for now .
4.Check the session,transaction and process parameter and tune the session and process parameter.
5.monitor the PROCESSES usage at the database level using the V$RESOURCE_LIMIT view and increase it if is
   needed .

No comments:

Post a Comment