对V$OBJECT_DEPENDENCY视图的说明

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 withV$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查出SQL语句信息）所要用到的表有哪些。

See Also:

"V$SESSION" and"V$SQL"

ColumnDatatypeDescriptionFROM_ADDRESSRAW(4 | 8)Address of a procedure, package, or cursor that is currently loaded in the shared poolFROM_HASHNUMBERHash value of a procedure, package, or cursor that is currently loaded in the shared pool

TO_NAME

VARCHAR2(1000)

Name of the object that is depended onTO_ADDRESSRAW(4 | 8)Address of the object that is depended on. These can be used to look up more information on the object inV$DB_OBJECT_CACHE.TO_HASHNUMBERHash value of the object that is depended on. These can be used to look up more information on the object inV$DB_OBJECT_CACHE.TO_TYPENUMBERType of the object that is depended on

注释说明：

开头为from的两个列描述的是package, procedure和 cursor这三种library cache object，而

开头为to的四个列描述的是package, procedure和 cursor这三种library cache object所依赖（使用）的library cache object。

如TO_HASH列的上述说明“Hash value of the object that is depended on. These can be used to look up more information on the object inV$DB_OBJECT_CACHE.”里说到：package, procedure和 cursor这三种library cache object所依赖（使用）的对象也在V$DB_OBJECT_CACHE里，而 V$DB_OBJECT_CACHE描述的就是library cache object，所以package, procedure和 cursor这三种library cache object所依赖（使用）的对象就是为library cache object。

例子：

select * from emp这个SQL语句（有两个子游标）使用（依赖）到表EMP：

SQL> select a.*,to_char(to_hash,'xxxxxxxxxx') Hex_HASH_VALUE

  2  from V$OBJECT_DEPENDENCY  a where to_name='EMP';

 

FROM_ADD  FROM_HASH   TO_OWNER             TO_NAME       TO_ADDRE     TO_HASH    TO_TYPE   HEX_HASH_VALUE

-------- ---------- -------------------- -------------------- -------- ---------- ---------- -----------

52D9EA28    2648707557      SCOTT                     EMP                  52D9DEBC     828228010            2          315dc1aa

52D9EA28    2648707557      EYGLE                     EMP                  52D82E58       1930491453          2          7310f63d

参见：http://blog.csdn.net/haiross/article/details/10069071