EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Creating/editing resource plan


Use the Resource Plan tab of Resource Plan Editor to create/edit a resource plan and specify its properties.

 

Name

Specify the name of the resource plan to be created, or view the name of the resource plan being edited.

 

Resource Plan Editor - Editing Resource Plan definition

 

CPU method

Use this box to view the resource allocation method for specifying how much CPU each consumer group or sub plan gets:

EMPHASIS (the default method, for multilevel plans that use percentages to specify how CPU is distributed among consumer groups);

RATIO (for single-level plans that use ratios to specify how CPU is distributed).

 

Active session pool

Use this box to view the active session pool resource allocation method which limits the number of active sessions. All other sessions are inactive and wait in a queue to be activated. ACTIVE_SESS_POOL_ABSOLUTE used by default is the only available method.

 

Parallel degree

Use this box to view the resource allocation method for specifying a limit on the degree of parallelism of any operation. PARALLEL_DEGREE_LIMIT_ABSOLUTE used by default is the only available method.

 

Queueing

Use this box to view the queuing resource allocation method which controls the order in which queued inactive sessions will execute. FIFO_TIMEOUT used by default is the only available method.

 

CheckBox Active

Select this option to activate the resource plan immediately after compiling.

 

CheckBox Mandatory

Indicates whether the resource plan being edited is mandatory or not.

 

 

Available groups and subplans

This area allows you to select existing consumer groups and resource plans as subplans for resource plan being created/edited.

 

To select a group/subplan, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the objects from one list to another.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.