Oracle 视图 DBA_OBJECT_USAGE 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图 DBA_OBJECT_USAGE 用于报告引用给定对象的其他用户定义对象。 DBA_OBJECT_USAGE 视图报道了哪些用户对象依赖于给定对象。用户对象可以是表、索引、约束等。通常这是在部署和卸载时被引用，或者某些修改工作可能无法被完成，三四被报告出来。
使用方法:
使用 DBA_OBJECT_USAGE 视图主要是查询在删除或者更新某个schema下的对象时，会影响哪些对象的使用，而不影响到另外的对象的使用。
可以通过下面的语句使用: SELECT * FROM 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_USAGEdisplays statistics about index usage gathered from the database for the indexes owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Index owner |
|
|
|
|
Index name in sys.obj$.name |
|
|
|
|
Table name in sys.obj$.name |
|
|
|
Indicates whether the monitoring feature is turned on. Possible values:
|
|
|
|
|
Indicates whether the index has been accessed. Possible values:
|
|
|
|
|
Start monitoring time in |
|
|
|
|
End monitoring time in |
See Also:
“USER_OBJECT_USAGE”
