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

最新推荐文章于 2024-10-31 16:40:47 发布

原创最新推荐文章于 2024-10-31 16:40:47 发布 · 172 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #SQL #SQL Server #Security #performance

数据库相关/oracle 专栏收录该内容

326 篇文章

订阅专栏

本文介绍了Oracle10g数据库中DBA_FEATURE_USAGE_STATISTICS视图的功能及其使用情况记录。该视图可以帮助管理员了解系统中各种特性的使用频率和状态，包括资源管理器、恢复管理器等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;