)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;