Dynamic Performance (V$) Views, 97 of 179

V$OBJECT_DEPENDENCY

This view can be used to determine what objects are 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, it can be used to determine which tables are used in the SQL statement that a user is currently executing.

See Also:
"V$SESSION" and "V$SQL".

Column Datatype Description

FROM_ADDRESS

RAW(4)

The address of a procedure, package, or cursor that is currently loaded in the shared pool

FROM_HASH

NUMBER

The hash value of a procedure, package, or cursor that is currently loaded in the shared pool

TO_OWNER

VARCHAR2(64)

The owner of the object that is depended on

TO_NAME

VARCHAR2(1000)

The name of the object that is depended on

TO_ADDRESS

RAW(4)

The address of the object that is depended on. These can be used to look up more information on the object in V$DB_OBJECT_CACHE

TO_HASH

NUMBER

The hash value of the object that is depended on. These can be used to look up more information on the object in V$DB_OBJECT_CACHE

TO_TYPE

NUMBER

The type of the object that is depended on

Column	Datatype	Description
`FROM_ADDRESS`	`RAW(4)`	The address of a procedure, package, or cursor that is currently loaded in the shared pool
`FROM_HASH`	`NUMBER`	The hash value of a procedure, package, or cursor that is currently loaded in the shared pool
`TO_OWNER`	`VARCHAR2(64)`	The owner of the object that is depended on
`TO_NAME`	`VARCHAR2(1000)`	The name of the object that is depended on
`TO_ADDRESS`	`RAW(4)`	The address of the object that is depended on. These can be used to look up more information on the object in V$DB_OBJECT_CACHE
`TO_HASH`	`NUMBER`	The hash value of the object that is depended on. These can be used to look up more information on the object in V$DB_OBJECT_CACHE
`TO_TYPE`	`NUMBER`	The type of the object that is depended on