table_definition_cache parameter is used to set the number of cached table definition objects. The table definition cache stores metadata (such as column names and data types) for tables in the database, enabling fast access to this information during query execution. When this limit is reached, the system disables the least recently used table definitions based on the LRU (Least Recently Used) algorithm to free up space for new table definitions.table_open_cache parameter instead of the table_definition_cache parameter.Required | Description |
Parameter Type | ULONG |
Default Value | 4294967295 |
Value Range | 400 ~ 4294967295 |
Effective Scope | GLOBAL |
Restart Required | No |
피드백