5.273 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

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;