V$OBJECT_DEPENDENCY

Oracle 11gR1

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

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	Hash value of a procedure, package, or cursor that is currently loaded in the shared pool
TO_OWNER	VARCHAR2(64)	Owner of the object that is depended on
TO_NAME	VARCHAR2(1000)	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	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	Type of the object that is depended on

Note:

Oracle dynamic performance views

DBA_DEPENDENCIES

Oracle 11gR1

DBA_DEPENDENCIES describes all dependencies in the database between procedures, packages, functions, package bodies, and triggers, including dependencies on views created without any database links. Its columns are the same as those in ALL_DEPENDENCIES.

Related Views

· ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database links. This view does not display the SCHEMAID column.

· USER_DEPENDENCIES describes dependencies between objects in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(17)		Type of the object
REFERENCED_OWNER	VARCHAR2(30)		Owner of the referenced object (remote owner if remote object)
REFERENCED_NAME	VARCHAR2(64)		Name of the referenced object
REFERENCED_TYPE	VARCHAR2(17)		Type of the referenced object
REFERENCED_LINK_NAME	VARCHAR2(128)		Name of the link to the parent object (if remote)
SCHEMAID	NUMBER		ID of the current schema
DEPENDENCY_TYPE	VARCHAR2(4)		Indicates whether the dependency is a REF dependency (REF) or not (HARD)

Note:

1.

select * from DBA_DEPENDENCIES where owner = 'CSMIG';

OWNER	NAME	TYPE	REFERENCED_ OWNER	REFERENCED_ NAME	REFERENCED_ TYPE	REFERENCED_ LINK_NAME	DEPENDENCY_ TYPE
CSMIG	CSMV$TRIGGERS	VIEW	SYS	USER$	TABLE		HARD
CSMIG	CSMV$TABLES	VIEW	SYS	USER$	TABLE		HARD
CSMIG	CSMV$INDEXES	VIEW	SYS	USER$	TABLE		HARD
CSMIG	CSMV$INDEXES	VIEW	CSMIG	CSM$INDEXES	TABLE		HARD
CSMIG	CSMV$TABLES	VIEW	CSMIG	CSM$TABLES	TABLE		HARD
CSMIG	CSMV$TRIGGERS	VIEW	CSMIG	CSM$TRIGGERS	TABLE		HARD

Oracle data dictionary views

DBA_CONTEXT

Oracle 11gR1

DBA_CONTEXT provides all context namespace information in the database. Its columns are the same as those in "ALL_CONTEXT".

Related View

ALL_CONTEXT describes all context namespaces in the current session for which attributes and values have been specified using the DBMS_SESSION.SET_CONTEXT procedure. This view does not display the TYPE column.

Column	Datatype	NULL	Description
NAMESPACE	VARCHAR2(30)	NOT NULL	Name of the context namespace
SCHEMA	VARCHAR2(30)	NOT NULL	Schema name of the designated package that can set attributes using this namespace
PACKAGE	VARCHAR2(30)	NOT NULL	Package name of the designated package that can set attributes using this namespace
TYPE	VARCHAR2(22)		Type of the context: · ACCESSED LOCALLY · INITIALIZED EXTERNALLY · ACCESSED GLOBALLY · INITIALIZED GLOBALLY

Note:

1.

select * from DBA_CONTEXT;

NAMESPACE	SCHEMA	PACKAGE	TYPE
WK$CONTEXT	WKSYS	WK_ADM	ACCESSED LOCALLY
DR$APPCTX	CTXSYS	DRIXMD	ACCESSED LOCALLY
REGISTRY$CTX	SYS	DBMS_REGISTRY_SYS	ACCESSED LOCALLY
LT_CTX	SYS	LT_CTX_PKG	ACCESSED LOCALLY
WK$CTX_LDAP	WKSYS	WK_ADM	ACCESSED LOCALLY
SDR_REPLICATION_CTX	APP_UTILITY	SDR_REPLICATION	ACCESSED LOCALLY

Oracle data dictionary views