[Home] [Help] [Dependency Information]
Object Name: | DBA_FEATURE_USAGE_STATISTICS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Database Feature Usage Statistics
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DBID | NUMBER | Yes | database ID of database being tracked | |
NAME | VARCHAR2 | (64) | Yes | name of feature |
VERSION | VARCHAR2 | (17) | Yes | the database version the feature was tracked in |
DETECTED_USAGES | NUMBER | Yes | number of times the system has detected usage for the feature | |
TOTAL_SAMPLES | NUMBER | Yes | number of times the system has woken up and checked for usage | |
CURRENTLY_USED | VARCHAR2 | (5) | if usage was detected the last time the system checked | |
FIRST_USAGE_DATE | DATE | the first sample time the system detected usage for the feature | ||
LAST_USAGE_DATE | DATE | the last sample time the system detected usage for the feature | ||
AUX_COUNT | NUMBER | extra column to store feature specific usage data | ||
FEATURE_INFO | CLOB | (4000) | extra column to store feature specific usage data | |
LAST_SAMPLE_DATE | DATE | last time the system checked for usage | ||
LAST_SAMPLE_PERIOD | NUMBER | amount of time between the last two usage sample times, in number of seconds | ||
SAMPLE_INTERVAL | NUMBER | |||
DESCRIPTION | VARCHAR2 | (128) | describes feature and usage detection logic |
Cut, paste (and edit) the following text to query this object:
SELECT DBID
, NAME
, VERSION
, DETECTED_USAGES
, TOTAL_SAMPLES
, CURRENTLY_USED
, FIRST_USAGE_DATE
, LAST_USAGE_DATE
, AUX_COUNT
, FEATURE_INFO
, LAST_SAMPLE_DATE
, LAST_SAMPLE_PERIOD
, SAMPLE_INTERVAL
, DESCRIPTION
FROM SYS.DBA_FEATURE_USAGE_STATISTICS;
|
|
|