SQL> select * from v$option order by value;
PARAMETER VALUE
---------------------------------------------------------------- -----
Partitioning FALSE
Real Application Clusters FALSE
Advanced replication FALSE
Parallel backup and recovery FALSE
Incremental backup and recovery FALSE
Bit-mapped indexes FALSE
Parallel execution FALSE
Point-in-time tablespace recovery FALSE
Fine-grained access control FALSE
Spatial FALSE
Database resource manager FALSE
PARAMETER VALUE
---------------------------------------------------------------- -----
Materialized view warehouse refresh FALSE
Materialized view rewrite FALSE
Managed Standby FALSE
Coalesce Index FALSE
Online Index Build FALSE
Plan Stability FALSE
Function-based indexes FALSE
Enterprise User Security FALSE
Application Role FALSE
Fine-grained Auditing FALSE
Block Media Recovery FALSE
PARAMETER VALUE
---------------------------------------------------------------- -----
Java FALSE
Duplexed backups FALSE
Sample Scan FALSE
Fast-Start Fault Recovery FALSE
Transparent Application Failover FALSE
Export transportable tablespaces FALSE
Visual Information Retrieval FALSE
Objects TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Proxy authentication/authorization TRUE
PARAMETER VALUE
---------------------------------------------------------------- -----
OLAP Window Functions TRUE
Parallel load TRUE
Instead-of triggers TRUE
Database queuing TRUE
37 rows selected.