Use dbms_session.AppCtxTabTyp and dbms_session.list_context to display context : dbms_session « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. dbms_session

SQL>
SQL> declare
  2      l_AppCtx     dbms_session.AppCtxTabTyp;
  3      l_size        number;
  4  begin
  5      dbms_session.list_context( l_AppCtx, l_size );
  6      for i in 1 .. l_size loop
  7          dbms_output.put( l_AppCtx(i).namespace || '.' );
  8          dbms_output.put( l_AppCtx(i).attribute || ' = ' );
  9          dbms_output.put_line( l_AppCtx(i).value );
 10      end loop;
 11  end;
 12  /
DR$APPCTX.IDXID =
REGISTRY$CTX.NAMESPACE = SERVER

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>