Creating and Activating Resource Groups for Batch Validation

You can use the Oracle database Resource Group feature to limit the percentage of CPU capacity used by Batch Validation when other processes—such as RDC data entry—with a higher priority need the resources. See the Oracle® Database Administrator's Guide 11g for details.

Use the following steps as an example of how to create and activate the resource group:

1. Log in as SYS or SYSDBA to the back end to grant privileges to RXC for the dbms_resource_manager package:

   EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE -
     (GRANTEE_NAME => 'rxc', PRIVILEGE_NAME =>
     'ADMINISTER_RESOURCE_MANAGER', -
     ADMIN_OPTION => FALSE);
   

2. Log in as RXC to the back end and create the resource plan and resource groups:

   BEGIN
   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN(SIMPLE_PLAN => 'test_group',
   CONSUMER_GROUP1 => 'test_group1', GROUP1_CPU => 80,
   CONSUMER_GROUP2 => 'test_group2', GROUP2_CPU => 20);
   END;
   

3. As RXC, grant switching privileges to the RXCLIN_MOD role. This role is assigned to every user who runs batch validation where switching of resource groups takes place.

   EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP ('rxclin_mod', -'test_group1', FALSE);
   

4. Log in to Oracle Clinical, navigate to Admin, then Reference Codelists, then Local Reference Codelists, and query for OCL_STATE.

   Add a new short value BV_RESOURCE_GRP with the resource group name as the long value and save.

5. Log in to the back end as either SYS or SYSTEM and make the resource plan active:

   ALTER SYSTEM SET RESOURCE_MANAGER_PLAN ='test_group';