Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Process Resource Manager (PRM) on HP UNIX

Re: Process Resource Manager (PRM) on HP UNIX

From: <>
Date: Sun, 14 Oct 2007 04:44:51 -0700
Message-ID: <>

On Oct 14, 6:27 am, wrote:
> On Sat, 13 Oct 2007 12:01:40 -0700, wrote:
> >HP UNIX 11.11 or higher. Oracle 10.1 or higher.
> >My company will be consolidating many oracle database instances from
> >different servers
> >into one large HP UNIX server. We are not allowed to use vPAR/NPAR. I
> >want to use HP UNIX's Process Resource Manager to disttribure
> >resources (CPU, memory, disk i/o bandwidth..); i.e, Oracle instance 1
> >(db1) cannot use more than 25% of CPU during peak times, so one or
> >more instances do not hog all the resources.
> >I did not find any thing on metalink regarding PRM, but the tool
> >appears very good because it lets one use as much resources one want
> >if other instances are not using, however, if other instances need
> >those resources, it will free them, so a instance can not use more
> >than its assigned resources (e.g., 25% CPU) during peak time.
> >Does any one have experience using PRM, whether it has any side
> >effects. Any pointers will be helpful.
> Oracle has RAC and a product called Database Vault for this purpose.
> So, as they have never recommended fiddling around with process
> priorities, they likely won't support PRM. That is probably the exact
> reason why you can't find anything about PRM.
> Also, Oracle has it's own Resource Manager in the database.
> All in all, it looks like you are not going to use PRM, but you are
> just embarking on a project called 'Pennywise and Pound Foolish', and
> your customers will observe a serious performance hit, and you are
> constantly trying to hack yourself out, in order to conform to the
> stupid decisions of the bean counters usually called 'managers'
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
> - Show quoted text -

In server consolidation, RAC will also be used for high availability/ load balancing. There will be two servers and databases can be set using RAC.

Oracle Resource Manager works within a database instance, however, PRM woks across database instances. Most of the packages applications have only one database user, so Oracle Resource Manager cannot be used. Each packaged application will be in its own database instance, so database can be shutdown/restarted independently.

HP UNIX PRM is not based on UNIX process priority instead based on UNIX users.groups/applications. It modifies standard UNIX scheduler (so to speak) to resource partition CPU, memory, disk i/o usage etc.

Unfortunately, bean counters rule the corporations. Received on Sun Oct 14 2007 - 06:44:51 CDT

Original text of this message