RE: Limiting CPU percentage usage per user

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 29 Nov 2004 16:37:28 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A01E6AC82@MSXVS02.trivadis.com>

>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:33:33 CST