Oracle教程

Oracle 视图 V$RESOURCE_LIMIT 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$RESOURCE_LIMIT是一个动态性能视图，它显示了Oracle的资源使用情况，监控实例下的资源限制，主要显示每个角色在每个资源类别上的使用情况。包括Oracle服务器的内存、CPU、磁盘空间等系统组件的大小和使用情况，以及服务器上每个数据库的使用情况。

使用Oracle视图V$RESOURCE_LIMIT的方法如下：
1. 在SQL*Plus中连接到数据库服务器；
2. 执行SELECT * FROM V$RESOURCE_LIMIT来查看当前的资源使用情况；
3. 根据实际情况，修改V$RESOURCE_LIMIT中的一些值，改变限制；
4. 使用ALTER SYSTEM SET RESOURCE_LIMIT = VALUES来设置限制；
5. 使用ALTER SYSTEM RESET RESOURCE_LIMIT来重置限制；
6. 使用SELECT * FROM V$RESOURCE_LIMIT来检查限制是否已正确设置。

官方英文解释

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 Table 9-5.

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(128)

Name of the resource (see Table 9-5)

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(40)

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(40)

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

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Table 9-5 Values for the RESOURCE_NAME Column

Resource Name Corresponds to

DML_LOCKS

See “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”


数据运维技术 » Oracle 视图 V$RESOURCE_LIMIT 官方解释，作用，如何使用详细说明
分享到：

相关推荐