Datebase System Slow performance. (Oracle 11g R2)..

[Kannandgl_1]

Greetings ,

I hoping to get some ideas as to how I might go about fixing this problem that I think I have. I have a rx6600 server w 4 1.6Ghz cpus and I'm having some slow  performance (like its saying always 50 to 60 % CPU utilization )issues. . What do I need to look at to see why my system is  slow.

In my server each every oracle instant its take 19659M.. (Database version is Oracle 11g R2 ans Service Guard 2 node Cluster..)

Pri-Server : 32 GB Physical Memory and 8 CPU.

Scon-Server:16 GB Physical Memory and 4 CPU.

CPU TTY  PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND

14   ?  1866 root     152 20 44224K  2820K run      0:28  2.79  2.79 cimprovagt

10   ?  2391 root     168 20 15612K  1164K sleep    0:03  0.27  0.27 utild

12   ?  9186 oracle   154 20 19659M  9928K sleep    0:02  0.18  0.18 oracleewagdb

 2   ?  9246 oracle   154 20 19656M  7928K sleep    0:00  0.60  0.18 ora_j000_ewagdb

 8   ?  7640 oracle   154 20 19665M 12424K sleep    0:13  0.14  0.14 oracleewagdb

12   ?  9211 oracle   154 20 19659M 10184K sleep    0:01  0.13  0.13 oracleewagdb

 4   ?  2627 oracle   154 20 19658M  9900K sleep    0:03  0.12  0.12 ora_dia0_ewagdb

 4   ?  9248 oracle   154 20 19656M  7340K sleep    0:00  0.35  0.10 ora_j001_ewagdb

 6   ?  2641 oracle   154 20 19661M 12696K sleep    0:03  0.10  0.10 ora_mmon_ewagdb

 4   ?  9236 oracle   154 20 19658M  9208K sleep    0:00  0.08  0.08 oracleewagdb

14   ?  1527 root     154 20 11160K  1284K sleep    0:01  0.07  0.07 sendmail:

 2   ?     2 root     128 20    72K    64K sleep    0:00  0.05  0.04 vhand

 6   ?  2635 oracle   154 20 19656M  7660K sleep    0:00  0.02  0.02 ora_ckpt_ewagdb

If any one give the best  advice , because system its very  critical sutivation ....

Regards

Rajamani

[Dennis Handly]

What version of HP-UX do you have?

Do you have Glance installed?

[Kannandgl_1]

Dear,

HP unix 11.31 and  Oracle DB 11g R2..

Regards

Rajamani..

[Jean-Luc Oudart]

Hi

These processes are from same instance. An instance is a set of memory and processes.

you can check oracle concepts  : http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm#i12483 

You should also provide more information regarding your system being slow :

  - is this new ? if so, what has changed ?
  - are symptoms at server level ? database level ?

  - do you have database monitoring in place ? (perfstat if nothing else)

and more important would you have a baseline (performance) for your server & database.

Regards

Jean-Luc