Oracle: V$SESSION_CONNECT_INFO

select
  sci.authentication_type,
  sci.osuser,
  sci.client_charset,
  sci.client_connection,
  sci.client_oci_library,
  sci.client_version,
  sci.client_driver,
  sci.client_lobattr,
  sci.network_service_banner,
  sci.client_regid
from
  v$session              ses join
  v$session_connect_info sci on ses.sid = sci.sid
where
  ses.audsid = sys_context('userenv', 'sessionid');