Database features

Apart from the clearly-defined database options, Oracle databases may include many semi-autonomous software sub-systems, which Oracle Corporation sometimes refers to as features. Such features may include (for example):

• Automatic Workload Repository (AWR), providing monitoring services to Oracle database installations from Oracle version 10. Prior to the release of Oracle version 10, the Statspack facility provided similar functionality.

• Data Aggregation and Consolidation

• Data Guard for high availability

• Data Pump utilities, which aid in importing and exporting data and metadata between databases.

• Flashback for selective data recovery and reconstruction

• iSQL*Plus, a web-browser-based interface to Oracle database DML

• Oracle-managed files (OMF) -- a feature allowing automated naming, creation and deletion of datafiles at the operating system level.

• Recovery Manager (rman) for database backup, restoration and recovery

• SQL*Plus, a CLI-based program that allows users to interact with Oracle database(s) via SQL and PL/SQL commands