DBA_OBJECT_USAGE

DBA_OBJECT_USAGE displays statistics about index usage gathered from the database for all the indexes in the database. You can use this view to monitor index usage. All indexes that have been used at least once can be monitored and displayed in this view.

Related View

  • USER_OBJECT_USAGE displays statistics about index usage gathered from the database for the indexes owned by the current user.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Index owner

INDEX_NAME

VARCHAR2(128)

NOT NULL

Index name in sys.obj$.name

TABLE_NAME

VARCHAR2(128)

NOT NULL

Table name in sys.obj$.name

MONITORING

VARCHAR2(3)

  

Indicates whether the monitoring feature is turned on. Possible values:

  • YES

  • NO

USED

VARCHAR2(3)

  

Indicates whether the index has been accessed. Possible values:

  • YES

  • NO

START_MONITORING

VARCHAR2(19)

  

Start monitoring time in sys.object_stats.start_monitoring

END_MONITORING

VARCHAR2(19)

  

End monitoring time in sys.object_stats.end_monitoring

See Also:

"USER_OBJECT_USAGE"