DBA Data[Home] [Help]

VIEW: SYS.V_$GLOBALCONTEXT

Source

View Text - Preformatted

select SUBSTR(namespace,1,30) "NAMESPACE",
         SUBSTR(attribute,1,30) "ATTRIBUTE",
         value "VALUE",
         SUBSTR(username,1,30) "USERNAME",
         clientidentifier "CLIENT_IDENTIFIER",
         con_id "CON_ID"
         from v$globalcontext
View Text - HTML Formatted

SELECT SUBSTR(NAMESPACE
, 1
, 30) "NAMESPACE"
, SUBSTR(ATTRIBUTE
, 1
, 30) "ATTRIBUTE"
, VALUE "VALUE"
, SUBSTR(USERNAME
, 1
, 30) "USERNAME"
, CLIENTIDENTIFIER "CLIENT_IDENTIFIER"
, CON_ID "CON_ID"
FROM V$GLOBALCONTEXT