How are data workloads managed in Oracle Autonomous Database?

Data workloads in Oracle Autonomous Database are managed using features like workload management and resource allocation, which are specifically designed to optimize performance. This means that the system can automatically adjust resources based on the needs of different workloads, ensuring that performance is maintained efficiently without manual intervention.

Workload management allows the database to prioritize tasks based on their importance or resource requirements, significant for maintaining high performance during peak times. Resource allocation dynamically adjusts the available computing power and storage in response to the current demand, which is particularly useful in a cloud environment where workloads can be unpredictable and variable.

In contrast, while user-defined scripts or manual processes to review workloads exist, they would not be as effective in a cloud environment designed for automation and efficiency. Offloading to external applications does not inherently manage workloads within the database itself, and thus wouldn't contribute directly to the optimization of performance in the same integrated manner as the built-in features of the Oracle Autonomous Database.