oracle数据库选件,oracle 11gR2 数据库功能选件安装情况

select * from v$option order by value,parameter

PARAMETER                         VALUE

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

Oracle Database Vault             FALSE

Oracle Label Security             FALSE

Active Data Guard                 TRUE

Advanced Compression              TRUE

Advanced replication              TRUE

Application Role                  TRUE

Automatic Storage Management      TRUE

Backup Encryption                 TRUE

Basic Compression                 TRUE

Bit-mapped indexes                TRUE

Block Change Tracking             TRUE

Block Media Recovery              TRUE

Change Data Capture               TRUE

Coalesce Index                    TRUE

Connection multiplexing           TRUE

Connection pooling                TRUE

DICOM                             TRUE

Data Mining                       TRUE

Database queuing                  TRUE

Database resource manager         TRUE

Deferred Segment Creation         TRUE

Duplexed backups                  TRUE

Enterprise User Security          TRUE

Export transportable tablespaces  TRUE

Fast-Start Fault Recovery         TRUE

File Mapping                      TRUE

Fine-grained Auditing             TRUE

Fine-grained access control       TRUE

Flashback Data Archive            TRUE

Flashback Database                TRUE

Flashback Table                   TRUE

Incremental backup and recovery   TRUE

Instead-of triggers               TRUE

Java                              TRUE

Join index                        TRUE

Managed Standby                   TRUE

Materialized view rewrite         TRUE

Materialized view warehouse refresTRUE

OLAP                              TRUE

OLAP Window Functions             TRUE

Objects                           TRUE

Online Index Build                TRUE

Online Redefinition               TRUE

Oracle Data Guard                 TRUE

Parallel backup and recovery      TRUE

Parallel execution                TRUE

Parallel load                     TRUE

Partitioning                      TRUE

Plan Stability                    TRUE

Point-in-time tablespace recovery TRUE

Proxy authentication/authorizationTRUE

Real Application Clusters         TRUE

Real Application Testing          TRUE

Result Cache                      TRUE

SQL Plan Management               TRUE

Sample Scan                       TRUE

SecureFiles Encryption            TRUE

Server Flash Cache                TRUE

Spatial                           TRUE

Streams Capture                   TRUE

Transparent Application Failover  TRUE

Transparent Data Encryption       TRUE

Trial Recovery                    TRUE

Unused Block Compression          TRUE

XStream                           TRUE

65 rows selected.

可以看出11g新增加了很多功能，比如dataguard在线应用日志Active Data Guard ,

结果集缓存Result Cache 等等