V$OBJECT_USAGE视图-CSDN博客

V$OBJECT_USAGE

V$OBJECT_USAGE displays statistics about index usage gathered from 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.

V$OBJECT_USAGE显示有关于数据库中索引使用情况的统计。能够利用这个视图来监控索引使用。该视图能够监控和显示最近一次使用到的所有索引。

Column	Datatype	Description
`INDEX_NAME`	`VARCHAR2(30)`	Index name in sys.obj$.name(索引的名字)
`TABLE_NAMEa`	`VARCHAR2(30)`	Table name in sys.obj$.name(索引的基表)
`MONITORING`	`VARCHAR2(3)`	`YES`\|`NO(是否监控，yes 是\|no 否)`
`USED`	`VARCHAR2(3)`	`YES`\|`NO(是否使用，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(索引监控结束时间)`

V$OBJECT_USAGE手动开启和停止索引监控命令：

SQL> alter index INDEX_NAME monitoring usage;
SQL> alter index INDEX_NAME nomonitoring usage;
SQL> SELECT * FROM V$OBJECT_USAGE;
INDEX_NAME           TABLE_NAME       MONITORING USED START_MONITORING    END_MONITORING
-------------------- ---------------- ---------- ---- ------------------- ---------------
PK_HOSP_ASSAYRECORD  HOSP_ASSAYRECORD NO         NO   10/12/2012 19:11:22 10/12/2012 19:41:04