DBA Data[Home] [Help]

VIEW: SYS.GV_$SESSION_CONNECT_INFO

Source

View Text - Preformatted

select "INST_ID","SID","SERIAL#","AUTHENTICATION_TYPE","OSUSER","NETWORK_SERVICE_BANNER","CLIENT_CHARSET","CLIENT_CONNECTION","CLIENT_OCI_LIBRARY","CLIENT_VERSION","CLIENT_DRIVER","CLIENT_LOBATTR","CLIENT_REGID","CON_ID" from gv$session_connect_info
View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "SERIAL#"
, "AUTHENTICATION_TYPE"
, "OSUSER"
, "NETWORK_SERVICE_BANNER"
, "CLIENT_CHARSET"
, "CLIENT_CONNECTION"
, "CLIENT_OCI_LIBRARY"
, "CLIENT_VERSION"
, "CLIENT_DRIVER"
, "CLIENT_LOBATTR"
, "CLIENT_REGID"
, "CON_ID"
FROM GV$SESSION_CONNECT_INFO