How does Autonomous Database handle scaling?

Autonomous Database is designed to optimize resource management automatically, which includes scaling compute and storage resources in real-time based on workload demand. This capability is a key feature of Oracle's Autonomous Database, as it allows the system to adjust resources dynamically without user intervention, ensuring performance is maintained even as workload patterns change.

When workloads increase, the Autonomous Database can automatically allocate additional compute and storage capacity to handle the increased demand. Conversely, during periods of lower activity, it can scale back the resources to reduce costs while maintaining efficiency. This elasticity enhances operational efficiency by managing resources in a way that aligns with the actual needs of the applications running on the database.

The other options do not accurately represent the capabilities of the Autonomous Database. It does not require manual intervention for scaling, nor is it limited to only computing resources or pre-defined user schedules. Instead, the focus is on a fully automated approach, making it particularly effective in environments where workload demands are unpredictable.