René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Available features in Oracle

A feature is a set of functionality that enhances the use of Oracle database. They do not extend the capabilities of Oracle Server, rather, they use them. This is in contrast to options in Oracle.

Scalability and Performance

  • Concurrency
  • Read Consistency
  • Locking Mechanisms
  • Quiesce Database
  • RAC
  • Portability

Manageability

Backup and Recovery

High availability

Business Inteligence

  • Data Warehousing
  • ETL
  • Materialized views
  • Bitmap indexes
  • Table compression
  • Parallel Execution
  • Analytic SQL
  • OLAP
  • Data mining
  • Partitioning

Content Management

  • XML
  • LOB
  • Oracle Text
  • Oracle Ultra Search
  • Oracle interMedia
  • Oracle Spatial

Security

Data integrity/Triggers

  • Integrity constraints
  • Triggers

Information Integration Features

  • Distributes SQL
  • Oracle Streams

Retrieving a list of features from the database

Obviously, it's possible to select a list of (used?) features:
select name from dba_feature_usage_statistics;
A complete (???) list can be found:
select name, description from wri$_dbu_feature_metadata;