Oracle 视图 DBA_HIST_BUFFER_POOL_STAT 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_HIST_BUFFER_POOL_STAT是用于检索数据库实例中缓冲池统计信息的视图。它提供归档级缓冲池使用统计信息，包括在可能的每个缓冲池中发生的数据库工作量分布，以及随着时间推移因缓冲池大小和性能变化而引起的使用情况的变化。
使用方法：
1、要检索此视图的缓冲池状态，请执行以下查询：
SELECT * FROM DBA_HIST_BUFFER_POOL_STAT;
2、要针对每个缓冲池生成状态摘要，请运行以下查询：
SELECT BUFFER_POOL 、 SUM(IMMEDIATE_BLOCK_GETS) 、 SUM(IMMEDIATE_BLOCK_GETS_WAIT_TIME) 、 SUM(DB_BLOCK_CHANGES) FROM DBA_HIST_BUFFER_POOL_STAT GROUP BY BUFFER_POOL;
官方英文解释
DBA_HIST_BUFFER_POOL_STAT displays historical statistics about all buffer pools available for the instance.
This view contains snapshots of V$BUFFER_POOL_STATISTICS.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique snapshot ID |
|
|
|
|
Database ID for the snapshot |
|
|
|
|
Instance number for the snapshot |
|
|
|
|
Buffer pool identifier number |
|
|
|
Name of the buffer pool |
|
|
|
|
Block Size |
|
|
|
|
Buffer pool maximum set size |
|
|
|
|
Number of buffers on the replacement list |
|
|
|
|
Number of buffers on the write list |
|
|
|
|
Number of buffers in the 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 database ID of the PDB for the sampled session |
|
|
|
|
The ID of the container that
|
See Also:
“V$BUFFER_POOL_STATISTICS”
