Available Options in Oracle

An Oracle option extends the capabilities of the Oracle server This is in contrast to Oracle features.

The v$option view shows which options are installed on a server.

The following options are available:

• Partitioning
  Applies to tables and indexes. If a table or an index is partitioned, several pieces of the same object can be 'scattered' in seperate segements and even on different tablespaces.
• Objects
  Refers to the ability to create user defined types.
• Real Application Clusters (RAC)
  Previously known as Parallel Server.
• Advanced replication
  This options is a requirement for updateable materialized views and writeable materialized views.
• Bit-mapped indexes
  Bit-mapped indexes is one of the possible indexing methods.
• Connection multiplexing
• Connection pooling
• Database queuing Integrates a message queue system with the database (aq).
• Incremental backup and recovery
  Ability to only backup data blocks that have changed since the last backup.
• Instead-of triggers
• Parallel backup and recovery
  RMAN can make parallelize backups of the database.
• Parallel execution
  With parallel execution, a single SQL statement can be processed by multible processes.
• Parallel load
• Point-in-time tablespace recovery (TSPITR)
  Allows to recover a tablespace to a specific (prior) time that is different from the rest of the tablespaces.
• Fine-grained access control (FGAC)
  Defining policies to restrict what a user is allowed to see in a table.
• Proxy authentication/authorization
• Change Data Capture
• Plan Stability
  Altering sort_area_size or bitmap_merge_area_size might affect the cost based optimizer. Plan stability prevents that.
• Online Index Build
  See Building indexes online.
• Coalesce Index
  See Coalescing indexes.
• Managed Standby
  See managed standby.
• Materialized view rewrite
  See query rewrite
• Materialized view warehouse refresh
• Database Resource Manager
• Spatial
  Oracle Spatial Cartridge is an integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly and efficiently.
• Visual Information Retrieval
  
• Export transportable tablespaces
  This option is required for transportable tablespaces.
• Transparent Application Failover
  Comes into play if a node in an Oracle Parallel Servers fails: Transparent application failover migrates in such case the connections (and sessions) to another node.
  The applications will hence not notice the failure.
• Fast-Start Fault Recovery
  
• Sample Scan
  See select * from t sample(..)
• Duplexed backups
• Java
• OLAP Window Functions
• Block Media Recovery
• Fine-grained Auditing
• Application Role
• Enterprise User Security
• Oracle Data Guard
• Oracle Label Security
• OLAP
• Heap segment compression
• Join index
  See types of indexes
• Trial Recovery
• Oracle Data Mining
• online redefinition
• Streams
• Very Large Memory
• File Mapping