basic PRM /WLM question about assigning priority

[Dan Copeland]

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

[Tom Geudens]

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

[Michael Tully]

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

[T G Manikandan · Accepted solution]

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

[Dan Copeland]

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

[T G Manikandan]

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

[Jonathan Fears]

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.