Re: How to install the Database Resource Manager package

You don't need to install it...

Oracle8i comes with a default setup of the Resource Manager elements:

Resource plan

select plan, cpu_method, status from dba_rsrc_plans;

PLAN CPU_METHOD STATUS
-------------- ------------- -------------- SYSTEM_PLAN EMPHASIS ACTIVE SVRMGR> select consumer_group, cpu_method, status,mandatory

 from dba_rsrc_consumer_groups;      2>
CONSUMER_GROUP                 CPU_METHOD                     STATUS  
                      MAN
------------------------------ ------------------------------
------------------------------ ---
OTHER_GROUPS                   ROUND-ROBIN                    ACTIVE  
                      YES
DEFAULT_CONSUMER_GROUP         ROUND-ROBIN                    ACTIVE  
                      YES
SYS_GROUP                      ROUND-ROBIN                    ACTIVE  
                      NO
LOW_GROUP                      ROUND-ROBIN                    ACTIVE  
                      NO

Here is a general guideline of the steps in implementing a Database Resource Manager plan:

1. Create resource plans
2. Create resource consumer groups
3. Create resource plan directives
4. Grant switch privilege for resource consumer groups to users or roles
5. Assign users to resource consumer groups
6. Specify a plan to be used by the instance

"Michael Lai" <michael_lwt_at_sympatico.ca> wrote in message news:<sHvAa.1671$ik4.206043_at_news20.bellglobal.com>...
> Hi all,
>
> how to install the Database Resource Manager package
>
> regards,
>
> Michael
Received on Tue May 27 2003 - 08:23:31 CEST