The CREATE PROFILE Command Syntax
UNLIMITED Indicates that a user assigned this profile can use an unlimited amount of this resource DEFAULT Indicates this profile is subject to the limit for this resource, as specified in the DEFAULT profile The CREATE PROFILE Command Syntax
COMPOSIT_LIMIT Limits the total resource cost for a session expressed in service units; database calculates that resource cost as a sum of : •CPU_PER_SESSION •CONNECT_TIME •LOGICAL_READS_PER_SESSION •PRIVATE_SGA The data dictionary view RESOURCE_COST provides resource limits assigned to different resources. The CREATE PROFILE Command Syntax
Managing Resources Using the Database Resource Manager •Provides the database server with more control over resource management decisions •Elements of the Database Resource Manager •Resource consumer group •Resource plan •Resource allocation method •Resource plan directives •DBMS_RESOURCE_MANAGER package is used to create and maintain elements •Requires ADMINISTER_RESOURCE_MANAGER privilege
The goal of the Database Resource Manager is to give the database server more control over resource management decisions, thus circumventing problems resulting from inefficient operating system management. Managing Resource Using Database Resource Manager
Elements of the Database Resource Manager Resource consumer group •Groups of users, or sessions, grouped together based on resource processing requirements. Resource plan •Contains directives that specify how resources are allocated to resource consumer groups. Resource allocation method •The method or policy used by the Database Resource Manager when allocating for a particular resource. Resource plan directive •Used by administrators to associate resource consumer groups with particular plans and allocate resources among resource consumer groups. Managing Resource Using Database Resource Manager
Administering the Database Resource Manager •You must have the system privilege ADMINISTER_RESOURCE_MANAGER to administer the Database Resource Manager (DBMS_RESOURCE_MANAGER). •Typically, DBAs will have this privilege with ADMIN option as part of the DBA role. Managing Resource Using Database Resource Manager
Managing Resources Using the Database Resource Manager •Resource plans specify the resource consumer groups belonging to the plan. •Resource plans contain directives for how resources are to be allocated among consumer groups.
Resource Plan Directives The Database Resource Manager provides several means of allocating resources. •CPU Method •Active Session Pool and Queuing •Degree of Parallelism Limit •Automatic Consumer Group Switching •Maximum Estimated Execution Time •Undo Pool
CPU Methods •Allows you to specify how CPU resources are to be allocated among consumer groups. Active Session Pool with Queuing •You can control the maximum number of concurrently active sessions allowed within a consumer group. •This maximum designates the active session pool.
Want to read all 110 pages?
You've reached the end of your free preview.
Want to read all 110 pages?
- Spring '15
- Foreign key, database server, Constraint