topic Re: Total OS Memory and CPU Utilisation by database in Operating System - HP-UX

Total OS Memory and CPU Utilisation by database

S1_1 — Sun, 01 Nov 2009 21:06:46 GMT

Hi
We have hosted multiple Databases instance on a sigle server. I want to identify the exact of amount of OS Memory and CPU used by each database in pick hrs and in non pick hrs. Is there any script to check this from database?

Re: Total OS Memory and CPU Utilisation by database

Dennis Handly — Sun, 01 Nov 2009 22:21:35 GMT

>pick hrs

What are those? Peak hours?

Re: Total OS Memory and CPU Utilisation by database

Bill Hassell — Sun, 01 Nov 2009 23:31:51 GMT

It isn't possible to answer your question without more information. The most important pieces of information are:

1. Version of HP-UX you are running
2. What databases are you running? Are you running different databases such as Informix, Sybase, Oracle, MySql...?

Each database has it's own measurement tools so you'll have to talk to your database administrator about memory usage. Most database systems use shared memory so you'll need the numbers from the database itself. CPU usage is also complex since a database may be part of a number of applications which also consume CPU time.

Re: Total OS Memory and CPU Utilisation by database

Emil Velez — Mon, 02 Nov 2009 00:07:04 GMT

Easy

1. Setup application groups in the /var/opt/perf/parm file where you define what processes belong to each application group (database instance).

2. Verify in glance that the application groupings are grouping processes correctly

3. Restarte OVPA (measureware)

4. extract the data from measureware

extract -xp -aA -f /tmp/apps.txt

review the data. or you can view the data with Performance manager.

The metrics will show each group of processes and how much CPU, memory, I/O network and other metrics per aggregated group of processes assuming you created your groups correctly.

Re: Total OS Memory and CPU Utilisation by database

Michael Steele_2 — Mon, 02 Nov 2009 03:35:29 GMT

HI

Refer to 'ps' man pages

UNIX95=1 ps -ef -o pcpu,pid,ppid,comm | sort -rn | more

UNIX95 ps -ef -o vmz,pid,ppid,com | sort -rn | more

Re: Total OS Memory and CPU Utilisation by database

S1_1 — Mon, 02 Nov 2009 15:04:02 GMT

Hi
Below are the server/DB details
HP-UX B.11.11
Oracle Database : 9.2.0.5