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

本站中文解释

V$CPOOL_CC_INFO视图用于查看缓冲池共享池 (cache pool) 的当前状态和信息。

该视图包含了共享池状态指示器(status indicators)和统计(statistics)等相关信息。

V$CPOOL_CC_INFO视图展示以下细节:

CPOOL_NUM — 共享池编号

CPOOL_NAME — 共享池名称

CPOOL_SIZE — 共享池大小,单位是B (bytes)

CPOOL_STATUS — 共享池当前状态

CPOOL_SIZE_USED — 共享池已使用大小,单位是B (bytes)

BYTES_IN — 共享池激活缓冲池的总大小,单位是B (bytes)

BYTES_OUT — 共享池写回缓冲池的总大小,单位是B (bytes)

MAX_BYTES_IN — 共享池中激活缓冲池的最大大小,单位是B (bytes)

AVG_BYTES_IN — 共享池中激活缓冲池的平均大小,单位是B (bytes)

使用V$CPOOL_CC_INFO视图的典型步骤如下:

1.查询共享池的基本信息:

SELECT cpool_num, cpool_name, cpool_size
FROM V$CPOOL_CC_INFO;

2.查看共享池的当前状态:

SELECT cpool_num, cpool_name, cpool_status
FROM V$CPOOL_CC_INFO;

3.查看共享池激活缓冲池的总大小:

SELECT cpool_num, cpool_name, bytes_in
FROM V$CPOOL_CC_INFO;

4.查看共享池写回缓冲池的总大小:

SELECT cpool_num, cpool_name, bytes_out
FROM V$CPOOL_CC_INFO;

5.查询共享池中激活缓冲池的最大和平均大小:

SELECT cpool_num, cpool_name, AVG_BYTES_IN, MAX_BYTES_IN
FROM V$CPOOL_CC_INFO;

官方英文解释

V$CPOOL_CC_INFO displays information about the pool-to-connection class mapping for the Database Resident Connection Pool per instance.

Column Datatype Description

POOL_NAME

VARCHAR2(1024)

Name of the Database Resident Connection Pool

CCLASS_NAME

VARCHAR2(1024)

Name of the connection class

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


数据运维技术 » Oracle 视图 V$CPOOL_CC_INFO 官方解释,作用,如何使用详细说明