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

TABLE: SYS.WRI$_DBU_FEATURE_USAGE

Object Details
Object Name: WRI$_DBU_FEATURE_USAGE
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRI$_DBU_FEATURE_USAGE_PK
  1. ColumnNAME
  2. ColumnDBID
  3. ColumnVERSION
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000366109C00008$$ LOB UNIQUE TablespaceSYSAUX
WRI$_DBU_FEATURE_USAGE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnNAME
ColumnDBID
ColumnVERSION
Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (64) Yes
DBID NUMBER
Yes
VERSION VARCHAR2 (17) Yes
FIRST_USAGE_DATE DATE

LAST_USAGE_DATE DATE

DETECTED_USAGES NUMBER
Yes
AUX_COUNT NUMBER

FEATURE_INFO CLOB (4000)
ERROR_COUNT NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      DBID
,      VERSION
,      FIRST_USAGE_DATE
,      LAST_USAGE_DATE
,      DETECTED_USAGES
,      AUX_COUNT
,      FEATURE_INFO
,      ERROR_COUNT
FROM SYS.WRI$_DBU_FEATURE_USAGE;

Dependencies

[top of page]

SYS.WRI$_DBU_FEATURE_USAGE does not reference any database object

SYS.WRI$_DBU_FEATURE_USAGE is referenced by following:

SchemaSYS
ViewDBA_FEATURE_USAGE_STATISTICS
Package BodyDBMS_FEATURE_USAGE - show dependent code
Package BodyDBMS_FEATURE_USAGE_INTERNAL - show dependent code