RE: Limiting CPU percentage usage per user

From: Chadi Kassan <chadi_at_myvirtualmodel.com>
Date: Mon, 29 Nov 2004 10:44:12 -0500
Message-ID: <2C605DDCFE30504F82EB1DE0A5EB981E1175B7@ntexccrp01.mvm.com>

this is with database resource manager. I have already done this but, = at the
end, when I try to activate the plan, it says feature not enabled, = because
I'm not running EE I guess, so I get back to the profile. so can this = be
acheived using the profile...

Chadi

-----Original Message-----
From: Christian Antognini [mailto:Christian.Antognini_at_trivadis.com] Sent: Monday, November 29, 2004 10:37 AM To: Chadi Kassan
Cc: ORACLE-L (E-mail)
Subject: RE: Limiting CPU percentage usage per user

>thanks for your reply, but would please tell me how to do this (point = 2) :)

Sorry, I didn't read carefully your first post :-(

The following scripts (that was written for 8i... therefore I hope that = it
runs successfully on 10g...) should do that for two groups.

connect system/manager

begin
 dbms_resource_manager.create_pending_area; end;
/

BEGIN
 DBMS_RESOURCE_MANAGER.CREATE_PLAN(
   PLAN =3D> 'TAGES_PLAN',
   COMMENT =3D> '=DCbliche Arbeitstage'); END;
/

BEGIN
 DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(   CONSUMER_GROUP =3D> 'GROUP_ONLINE',
  COMMENT =3D> 'Online User');
 DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(   CONSUMER_GROUP =3D> 'GROUP_BATCH',
  COMMENT =3D> 'Batch User');
END;
/

BEGIN
 DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(

  PLAN             =3D> 'TAGES_PLAN',
  GROUP_OR_SUBPLAN =3D> 'GROUP_ONLINE',
  COMMENT          =3D> 'Tages Direktive, online User',
  CPU_P1           =3D> 80,
  CPU_P2           =3D> 0);
 DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN             =3D> 'TAGES_PLAN',
  GROUP_OR_SUBPLAN =3D> 'GROUP_BATCH',
  COMMENT          =3D> 'Tages Direktive, batch User',
  CPU_P1           =3D> 10,
  CPU_P2           =3D> 0);
 DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN             =3D> 'TAGES_PLAN',
  GROUP_OR_SUBPLAN =3D> 'OTHER_GROUPS',
  COMMENT          =3D> 'Tages Direktive, andere',
  CPU_P1           =3D> 10,
  CPU_P2           =3D> 0);

END;
/

BEGIN
 DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA(); END;
/

BEGIN
 DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA(); END;
/

BEGIN
 DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(

  GRANTEE_NAME   =3D> 'SCOTT',
  CONSUMER_GROUP =3D> 'GROUP_BATCH',
  GRANT_OPTION   =3D> FALSE);

END;
/

BEGIN
 DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(

  GRANTEE_NAME   =3D> 'SCOTT',
  CONSUMER_GROUP =3D> 'GROUP_ONLINE',
  GRANT_OPTION   =3D> FALSE);

END;
/

BEGIN
 DBMS_RESOURCE_MANAGER.SET_INITIAL_CONSUMER_GROUP(   USER =3D> 'SCOTT',
  CONSUMER_GROUP =3D> 'GROUP_BATCH');
END;
/

ALTER SYSTEM SET RESOURCE_MANAGER_PLAN =3D TAGES_PLAN
/

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 29 2004 - 09:41:35 CST