The Details tab on the Buffer Pools drilldown provides the following information about the selected buffer pool:
Configuration information
Use of extended storage
The amount of time required to perform I/O that involved this buffer pool
Extended storage is a secondary level of storage for buffer pools, allowing the user to access memory beyond the maximum allowed for each process. When the database has buffer pools configured for extended storage, the extended storage counters are useful. They show the number of data and index pages belonging to the tablespace that are copied in and out of extended storage. If the number of pages copied out of extended storage back into the buffer pools is higher than the number of pages copied into extended storage from the buffer pools, your database at this tablespace level is probably benefiting from extended storage.
The Buffer pool Details list shows current identification, extended storage, and configuration settings for the selected buffer pool.
|
|
|
The Buffer pool Timings bar graph compares the amount of time (in seconds) required to perform each of these types of I/O that involve the selected buffer pool.
Use the graph to get an overall sense of the time required to perform I/O involving this buffer pool.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
