Oracle 视图 DBA_FEATURE_USAGE_STATISTICS 官方解释，作用，如何使用详细说明
本站中文解释
？
Oracle视图DBA_FEATURE_USAGE_STATISTICS用于跟踪操作系统特征/选项的使用情况。它能够提供表示操作系统配置的信息，用以检测和分析不同特性的使用比率，考察Oracle功能的正确使用情况，以及调优存储和操作系统架构。该视图有以下字段：FEATURE_NAME，USAGE_COUNT，LAST_USAGE_DATE。
DBA_FEATURE_USAGE_STATISTICS视图可以使用SELECT语句从它中检索信息，例如：
SELECT FEATURE_NAME,USAGE_COUNT,LAST_USAGE_DATE FROM DBA_FEATURE_USAGE_STATISTICS;
这条查询将返回包含特征名称、使用次数和最后使用日期的结果集。
官方英文解释
DBA_FEATURE_USAGE_STATISTICS displays information about database feature usage statistics.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Database identifier of the database being tracked |
|
|
|
|
Name of the feature |
|
|
|
|
Database version in which the feature was tracked |
|
|
|
|
Number of times the system has detected usage for the feature |
|
|
|
|
Number of times the system has woken up and checked for feature usage |
|
|
|
Indicates whether usage was detected the last time the system checked ( |
|
|
|
|
First sample time the system detected usage of the feature |
|
|
|
|
Last sample time the system detected usage of the feature |
|
|
|
|
This column stores feature-specific usage data in number format. |
|
|
|
|
This column stores feature-specific usage data in character format. |
|
|
|
|
The last time the system checked for usage |
|
|
|
|
Amount of time (in seconds) between the last two usage sample times |
|
|
|
|
Sample interval |
|
|
|
|
Description of the feature and usage detection logic |
|
|
|
|
The last time the system checked for usage of the feature |
Footnote 1 This column is available starting with Oracle Database 21c.
Note:
Use the following SQL query to list the database features and their descriptions in alphabetical order:
SELECT name, description FROM dba_feature_usage_statistics ORDER BY name;
