DBA_CONTEXT

Description of all context namespace information

Columns
   ___________________________
 
   NAMESPACE
      Namespace of the context
   SCHEMA
      Schema of the designated package
   PACKAGE
      Name of the designated package
   TYPE
      Type of the context create

Related:

DBA_GLOBAL_CONTEXT