(转)oracle数据库中看新特性的视图

Oracle10g中增加了一张叫做DBA_FEATURE_USAGE_STATISTICS的视图，只要你使用过的一些特性都会记录下来，而且这些信息可能在一些trace文件比如RDA收集的结果中存在，没买license而使用了这些特性的要注意了。不过透过这个视图，也能了解到系统的很多情况，或许很多东西都是作为DBA的你都不曾注意到的吧，呵呵

SQL> select name,detected_usages as "usage",currently_used,first_usage_date,last_usage_date
  2  from dba_feature_usage_statistics;
NAME                                                    usage CURRE FIRST_USAGE_ LAST_USAGE_D
-------------------------------------------------- ---------- ----- ------------ ------------
Protection Mode - Maximum Availability                      0 FALSE
Protection Mode - Maximum Performance                      36 TRUE  04-FEB-08    06-OCT-08
Protection Mode - Maximum Protection                        0 FALSE
Protection Mode - Unprotected                               0 FALSE
Real Application Clusters (RAC)                             0 FALSE
Recovery Area                                               0 FALSE
Recovery Manager (RMAN)                                    32 TRUE  03-MAR-08    06-OCT-08
RMAN - Disk Backup                                         32 TRUE  03-MAR-08    06-OCT-08
RMAN - Tape Backup                                          0 FALSE
Resource Manager                                            0 FALSE
Segment Advisor                                            34 TRUE  18-FEB-08    06-OCT-08
Server Parameter File                                      36 TRUE  04-FEB-08    06-OCT-08
Undo Advisor                                                0 FALSE
Virtual Private Database (VPD)                              0 FALSE
Shared Server                                               0 FALSE
Spatial                                                     0 FALSE
SQL Access Advisor                                          0 FALSE
SQL Tuning Advisor                                          0 FALSE
SQL Tuning Set                                              0 FALSE
Standby Archival - LGWR                                    23 TRUE  17-MAR-08    06-OCT-08
Standby Archival - ARCH                                     9 FALSE 03-MAR-08    12-MAY-08
Standby Transmission                                       32 TRUE  03-MAR-08    06-OCT-08
Streams (system)                                           36 TRUE  04-FEB-08    06-OCT-08
Streams (user)                                              0 FALSE
Transparent Gateway                                         0 FALSE
Advanced Replication                                        0 FALSE
Advanced Security                                           0 FALSE
Audit Options                                               0 FALSE
Automatic Database Diagnostic Monitor                       0 FALSE
Automatic Segment Space Management (system)                36 TRUE  04-FEB-08    06-OCT-08
Automatic Segment Space Management (user)                  36 TRUE  04-FEB-08    06-OCT-08
Automatic SQL Execution Memory                             36 TRUE  04-FEB-08    06-OCT-08
Automatic Storage Manager                                   0 FALSE
Automatic Undo Management                                  36 TRUE  04-FEB-08    06-OCT-08
Automatic Workload Repository                               0 FALSE
Change-Aware Incremental Backup                             0 FALSE
Client Identifier                                           0 FALSE
CSSCAN                                                      0 FALSE
Character Semantics                                         0 FALSE
Character Set                                              36 TRUE  04-FEB-08    06-OCT-08
Data Guard                                                 32 TRUE  03-MAR-08    06-OCT-08
Data Guard Broker                                           0 FALSE
Data Mining                                                 0 FALSE
Dynamic SGA                                                 0 FALSE
File Mapping                                                0 FALSE
Flashback Database                                          0 FALSE
Internode Parallel Execution                                0 FALSE
Label Security                                              0 FALSE
Locally Managed Tablespaces (system)                       36 TRUE  04-FEB-08    06-OCT-08
Locally Managed Tablespaces (user)                         36 TRUE  04-FEB-08    06-OCT-08
Messaging Gateway                                           0 FALSE
MTTR Advisor                                               21 FALSE 04-FEB-08    23-JUN-08
Multiple Block Sizes                                        0 FALSE
OLAP - Analytic Workspaces                                  0 FALSE
OLAP - Cubes                                                0 FALSE
Oracle Managed Files                                        0 FALSE
Parallel SQL DDL Execution                                  2 FALSE 17-MAR-08    24-MAR-08
Parallel SQL DML Execution                                  0 FALSE
Parallel SQL Query Execution                               26 TRUE  14-APR-08    06-OCT-08
Partitioning (system)                                      36 TRUE  04-FEB-08    06-OCT-08
Partitioning (user)                                        32 TRUE  03-MAR-08    06-OCT-08
PL/SQL Native Compilation                                   0 FALSE

SQL> select * from v$version;