V$OBJECT_USAGE视图

最新推荐文章于 2022-08-29 18:00:06 发布

chilie9862

最新推荐文章于 2022-08-29 18:00:06 发布

阅读量296

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/u/174862/blog/285977

版权

V$OBJECT_USAGE

V$OBJECT_USAGEdisplays 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 insys.object_stats.start_monitoring(索引监控开始时间)
END_MONITORING	VARCHAR2(19)	End monitoring time insys.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

转载于:https://my.oschina.net/u/174862/blog/285977