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