Memory Manager
When executing SQL operations on non-SQL data, the connector often needs to cache the data temporarily before it can complete the operation. The Memory Manager feature in the connector allows you to manage the amount of RAM or disk space that the connector can use to cache data.
Some operations require data to be cached temporarily before they can be completed. For example, when the connector executes a query that contains an ORDER BY clause, the connector caches the retrieved data, sorts the data, and then returns the sorted data as a result set. The cache is then cleared.
You can specify the maximum amount of RAM that the connector can use to support all concurrent operations. You can also reserve a portion of that RAM for new operations, to ensure that the RAM is not completely consumed by an existing operation. Typically, if an operation or set of operations requires more RAM than the allotted amount, the connector moves some of the cached data into temporary files called "swap files" in order to free up memory and complete the operation or operations. You can specify the maximum amount of disk space that can be consumed by swap files, or configure the connector to stop the operation instead of moving data to disk.
For information about how to configure the Memory Manager in the connector, see Configuring Memory Usage.