Set up a friendly environment to share my understanding and ideas about Oracle / Oracle Spatial database administration, ESRI ArcSDE Geodatabase administration and UNIX (Solaris) operating system.
V$RESOURCE_LIMIT 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 the following table:
Resource Name
Corresponds to
DML_LOCKS
DML_LOCKS
ENQUEUE_LOCKS
This value is computed by the Oracle Database. See V$ENQUEUE_LOCK to obtain more information about the enqueue locks.
GES_LOCKS
Global Enqueue Service locks
GES_PROCS
Global Enqueue Service processes
GES_RESS
Global Enqueue Service resources
MAX_SHARED_SERVERS
See "MAX_SHARED_SERVERS"
PARALLEL_MAX_SERVERS
See "PARALLEL_MAX_SERVERS"
PROCESSES
See "PROCESSES"
SESSIONS
See "SESSIONS"
SORT_SEGMENT_LOCKS
This value is computed by the Oracle Database
TEMPORARY_LOCKS
This value is computed by the Oracle Database
TRANSACTIONS
See "TRANSACTIONS"
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 the table above)
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).
I reserve the right to delete comments that are not contributing to the overall theme of the BLOG or are insulting or demeaning to anyone. The posts on this BLOG are provided "as is" with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer.