USER MANUALS

Resource Manager

In an environment with multiple concurrent user sessions that run queries, not all user sessions have the same importance. You may want to give more priority to queries executed by transactional applications, which need an immediate response, than to queries executed to generate a daily report.

The Resource Manager allows you to classify sessions into groups based on the attributes of the session, and to allocate resources to those groups in a way that optimizes resources utilization for your application environment.

We recommend managing the Resource Manager from the administration tool.

The section Resource Manager of the Administration Guide explains how the resource manager works and how to use it from the administration tool. This section only lists the VQL commands related to the management of the plans and rules of the resource manager.

Managing the Plans of the Resource Manager

This section shows the syntax of the commands to create, modify and delete plans of the resource manager.

Syntax of the CREATE RESOURCE_MANAGER PLAN statement
CREATE [ OR REPLACE ] RESOURCE_MANAGER PLAN <name:identifier>
    [ DESCRIPTION = <description:literal> ]
    CONDITION <condition>
    ACTION <literal> [ PARAMETERS ( <parameters> ) ]*
    [ ACTION <literal> [ PARAMETERS ( <parameters> ) ]* ]*
    [ CONDITION <condition>
      ACTION <literal> [ PARAMETERS ( <parameters> ) ]*
      [ ACTION <literal> [ PARAMETERS ( <parameters> ) ]* ]*
    ]*

<parameters> ::= <param name:literal> = <value> [, <param name:literal>
= <value> ]

<condition> ::= (see Rules for forming functions)

<identifier> ::= (see Basic elements of VQL statements)

<literal> ::= (see Basic elements of VQL statements)

<value> ::= (see Rules for forming functions)

Syntax of the ALTER RESOURCE_MANAGER PLAN statement
ALTER RESOURCE_MANAGER PLAN <name:identifier>
    [ RENAME <name:identifier> ]
    [ DESCRIPTION = <description:literal> ]
    [ CONDITION <condition>
      { ACTION <literal> [ PARAMETERS ( <parameters> ) ]* }+
    ]*

To list the existing plans, run LIST RESOURCE_MANAGER PLANS.

To drop a plan, execute DROP RESOURCE_MANAGER PLAN:

Syntax of the DROP RESOURCE_MANAGER PLAN statement
DROP RESOURCE_MANAGER PLAN [ IF EXISTS ] <name:identifier> [ CASCADE ]

You cannot delete a plan if it has rules associated to it, unless you add the CASCADE clause. With the CASCADE clause, you will delete the plan and the rules associated to it.

Managing the Rules of the Resource Manager

This section shows the syntax of the commands to create, modify and delete rules of the resource manager.

Syntax of the CREATE RESOURCE_MANAGER RULE statement
CREATE [ OR REPLACE ] RESOURCE_MANAGER RULE <name:identifier>
    [ DESCRIPTION = <description:literal> ]
    CONDITION <condition>
    RESOURCE_MANAGER PLAN <name:identifier>

<condition> ::= (see Rules for forming functions)

<identifier> ::= (see Basic elements of VQL statements)

Syntax of the ALTER RESOURCE_MANAGER RULE statement
ALTER RESOURCE_MANAGER RULE <name:identifier>
    [ RENAME <new_name:identifier> ]
    [ DESCRIPTION = <description:literal> ]
    [ CONDITION <condition> ]
    [ RESOURCE_MANAGER PLAN <name:identifier> ]

To list the existing rules, run LIST RESOURCE_MANAGER RULES.

To drop a plan, execute DROP RESOURCE_MANAGER RULE:

Syntax of the DROP RESOURCE_MANAGER RULE statement
DROP RESOURCE_MANAGER RULE [ IF EXISTS ] <name:identifier>
Add feedback