select
  sid,                                     -- SID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  authentication_type,                     -- AUTHENTICATION_TYPE VARCHAR2(26)
  osuser,                                  -- OSUSER VARCHAR2(30)
  network_service_banner,                  -- NETWORK_SERVICE_BANNER VARCHAR2(4000)
  client_charset,                          -- CLIENT_CHARSET VARCHAR2(40)
  client_connection,                       -- CLIENT_CONNECTION VARCHAR2(13)
  client_oci_library,                      -- CLIENT_OCI_LIBRARY VARCHAR2(27)
  client_version,                          -- CLIENT_VERSION VARCHAR2(40)
  client_driver,                           -- CLIENT_DRIVER VARCHAR2(9)
  client_lobattr,                          -- CLIENT_LOBATTR VARCHAR2(23)
  client_regid                             -- CLIENT_REGID NUMBER
from
  gv$session_connect_info
where
  inst_id = USERENV('Instance')