Process Resource Manager (PRM)

[James Hicks]

I've been tasked with configuring PRM to run on a N-class with 3 Oracle 7.3.4 databases. From the documentation I've read, it doesn't seem too difficult to accomplish. I'm just wondering if anyone has done this before and if there are any "gotchas" I should keep a look out for? Such as, monitoring the Listener, disk, memory and CPU capping.

Any assistance would be greatly appreciated.
Thanks in advance

____________________________
- James Hicks
Hewlett Packard Consulting

[Albert E. Whale, CISSP]

James,

I cannot say that I've ever used the PRM before, however I highly recommend monitoring for excessive CPU processes. Too many times I've witnessed disconnected processes in a run-away state.

My favorite methodology for runaway process detection is to determine the process time spent by the job, if it exceeds 100 minutes, and it is not owned by a system level owner (e.g. root, bin, oracle ....) then test for an attached terminal. If it is detached, then its probably defunct, and you may kill it.

It sounds like you'll need that as well, especially monitoring three Oracle Databases on an N Class Server.

Hope that helps!

[Jim Welch]

You should probably read:
"Using HP PRM with Oracle Databases"
http://docs.hp.com/hpux/content/prmoracle.pdf