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