system performance

[Viney Kumar]

Hi All

What is the best way to check the system performance.

and which things need to be check in heigh memory and cpu utilization cases......

thanks

viney

[Ganesan R]

Hi Viney,

There are many tools available. Glance plus is one of the best product if you have.

You can also use top, sar, vmstat, iostat, netstat, swapinfo commands as well to know the resource utilisation.

[TTr]

GlancePlus is the best tool to use. It is optional software but comes with the EOE OS. Without glance you can use top, vmstat, sar.

[Flounder McLovin]

GlancePlus would be a good one to use!!

https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-15-28^9637_4000_100__


HTH
"Flounder"

[Viney Kumar]

is it similar to OVO and HP site scope

in vmstat, wht is thing need to be checked

[Dennis Handly]

>is it similar to OVO and HP sitescope

glance probably gives more details.

[Viney Kumar]

Hi All,

Actually i have ia64 hp server rx3600 server and its cpu utilization is 98 % and memory utilization is 96 % but in system no major process is going on..........

and sar output is:--
17:50:15 %usr %sys %wio %idle
17:50:17 32 65 0 3
17:50:19 32 62 0 5
17:50:21 31 66 0 4
17:50:23 26 71 0 3
17:50:25 29 69 0 2

Average 30 67 0 3

give some suggestion. i don't have glance like software

[Ganesan R]

Hi Viney,

Use top command to see which procoess consumes more cpu cycles..

[Viney Kumar]

Hi

in top also

CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
1 ? 27525 oracle 154 20 1258M 7272K sleep 0:23 4.51 4.50 ora_j001_pcard
1 ? 14827 oracle 154 20 1257M 7640K sleep 0:33 4.49 4.49 ora_j000_pcard
1 ? 14270 oracle 191 20 1258M 7556K run 0:04 4.53 4.39 ora_j004_pcard
it is show only 4.51,4.49,4.53 % of cpu utilization only......

[Jaime Bolanos Rojas.]

viney,

If you have a support contract with HP, you should be able to see this document:

http://www11.itrc.hp.com/service/cki/docDisplay.do?docLocale=en&docId=emr_na-c00958823-12

It gives you all the basics that you need to understand the free basic tools used to troubleshoot performance issues.

Regards,

Jaime.

[Viney Kumar]

Hi Jaime

i unable to open it


viney

[Viney Kumar]

there any other option

[TTr]

> it is show only 4.51,4.49,4.53 % of cpu utilization only

That's for each process. If you add up all the processes you may end up with the 98% utilization. Same for memory.

Having high CPU and memory utilization does not mean there is something wrong. It may be normal for your oracle environment. How much total memory do you have and how many CPUs?
Look further into the top listing, unless you find a single process that unjustifyingly is using a lot of CPU and memory, there is nothing wrong. You may need to add resources to your server.
Another thing to look into is cleanup andy unecesssry processes that may be running on your server. But that's another topic...

[Viney Kumar]

Hi TTr

I have 2 processor and 4 GB RAM


Viney

[TTr]

In general 4GB memory is not enough for an oracle server these days. Same for the 2 CPUs if this is one dual core CPU. You should look in detail in the top output and "ps -ef" listing to see if there are any oracle processes that can be cleaned up or any OS services that can be stopped to conserve CPU and memory resources. Otherwise you need to add CPU and memory.

[Viney Kumar]

Thanks TTr for your valuable suggestions