V$SESSION_CONNECT_INFO

V$SESSION_CONNECT_INFO displays information about network connections for all currently logged in sessions.

Column Datatype Description
SID NUMBER Session identifier (can be used to join this view with V$SESSION)
SERIAL# NUMBER Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. (Can be used to join this view with V$SESSION.)
AUTHENTICATION_TYPE VARCHAR2(26) How the user was authenticated:

  • DATABASE - Username/password authentication

  • OS - Operating system external user authentication

  • NETWORK - Network protocol or ANO authentication

  • PROXY - OCI proxy connection authentication

  • SERVER

  • PASSWORD

  • EXTERNAL ADAPTERS

  • INTERNAL

  • GLOBAL

  • EXTERNAL

  • PASSWORD BASED GLOBAL USER
OSUSER VARCHAR2(30) External username for this database user
NETWORK_SERVICE_BANNER VARCHAR2(4000) Product banners for each Oracle Net service used for this connection (one row per banner)
CLIENT_CHARSET VARCHAR2(40) Client character set as specified in the NLS_LANG environment variable or in the OCIEnvNlsCreate() call; Unknown if the Oracle client is older than release 11.1 or the connection is through the JDBC thin driver
CLIENT_CONNECTION VARCHAR2(13) Client server connection flags:

  • Heterogeneous

  • Homogeneous
CLIENT_OCI_LIBRARY VARCHAR2(27) OCI client library:

  • Home-based

  • Full Instant Client

  • XE Instant Client

  • Light Weight Instant Client

  • OCI

  • Unknown
CLIENT_VERSION VARCHAR2(40) Client library version number
CLIENT_DRIVER VARCHAR2(9) Client driver name
CLIENT_LOBATTR VARCHAR2(23) Client LOB flags:

  • Client Temp Lob Rfc On

  • Client Temp Lob Rfc Off
CLIENT_REGID NUMBER Query cache registration ID sent by the client