topic Re: basic PRM /WLM question about assigning priority in Operating System - HP-UX

basic PRM /WLM question about assigning priority

Dan Copeland — Fri, 11 Oct 2002 02:40:14 GMT

Admins,

I've never used prm or wlm but I believe I understand the general concept. My question is whether you can assign priority based process name as seen from ps -ef and also further clarify it w/ astericks (*). For example, if you wanted to give priority to a particular oracle instance running on a box, could you define a priority for *sid_number* as the process name so you would get all the shadow processes as well as db writers and log writers?

tia,
Frank

Re: basic PRM /WLM question about assigning priority

Tom Geudens — Fri, 11 Oct 2002 03:51:53 GMT

Hi Frank,
I'm not 100% clear on what your question is exactly, but the following is an extract from one of my own /etc/prmconf files :
#
#
#
# Group/CPU records
#
BATCH:2:5::
CONTROLM:4:30::
NETBACKUP:3:10::
OTHERS:1:55::
#
# Memory records
#
#
# Application records
#
/oracle1/app/oracle/product/8.0.6/bin/oracle::::OTHERS,oraclepara*
/oracle1/app/oracle/product/8.0.6/bin/oracle::::OTHERS,ora_*_para
/oracle1/app/oracle/product/8.0.6/bin/oracle::::OTHERS,oraclepsfi*
/oracle1/app/oracle/product/8.0.6/bin/oracle::::OTHERS,ora_*_psfi
/oracle1/app/oracle/product/8.0.6/bin/oracle::::CONTROLM,oraclepodbx*
/oracle1/app/oracle/product/8.0.6/bin/oracle::::CONTROLM,ora_*_podbx
...

Is this what you were looking for ?
Regards,
Tom

Re: basic PRM /WLM question about assigning priority

Michael Tully — Fri, 11 Oct 2002 03:52:18 GMT

These on-line manuals should give you what your after.

PRM
http://www.docs.hp.com/hpux/onlinedocs/B8733-90007/B8733-90007.html

WLM
http://www.docs.hp.com/cgi-bin/fsearch/framedisplay?top=/hpux/onlinedocs/B8844-90003/B8844-90003_top.html&con=/hpux/onlinedocs/B8844-90003/00/00/29-con.html&toc=/hpux/onlinedocs/B8844-90003/00/00/29-toc.html&searchterms=WLM&queryid=20021010-225334

Re: basic PRM /WLM question about assigning priority

T G Manikandan — Fri, 11 Oct 2002 04:20:44 GMT

Yes you are right you can assign them as using asterisks

like
ora*

This would allocate the required amount of percentage to the all the oracle database background processes like the dbwriter and the log writer processes.i.e. ora_lgwr and ora_dbw0 process.

check this white paper for the PRM for Oracle database

Attached is the document

Re: basic PRM /WLM question about assigning priority

Dan Copeland — Fri, 11 Oct 2002 04:46:20 GMT

I'm not actually looking to implement--just trying to answer a question for a co-worker.

First off, can you assign priority to process that have a particular process name (i.e COMMAND or 4th column in ps -ef)?

Second, can you state *p680* for a process name so you get all processes that have p680 in their name

Thanks,
Frank

Re: basic PRM /WLM question about assigning priority

T G Manikandan — Fri, 11 Oct 2002 05:04:20 GMT

As above
Answer for first is 'yes'
Answer for second is 'yes'

Re: basic PRM /WLM question about assigning priority

Jonathan Fears — Mon, 14 Oct 2002 14:51:19 GMT

Yes, you can assign priority to processes with a particular name. You can also use pattern matching (*) to match a collection of alternate names to a fully qualified executable (as shown above in the Oracle examples). Pattern matching follows the rules outlined in the regexp(5) man page. For PRM, assigning priority is simply achieved by placing users and apps with a greater need for CPU in a PRM group with higher relative CPU shares. In WLM, for goal-based SLOs (service-level objectives) you actually specify a priority as part of the SLO definition.

The PRM whitepaper mentioned above is a great source of information for PRM and Oracle interaction. HP-UX Workload Manager has a Oracle Database Toolkit (ODBTK) which contains tools that make it easy to use metrics from Oracle database instances as goal values in SLOs. The information library link on www.hp.com/go/wlm (and /go/prm) gives a listing of manuals and whitepapers covering this as well as other topics.