How to list all context namespaces in Oracle DB?

Question

If I create a context namespace: -

CREATE OR REPLACE CONTEXT hr_security
    USING hr.pkg_security
    ACCESSED GLOBALLY;

How can I list all such namespaces and see their properties. For example, it hr_securitycan be accessed globally and can be installed from a package pkg_security.

Answer 1

DBA_CONTEXT ( [ALL_CONTEXT][1]) , . ALL_CONTEXT , , . DBA_CONTEXT . , DBA_CONTEXT ( SELECT ANY DICTIONARY SELECT_CATALOG_ROLE , )

SELECT namespace,
       schema,
       package,
       type
  FROM dba_context

HR_SECURITY, , PKG_SECURITY TYPE ACCESSED GLOBALLY.