Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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> --