Oracle PL/SQL Tutorial/System Tables Data Dictionary/session context
Query session_context
SQL> column namespace format a10
SQL> column attribute format a10
SQL> column value format a10
SQL> select * from session_context;
NAMESPACE ATTRIBUTE VALUE
---------- ---------- ----------
DR$APPCTX IDXID
REGISTRY$C NAMESPACE SERVER
TX
SQL>