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

Other related posts: