Summary of Oracle component series

Summary of Oracle component series
The Oracle component information can be viewed through v $ option and dba_registry:

-- View v $ option:

V $ OPTION displaysOracle Database options and features. typically, although not always, optionsmust be separately licensed, whereas features come with the product and areenabled based on the product that is running (Standard Edition, parameter iseedition, and so on ).

SQL> select * from v $ option;

PARAMETER VALUE

------------------------------------------------------

Partitioning TRUE

Objects TRUE

Real Application Clusters FALSE

Advanced replication TRUE

Bit-mapped indexes TRUE

Connection multiplexing TRUE

Connection pooling TRUE

Database queuing TRUE

Incremental backup and recovery TRUE

Instead-of triggers TRUE

Parallel backup and recovery TRUE

 

PARAMETER VALUE

------------------------------------------------------

Parallel execution TRUE

Parallel load TRUE

Point-in-time tablespace recovery TRUE

Fine-grained access control TRUE

Proxy authentication/authorization TRUE

Change Data Capture TRUE

Plan Stability TRUE

Online Index Build TRUE

Coalesce Index TRUE

Managed Standby TRUE

Materialized view rewrite TRUE

 

PARAMETER VALUE

------------------------------------------------------

Materialized view warehouse refresh TRUE

Database resource manager TRUE

Spatial TRUE

Automatic Storage Management FALSE

Export transportable tablespaces TRUE

Transparent Application Failover TRUE

Fast-Start Fault Recovery TRUE

Sample Scan TRUE

Duplexed backups TRUE

Java TRUE

OLAP Window Functions TRUE

 

PARAMETER VALUE

------------------------------------------------------

Block Media Recovery TRUE

Fine-grained Auditing TRUE

Application Role TRUE

Enterprise User Security TRUE

Oracle Data Guard TRUE

Oracle Label Security FALSE

OLAP TRUE

Basic Compression TRUE

Join index TRUE

Trial Recovery TRUE

Data Mining TRUE

 

PARAMETER VALUE

------------------------------------------------------

Online Redefinition TRUE

Streams Capture TRUE

File Mapping TRUE

Block Change Tracking TRUE

Flashback Table TRUE

Flashback Database TRUE

Transparent Data Encryption TRUE

Backup Encryption TRUE

Unused Block Compression TRUE

Oracle Database Vault FALSE

Result Cache TRUE

 

PARAMETER VALUE

------------------------------------------------------

SQL Plan Management TRUE

SecureFiles Encryption TRUE

Real Application Testing TRUE

Flashback Data Archive TRUE

DICOM TRUE

Active Data Guard TRUE

Server Flash Cache TRUE

Advanced Compression TRUE

XStream TRUE

Deferred Segment Creation TRUE

65 rows selected.

SQL>

1 2 Next Page