DBServer CPU Utilization time is 90-98% during peak hours

[Former Member]

Dear friends,

How to monitor the runnign Oracle Process / sql scripts / Oracle - SAP jobs that are consunoing Max. resources ( CPU time, DB response time ) and how to tune them ON UNIX- Oracle environment

Thank u.

[Former Member]

Hi Siva

A high CPU load isn't a bad thing at all, this only means you are using your hardware ressources at its best ))

But to answer your question. Just check the process id of your top running oracle processes. For example with the command top:

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

1 ? 28246 oraSID 154 20 2252M 6828K sleep 1:07 98.08 1.08 oracleSID

1 ? 2092 root -16 20 33512K 10200K run 460:24 1.22 1.21 midaemon

1 ? 171 patrol 154 20 16696K 7708K sleep 69:24 1.08 1.08 bgscollect[/code]

If you have the pid (here 28246) then goto transaction ST04 -> Detailed analysis menu -> Oracle session (for NW7.0 you can use DB02 as well):

[code]SID ORA PID Client system Client PID Status Event User SQL Statement

69 28246 localhost 28244 ACTIVE SQL*Net message to client SAPR3 SELECT FROM V$SESSION T1, V$PROCESS T2, V$SESSION_WAIT T3, V[/code]

You can see the ORA PID 28246, the client pid is the sap work process and the sql it is executing. Also the event might be helpful.

Best regards, Michael

[Former Member]

HI,

check sap note 712624

regards,

kaushal