Oracle Autonomous Database

Oracle Autonomous Database promises

• to deliver automated patching and upgrades
• automated tuning
• to minimize human error and human labor
• eliminate routine maintenance tasks (provisioning, scaling, patching, tuning, …)
• Artificial Intelligence prevents, detects and responds to performance issues and cybersecurity issues.
• security

DBAs won't go out of job, however. Rather, they will use their skill for even more important tasks at an organization.

Oracle claims to be the world's first vendor to deliver an autonomous database.

Replay production workload on a test database to make sure that an upgrade does not have unexpected side effects on the production DB.

Load and go architecture: database tunes itself and creates or drops indexes.

Security patches are automatically applied every quarter. Patches for zero day exploits are applied off-cycle.

Oracle Autonomous Transaction Processing allows to run mission-critical enterprise applications, including mixed workloads and real-time analytics.

These goals are achieved with

• Machine learning

Packages that are supplied for Autonomous Database include

• dbms_cloud
• dbms_cloud_admin
• dbms_cloud_macadm
• dbms_cloud_repo
• dbms_dcat
• dbms_max_string_size
• dbms_auto_partition
• cs_resource_manager
• cs_session

Oracle: Towards an autonomous database