Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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 | 8)

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 | 8)

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