Snapshot Level Database Table Space |
Logical Data Grouping dbase tablespace bp_info |
Monitor Switch Buffer Pool Buffer Pool Buffer Pool |
Resettable |
Yes |
|
Event Type Database Table Space |
Logical Data Grouping db_event tablespace_event |
|
Element Name Element Type |
files_closed counter |
Description: The total number of database files closed.
Usage: The database manager opens files for reading and writing into and out of the buffer pool. The maximum number of database files open by an application at any time is controlled by the maxfilop configuration parameter. If the maximum is reached, one file will be closed before the new file is opened. Note that the actual number of files opened may not equal the number of files closed.
You can use this element to help you determine the best value for the maxfilop configuration parameter (see the Administration Guide for more information).