Total OS Memory and CPU Utilisation by database

[S1_1]

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?

[Dennis Handly]

>pick hrs

What are those? Peak hours?

[Bill Hassell]

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.

[Emil Velez]

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.

[Michael Steele_2]

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

[S1_1]

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