eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_FEATURE_USAGE_STATISTICS

Object Details

Object Name:	DBA_FEATURE_USAGE_STATISTICS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Database Feature Usage Statistics

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

SYS.DBA_FEATURE_USAGE_STATISTICS references the following:

SYS: WRI$_DBU_FEATURE_METADATA; WRI$_DBU_FEATURE_USAGE; WRI$_DBU_USAGE_SAMPLE

SYS.DBA_FEATURE_USAGE_STATISTICS is referenced by following:

PUBLIC: DBA_FEATURE_USAGE_STATISTICS
SYS: DBMS_FEATURE_AUM - show dependent code; DBMS_FEATURE_AUTOSTA - show dependent code; DBMS_FEATURE_EMX - show dependent code; DBMS_FEATURE_SEGADV_USER - show dependent code; DBMS_FEATURE_UTILITIES1 - show dependent code; DBMS_FEATURE_UTILITIES2 - show dependent code; DBMS_FEATURE_UTILITIES3 - show dependent code; DBMS_FEATURE_UTILITIES4 - show dependent code; DBMS_FEATURE_WCR_CAPTURE - show dependent code; DBMS_FEATURE_WCR_REPLAY - show dependent code; DBMS_SWRF_REPORT_INTERNAL - show dependent code