As you create a tenant, you can choose between using the primary buffer pool or the alternate buffer pool.
Note: Access to the alternate buffer pool feature requires an Enterprise database license. The feature is unavailable with a Workgroup or Personal database license.
The alternate buffer pool is a set of buffers in shared memory that are logically separate from the primary buffer pool. The alternate buffer pool gives the database administrator the ability to modify buffer pool behavior by designating objects or areas to consume buffers from the alternate buffer pool, rather than from the primary buffer pool.
Management of the buffers in the alternate buffer pool is independent of the primary buffer pool. Assigning specific database areas or objects to occupy buffers from the alternate buffer pool might improve your buffer hit rate, thereby reducing the need to read and write buffers to and from disk and possibly improving performance.
For each table, index, and LOB field, you can specify whether to use the primary or the alternate buffer pool.
