Memory allocation
Memory allocation and deallocation occurs at various times.
Memory might be allocated to a particular memory area when a specific
event occurs (for example, when an application connects), or it might
be reallocated in response to a configuration change.
Self-tuning memory overview
Self-tuning memory simplifies the task of memory configuration
by automatically setting values for memory configuration parameters
and sizing buffer pools. When enabled, the memory tuner dynamically
distributes available memory resources among the following memory
consumers: buffer pools, locking memory, package cache, and sort memory.
Buffer pool management
A buffer pool provides working memory and cache for database
pages.
Database deactivation behavior in first-user connection scenarios
A database is activated when a user first connects to it.
In a single-partition environment, the database is loaded into memory
and remains in this state until the last user disconnects. The same
behavior applies to multi-partition environments, where any first-user
connection activates the database on both local and catalog partitions
for that database.
Tuning sort performance
Because queries often require sorted or grouped results,
proper configuration of the sort heap is crucial to good query performance.