General
cancel
Showing results for 
Search instead for 
Did you mean: 

Total OS Memory and CPU Utilisation by database

S1_1
Occasional Visitor

Total OS Memory and CPU Utilisation by database

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?
5 REPLIES
Dennis Handly
Acclaimed Contributor

Re: Total OS Memory and CPU Utilisation by database

>pick hrs

What are those? Peak hours?
Bill Hassell
Honored Contributor

Re: Total OS Memory and CPU Utilisation by database

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.


Bill Hassell, sysadmin
Emil Velez
Honored Contributor

Re: Total OS Memory and CPU Utilisation by database


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
Honored Contributor

Re: Total OS Memory and CPU Utilisation by database

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
Support Fatherhood - Stop Family Law
S1_1
Occasional Visitor

Re: Total OS Memory and CPU Utilisation by database

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