Search notes:

Oracle: V$OPTION

Which options are installed on a server?
select
  parameter
from
  v$option
order by
  parameter;
-- Active Data Guard
-- Advanced Compression
-- Advanced replication
-- Application Role
-- Automatic Storage Management
-- Backup Encryption
-- Basic Compression
-- Bit-mapped indexes
-- Block Change Tracking
-- Block Media Recovery
-- Change Data Capture
-- Coalesce Index
-- Connection multiplexing
-- Connection pooling
-- DICOM
-- Data Mining
-- Database queuing
-- Database resource manager
-- Deferred Segment Creation
-- Duplexed backups
-- Enterprise User Security
-- Export transportable tablespaces
-- Fast-Start Fault Recovery
-- File Mapping
-- Fine-grained Auditing
-- Fine-grained access control
-- Flashback Data Archive
-- Flashback Database
-- Flashback Table
-- Incremental backup and recovery
-- Instead-of triggers
-- Java
-- Join index
-- Managed Standby
-- Materialized view rewrite
-- Materialized view warehouse refresh
-- OLAP
-- OLAP Window Functions
-- Objects
-- Online Index Build
-- Online Redefinition
-- Oracle Data Guard
-- Oracle Database Vault
-- Oracle Label Security
-- Parallel backup and recovery
-- Parallel execution
-- Parallel load
-- Partitioning
-- Plan Stability
-- Point-in-time tablespace recovery
-- Proxy authentication/authorization
-- Real Application Clusters
-- Real Application Testing
-- Result Cache
-- SQL Plan Management
-- Sample Scan
-- SecureFiles Encryption
-- Server Flash Cache
-- Spatial
-- Streams Capture
-- Transparent Application Failover
-- Transparent Data Encryption
-- Trial Recovery
-- Unused Block Compression
-- XStream
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/option/parameter.sql

See also

dba_feature_usage_statistics
dba_registry
Oracle Dynamic Performance Views

Index