Database Process is not working

Hi @ertan.ari ,

The Database processes are tied to the Batch queue configuration. Each batch queue will create database processes according to the process allocation and the execution plan. 

You can start by checking the Batch queue configuration window.

• Check if the batch queue is active and the Execution plan is accurate.
• Then check the corresponding database process and and the logs of the process.  (By default, only the error logs are shown check all logs for complete logs) 

• If the queue is not functioning, make sure there are no background jobs already running for the queue using view background jobs and break/re-activate the queue. 
• If it does not resolve the issue, then you can try to re-initialize the batch queue from init batch queue in the batch queue configuration. This will create a new database process. 

Note:

The parameter in Oracle Server (JOB_QUEUE_PROCESSES in Init.ora) must be increased to get full use of multithreaded batch queues, e.g. this Oracle parameter should not be lower than the total number of processes for all active queues in the system. 

To get the current parameter value: 

Show parameter job_queue_processes;

To Change the value: 

ALTER SYSTEM SET job_queue_processes=11 scope=both;  

Hope this helps!

Thanks,

Kasun