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 |
---|---|---|
|
|
Name of the Database Resident Connection Pool |
|
|
Name of the connection class |
|
|
The ID of the container to which the data pertains. Possible values include:
|