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

VIEW: SYS.CDB_FEATURE_USAGE_STATISTICS

Object Details
Object Name: CDB_FEATURE_USAGE_STATISTICS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Database Feature Usage Statistics in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_FEATURE_USAGE_STATISTICS;

Dependencies

[top of page]

SYS.CDB_FEATURE_USAGE_STATISTICS does not reference any database object

SYS.CDB_FEATURE_USAGE_STATISTICS is referenced by following:

SchemaPUBLIC
SynonymCDB_FEATURE_USAGE_STATISTICS