Oracle 视图 DBA_FEATURE_USAGE_STATISTICS 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 DBA_FEATURE_USAGE_STATISTICS 官方解释，作用，如何使用详细说明 10-15

本站中文解释

？

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
`DBID`	`NUMBER`	`NOT NULL`	Database identifier of the database being tracked
`NAME`	`VARCHAR2(64)`	`NOT NULL`	Name of the feature
`VERSION`	`VARCHAR2(17)`	`NOT NULL`	Database version in which the feature was tracked
`DETECTED_USAGES`	`NUMBER`	`NOT NULL`	Number of times the system has detected usage for the feature
`TOTAL_SAMPLES`	`NUMBER`	`NOT NULL`	Number of times the system has woken up and checked for feature usage
`CURRENTLY_USED`	`VARCHAR2(5)`		Indicates whether usage was detected the last time the system checked (`TRUE`) or not (`FALSE`)
`FIRST_USAGE_DATE`	`DATE`		First sample time the system detected usage of the feature
`LAST_USAGE_DATE`	`DATE`		Last sample time the system detected usage of the feature
`AUX_COUNT`	`NUMBER`		This column stores feature-specific usage data in number format.
`FEATURE_INFO`	`CLOB`		This column stores feature-specific usage data in character format.
`LAST_SAMPLE_DATE`	`DATE`		The last time the system checked for usage
`LAST_SAMPLE_PERIOD`	`NUMBER`		Amount of time (in seconds) between the last two usage sample times
`SAMPLE_INTERVAL`	`NUMBER`		Sample interval
`DESCRIPTION`	`VARCHAR2(128)`		Description of the feature and usage detection logic
`LAST_FEAT_SAMPLE_DATE`^Foot 1	`DATE`		The last time the system checked for usage of the feature

^Footnote 1This 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_statisticsORDER BY name;

编辑：广州明生堂生物科技有限公司

标签：视图,操作系统,特征,情况,这条