Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

MAX_KEEPOPEN_FILES

MAX_KEEPOPEN_FILES <maximum # of KEEPOPEN files>

Sets a limit on the number of files that can be kept in the KEEPOPEN state (meaning the file has been closed by all connections, but the server is keeping the file open for reuse).

This prevents potential negative performance impacts from keeping too many files in the KEEPOPEN state.

Default: 1000

TOCIndex