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