Instance caging is the right approach to make sure that database instances are not stealing memory from each other.

The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.

Database instances need to be restarted to make changes to cpu_count effective.

For a system with 16 threads, the sum of cpu_count for all databases should notbe higher than 32 to prevent oversubscribing

The init.org parameter resource_manager_plan should be set.

database size, full/incremental cycle, RPO (Recovery Point Objective), and RTO (Recovery Time Objective)

database size, retention period, RPO (Recovery Point Objective), and compression

database size, full/incremental cycle, compression, and retention period

database size, compression, and backup window

full/incremental cycle, retention period, and ZFS Backup Appliance model

Transformations can be applied directly on the file data using SQL or PL/SQLconstructions.

External tables allow transparent parallelization inside the database.

Parallelizing loads with external tables enables more efficient space management.

External tables can take advantage of storage indexes to speed up data loads.