What feature allows for automatic scaling in Oracle Autonomous Database?

The feature that enables automatic scaling in Oracle Autonomous Database is the auto-scaling capability, which adjusts resources based on workload needs. This functionality is critical for optimizing performance and managing costs effectively. The system intelligently monitors workload patterns and dynamically allocates the necessary computational resources—such as CPU and memory—based on real-time demand. This ensures that the database can handle varying workloads without manual intervention, providing both efficiency and flexibility.

In contrast to other options, dynamic resource allocation does not specifically refer to the ability to scale resources automatically based on workload; rather, it often involves pre-configured resource assignments that may not adjust independently. Load balancing focuses primarily on distributing workloads evenly across resources but does not inherently include the capability to scale those resources up or down. Resource limiting, while essential for maintaining stability and controlling costs, places caps on resource use instead of adapting to changing conditions. Overall, the auto-scaling feature is essential for maintaining optimal performance while managing resource efficiency in an ever-changing workload environment.