Oracle 视图 V$BUFFER_POOL_STATISTICS 官方解释，作用，如何使用详细说明
本站中文解释
总览
Oracle视图V$BUFFER_POOL_STATISTICS总体来说是概括缓冲池的各种统计信息的一张视图，该视图的用途一般用于查看正在运行的实例的各种缓冲池的状态，可以用来确定当前正在使用的是哪个缓冲池、它的不同类型的总量以及当前被查看缓冲池的生成比率等等。主要用于检查缓冲池，检查缓冲池数据库和缓冲池回写率是否符合要求。
使用方法：
1. 通过登录服务器的sqlplus客户端连接数据库；
2. 使用SQL查询语句：SELECT * FROM v$buffer_pool_statistics；
3. 根据具体的缓冲池信息，确定当前正在使用的缓冲池，缓冲池状态，以及生成比率等信息；
4. 根据查询结果，优化该缓冲池使用及性能；
5. 退出sqlplus客户端。
官方英文解释
V$BUFFER_POOL_STATISTICS displays statistics about all buffer pools available for the instance.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Buffer pool identifier number |
|
|
|
Name of the buffer pool |
|
|
|
Block size (in bytes) for buffers in this pool. Possible values: the standard block size, the power of 2 nonstandard block sizes, |
|
|
|
Buffer pool maximum set size |
|
|
|
Number of buffers on replacement list |
|
|
|
Number of buffers on write list |
|
|
|
Number of buffers in set |
|
|
|
Number of buffers gotten by the set |
|
|
|
Number of buffers written by the set |
|
|
|
Number of buffers scanned in the set |
|
|
|
Free buffer wait statistic |
|
|
|
Write complete wait statistic |
|
|
|
Buffer busy wait statistic |
|
|
|
Free buffer inspected statistic |
|
|
|
Dirty buffers inspected statistic |
|
|
|
Database blocks changed statistic |
|
|
|
Database blocks gotten statistic |
|
|
|
Consistent gets statistic |
|
|
|
Physical reads statistic |
|
|
|
Physical writes statistic |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“DB_CACHE_SIZE”
