ORACLE功能特性使用统计DBA_FEATURE_USAGE_STATISTICS

DBA_FEATURE_USAGE_STATISTICS详解

最新推荐文章于 2025-07-22 18:55:55 发布

原创最新推荐文章于 2025-07-22 18:55:55 发布 · 892 阅读

CC 4.0 BY-SA版权

本文详细介绍了DBA_FEATURE_USAGE_STATISTICS视图，该视图提供了关于数据库特性使用统计的重要信息，包括特性名称、版本、检测使用次数、样本数量等关键数据。

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 (See Table 4-1)
`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`		Amount of time (in seconds) between the last two usage sample times
`LAST_SAMPLE_PERIOD`	`NUMBER`		Amount of time (in hours) between the last two usage sample times
`SAMPLE_INTERVAL`	`NUMBER`		Sample interval
`DESCRIPTION`	`VARCHAR2(128)`		Description of the feature and usage detection logic (See Table 4-1)