|
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 Table Space Connection |
Logical Data Grouping db_event tablespace_event conn_event |
|
|
Element Name Element Type |
pool_index_l_reads counter |
Description: Indicates the number of logical read requests for index pages that have gone through the buffer pool.
Usage: This count includes accesses to index pages that are:
In conjunction with "Buffer Pool Index Physical Reads", you can calculate the index page hit ratio for the buffer pool using one of the following:
1 - (buffer pool index physical reads / buffer pool index logical reads)
To calculate the overall buffer pool hit ratio, see "Buffer Pool Data Logical Reads".
If the hit ratio is low, increasing the number of buffer pool pages may improve performance. See the Administration Guide for more information about buffer pool size.