3.2 Buffer Cache Fixed Tables：buffer cache固定的表

n X$KCBBF: Buffer descriptor 状态对象和标志

n X$KCBWH: 描述where/why buffer gets的统计

n X$KCBSW: why/where buffer gets的统计. Only WHY0 is used.

n X$KCBBMC: Map count per buffer when _DB_BLOCK_CACHE_MAP is TRUE

n X$KCBBHS: DBWR histogram statistics, enabled if _DB_WRITER_HISTOGRAM_STATISTICS is TRUE

n X$KCBBES: DBWR event statistics.

n X$KCBWDS: Working set descriptor.

n V$WAITSTAT on X$KCBWAIT

n V$BUFFER_POOL on X$KCBWBPD

ITPub博客