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

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