Name

ALTER RESOURCE COST

Synopsis

ALTER RESOURCE COST
   [CPU_PER_SESSION weight]
   [CONNECT_TIME weight]
   [LOGICAL_READS_PER_SESSION weight]
   [PRIVATE_SGA weight]

Modifies the formula used to calculate the total resource cost used in a session, which is then limited by the COMPOSITE_LIMIT parameter in a profile. For each resource, weight represents the integer weight of the resource.

Keywords

CPU_PER_SESSION

The amount of CPU time (in hundredths of a second) used in a session.

CONNECT_TIME

The total elapsed time (in minutes) for a session.

LOGICAL_READS_PER_SESSION

The number of database blocks read in a session, including those read from memory and disk.

PRIVATE_SGA

The amount of memory (in bytes) a session can allocate in the shared pool of the SGA. This only applies when using the Multi-Threaded Server and allocating private space in the SGA for the session.

Notes

The total resource cost is calculated by multiplying the amount of each resource used in the session by the weight assigned to that resource and adding together the products for all four resources. The result is expressed in service units. You must have the ALTER RESOURCE COST privilege to issue this command.

Example

The following example assigns weights to CPU_PER_SESSION and CONNECT_TIME:

ALTER RESOURCE COST
     CPU_PER_SESSION 100
     CONNECT_TIME 2

The resulting cost in service units is calculated as:

SU = (CPU_PER_SESSION × 100) + CONNECT_TIME × 2
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.149.231.128