An Oracle option extends the capabilities of the Oracle server This is in contrast to Oracle features
view shows which options are installed on a server.
The following options are available:
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.
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
Oracle Spatial Cartridge is an integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly
- 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
- OLAP Window Functions
- Block Media Recovery
- Fine-grained Auditing
- Application Role
- Enterprise User Security
- Oracle Data Guard
- Oracle Label Security
- Heap segment compression
- Join index
See types of indexes
- Trial Recovery
- Oracle Data Mining
- online redefinition
- Very Large Memory
- File Mapping