Hi all,
Eventhough My database configure with,
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 13
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 15
processes integer 7000
processor_group_name string
Still gets Error in alert log as,
ORA-00445: background process "J000" did not start after 120 seconds
Incident details in: /orahome11g/diag/rdbms/mrcdgsiebprod/MRCDGSIEBPROD/incident/incdir_9240541/MRCDGSIEBPROD_cjq0_3429_i9240541.trc
kkjcre1p: unable to spawn jobq slave process
Errors in file /orahome11g/diag/rdbms/mrcdgsiebprod/MRCDGSIEBPROD/trace/MRCDGSIEBPROD_cjq0_3429.trc:
Thu Jun 02 09:57:41 2022
On that particular time DB gets hanged and new connections are not allowed, also server utilization being peaked up and RAM consumption been too high.
DB Size - 4.5TB
RAM - 224GB