V$OBJECT_DEPENDENCY
V$OBJECT_DEPENDENCY
displays the objects depended on by a package, procedure, or cursor that is currently loaded in the shared pool. For example, together with V$SESSION
and V$SQL
, this view (指的是V$OBJECT_DEPENDENCY
)can be used to determine which tables are used in the SQL statement that a user is currently executing.
译文:
V$OBJECT_DEPENDENCY
显示当前(加载)存在与shared pool中的package, procedure和 cursor这三种library cache object所依赖(使用)的library cache object有哪些。例如,配合V$SESSION和V$SQL这两个视图,
V$OBJECT_DEPENDENCY视图就可以查出用户(利用
V$SESSION
查出用户信息)正在执行的SQL语句(利用
V$SQL
查出