Oracle PL/SQL/System Tables Views/option

Query v$option table

 
SQL>
SQL> select parameter, value
  2  from v$option
  3  where rownum < 50
  4  order by parameter
  5  /
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Advanced replication
FALSE
Application Role
FALSE
Bit-mapped indexes
FALSE
Block Change Tracking
FALSE
Block Media Recovery
FALSE
Change Data Capture
FALSE
Coalesce Index
FALSE
Connection multiplexing
TRUE
Connection pooling
TRUE
Data Mining
FALSE
Database queuing
TRUE
Database resource manager
FALSE
Duplexed backups
FALSE
Enterprise User Security
FALSE
Export transportable tablespaces
FALSE
Fast-Start Fault Recovery
FALSE
File Mapping
FALSE
Fine-grained Auditing
FALSE
Fine-grained access control
FALSE
Flashback Table
FALSE
Incremental backup and recovery
TRUE
Instead-of triggers
TRUE
Java
FALSE
Join index
FALSE
Managed Standby
FALSE
Materialized view rewrite
FALSE
Materialized view warehouse refresh
FALSE
OLAP
FALSE
OLAP Window Functions
TRUE
Objects
TRUE
Online Index Build
FALSE
Online Redefinition
FALSE
Oracle Data Guard
FALSE
Oracle Label Security
FALSE
Parallel backup and recovery
FALSE
Parallel execution
FALSE
Parallel load
TRUE
Partitioning
FALSE
Plan Stability
TRUE
Point-in-time tablespace recovery
FALSE
Proxy authentication/authorization
TRUE
Real Application Clusters
FALSE
Sample Scan
TRUE
Spatial
FALSE
Streams Capture
FALSE
Table compression
FALSE
Transparent Application Failover
TRUE
Trial Recovery
FALSE
Visual Information Retrieval
FALSE

49 rows selected.
SQL>
SQL>
SQL> --