Dynamic Performance (V$) Views, 21 of 179

V$BUFFER_POOL

This view displays information about all buffer pools available for the instance. The "sets" pertain to the number of LRU latch sets.

See Also:
"DB_BLOCK_LRU_LATCHES".

Column	Datatype	Description
`ID`	`NUMBER`	Buffer pool ID number
`NAME`	`VARCHAR2`	Buffer pool name
`LO_SETID`	`NUMBER`	Low set ID number
`HI_SETID`	`NUMBER`	High set ID number
`SET_COUNT`	`NUMBER`	Number of sets in this buffer pool. This is `HI_SETID` - `LO_SETID` + 1
`BUFFERS`	`NUMBER`	Number of buffers allocated to the buffer pool
`LO_BNUM`	`NUMBER`	Low buffer number for this pool
`HI_BNUM`	`NUMBER`	High buffer number for this pool