RE: Limiting CPU percentage usage per user
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Chadi Kassan" <chadi@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 29 Nov 2004 16:37:28 +0100
>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
/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
