Production Database gets Hanged frequently...

Alagu770

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

FrankGordon

Hello,

The server seems under severe pressure.

Do you have any idea what is running when you get these messages? Backups, big reports, copying large files or large data loading for example.

What does your operating system utilization look like sar/top/vmstat?

What is going on in the database at this time AWR/statspack?

Is the SQL in what is going on tuned properly?

Tune the SQL or consider additional hardware.

Did anything change recently?

What operating system, version of database and RAC are you using?

The size of the hardware is not enough information, you need to know whats running and whether you can do anything about the workload.

Regards,

Frank

Alagu770

Hi,

There are no jobs running at that time and looks everything normal in the AWR report analysis. SQL's running was tuned fine. I'm using oracle 11g in sun solaris 10 (grid).

We have recently decreases the core by 10 and later the increased to 13 due the slowness Issue.

Thanks.

Alagu770

https://community.oracle.com/tech/developers/discussion/comment/16837647#Comment_16837647

Hi,

There are no jobs running at that time and looks everything normal in the AWR report analysis. SQL's running was tuned fine. I'm using oracle 11g in sun solaris 10 (grid).

We have recently decreases the core by 10 and later the increased to 13 due the slowness Issue.

Thanks.

FrankGordon

Hello,

What does the operating system statistics say around the time this message occurs?

Do you have access to sar statistics?

Regards,

Frank