Buffer Pool Index Pages from Extended Storage


 
Snapshot Level
Database
Table Space
 
Application

 
Logical Data Grouping
dbase
tablespace
bp_info
appl

 
Monitor Switch
Buffer Pool
Buffer Pool
Buffer Pool
Buffer Pool

Resettable

Yes

 

 
Event Type
Database
Connection
Table Space

 
Logical Data Grouping
db_event
conn_event
tablespace_event

 
 

Element Name
Element Type

pool_index_from_estore
counter

 

Description:  Number of buffer pool index pages copied from extended storage.

Usage:  Required index pages are copied from extended storage to the buffer pool, if they are not in the buffer pool, but are in extended storage. This copying may incur the cost of connecting to the shared memory segment, but saves the cost of a disk read.