Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 145 of 211


V$RESOURCE_LIMIT

This view displays information about global resource use for some of the system resources. Use this view to monitor the consumption of resources so that you can take corrective action, if necessary. Many of the resources correspond to initialization parameters listed in Table 3-2.

Some resources, those used by DLM for example, have an initial allocation (soft limit), and the hard limit, which is theoretically infinite (although in practice it is limited by SGA size). During SGA reservation/initialization, a place is reserved in SGA for the INITIAL_ALLOCATION of resources, but if this allocation is exceeded, additional resources are allocated up to the value indicated by LIMIT_VALUE. The CURRENT_UTILIZATION column indicates whether the initial allocation has been exceeded. When the initial allocation value is exceeded, the additional required resources are allocated from the shared pool, where they must compete for space with other resources.

A good choice for the value of INITIAL_ALLOCATION will avoid the contention for space. For most resources, the value for INITIAL_ALLOCATION is the same as the LIMIT_VALUE. Exceeding LIMIT_VALUE results in an error.

Column  Datatype  Description 

RESOURCE_NAME 

VARCHAR2(30) 

Name of the resource (see Table 3-2

CURRENT_UTILIZATION 

NUMBER 

Number of (resources, locks, or processes) currently being used 

MAX_UTILIZATION 

NUMBER 

Maximum consumption of this resource since the last instance start-up 

INITIAL_ALLOCATION 

VARCHAR2(10) 

Initial allocation. This will be equal to the value specified for the resource in the initialization parameter file (UNLIMITED for infinite allocation). 

LIMIT_VALUE 

VARCHAR2(10) 

Unlimited for resources and locks. This can be greater than the initial allocation value (UNLIMITED for infinite limit). 

Table 3-2  Values for RESOURCE_NAME column
Resource Name  Corresponds to this Initialization Parameter 

DISTRIBUTED_TRANSACTIONS 

See "DISTRIBUTED_TRANSACTIONS" 

DML_LOCKS 

See "DML_LOCKS" 

ENQUEUE_LOCKS 

This value is computed by Oracle. Use the V$ENQUEUE_LOCK view (described on ) to obtain more information about the enqueue locks. 

ENQUEUE_RESOURCES 

See "ENQUEUE_RESOURCES" 

LM_PROCESSES 

Lock manager processes 

LM_LOCKS 

See "LOCAL_LISTENER" 

MTS_MAX_SERVERS 

See "MTS_MAX_SERVERS" 

PARALLEL_SLAVES 

See "PARALLEL_MAX_SERVERS" 

PROCESSES 

See "PROCESSES" 

ROLLBACK_SEGMENTS 

See "MAX_ROLLBACK_SEGMENTS" 

SESSIONS 

See "SESSIONS" 

SORT_SEGMENT_LOCKS 

This value is computed by Oracle 

TEMPORARY_LOCKS 

This value is computed by Oracle 

TRANSACTIONS 

See "TRANSACTIONS" 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback