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