oracle数据怎么看视图,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;