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