Forum Stats

  • 3,838,561 Users
  • 2,262,383 Discussions
  • 7,900,687 Comments

Discussions

Production Database gets Hanged frequently...

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

Answers

  • FrankGordon
    FrankGordon Member Posts: 45 Blue Ribbon

    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

    User_8NI5D
  • User_8NI5D
    User_8NI5D Member Posts: 4 Green Ribbon

    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.

  • User_8NI5D
    User_8NI5D Member Posts: 4 Green Ribbon

    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
    FrankGordon Member Posts: 45 Blue Ribbon

    Hello,

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

    Do you have access to sar statistics?

    Regards,

    Frank