Search notes:

Oracle: CONTEXT$

context$ stores the associations of contexts to the context package.
select
   own.name    context_owner,
   obj.name    context_name,
   con.schema  context_pkg_schema,
   con.package context_pkg_name,
   con.flags   context_flags,
   obj.type# -- 44 (= context)
from
   context$ con                            join
   obj$     obj on con.obj#   = obj.obj#   join
   user$    own on obj.owner# = own.user#
;

See also

The Oracle object type context.

Index