select namespace,attribute,value,username,clientidentifier
from v$globalcontext
where clientidentifier is null or clientidentifier = SYS_CONTEXT('USERENV','CLIENT_IDENTIFIER')
View Text - HTML Formatted
SELECT NAMESPACE , ATTRIBUTE , VALUE , USERNAME , CLIENTIDENTIFIER
FROM V$GLOBALCONTEXT
WHERE CLIENTIDENTIFIER IS NULL OR CLIENTIDENTIFIER = SYS_CONTEXT('USERENV' , 'CLIENT_IDENTIFIER')