The CREATE PROFILE Command Syntax UNLIMITED Indicates that a user assigned this

The create profile command syntax unlimited indicates

This preview shows page 95 - 105 out of 110 pages.

The CREATE PROFILE Command Syntax
Background image
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
Background image
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
Background image
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
Background image
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
Background image
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
Background image
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
Background image
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.
Background image
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
Background image
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.
Background image

Want to read all 110 pages?

Image of page 105

Want to read all 110 pages?

You've reached the end of your free preview.

Want to read all 110 pages?

  • Spring '15
  • dawan
  • Foreign key, database server, Constraint

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes