RE: Limiting CPU percentage usage per user

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@xxxxxxxxxxxx]
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

Other related posts: