Oracle: Towards an autonomous database

During its releases, Oracle had a focus on automation of administration tasks. An automated database is easier to be put into the cloud.

9i:

• Automatic Query Rewrite
• Automatic Undo Management

10g:

• Automatic Memory Management
• Automatic Segment Space Mgmt
• Automatic Statistics Gathering
• Automatic Storage Management
• Automatic Workload Repository
• Automatic Diagnostic Monitor

11g:

• Automatic SQL Tuning
• Automatic Workload Capture / Replay
• Automatic SQL Plan Management
• Automatic Capture of SQL Monitor
• Automatic Data Optimization

12c:

• Autonomous Health Framework
• Automatic Diagnostic Framework
• Automatic Refresh of Clones

18c:

• Automatic Columnar Flash
• Automatic IM population
• Automatic Application Continuity

19c:

• Automatic Indexes, Partitions
• Automatic Materialized views