ALTER RESOURCE COST
ALTER RESOURCE COST [CPU_PER_SESSIONweight
] [CONNECT_TIMEweight
] [LOGICAL_READS_PER_SESSIONweight
] [PRIVATE_SGAweight
]
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.
The amount of CPU time (in hundredths of a second) used in a session.
The number of database blocks read in a session, including those read from memory and disk.
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.
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.